Phillip Berry wrote:
Hardware raid controller for both options, but I'm not sure what brand
(yet).
The reason you won't ever find a good general answer to this question is
that it's so close that you need to know the exact controller cards and
the disks used in each situation to have any hope
Hello everybody,
I have a question about the replacement of an item in an index page. I want to
overwrite an existing item inside an index page. However, I noticed that each
time, I replaced an item, the free space in the given page was decreasing. I
didn't want to delete the existing item and i
I uninstall an older version and tried installing 8,4 but now it keeps asking
for a password from Superuser account... Any ideas how to remove this?
Thanks for reading.
_
Windows 7: helpt j
what operating system?
did you try to remove "postgres" system account before installing new version?
2010/3/11 Jowad Bouzian :
> I uninstall an older version and tried installing 8,4 but now it keeps
> asking for a password from Superuser account... Any ideas how to remove
> this?
>
> Thanks fo
Hi,
How are you trying to install it? (Using one click installer...?)
And which version of postgresql did you have earlier?
--
Ashesh Vashi
On Thu, Mar 11, 2010 at 1:01 PM, Jowad Bouzian wrote:
> I uninstall an older version and tried installing 8,4 but now it keeps
> asking for a password fr
On 3/10/2010 11:52 PM, Chris Travers wrote:
>
> There are two major limitations here of schemas:
>
> 1) They can't be nested leading again to possible namespace ambiguity.
> 2) there are a number of requests to try to get the application to
> install into an arbitrary, nonpublic schema.
>
> If sc
I just downloaded and compiled UUID on CENTOS 5.4 x86, I also
downloaded, compiled and installed ossp-uuid
and to install it i execute this as postgres user:
psql -d test_database -U postgres -f /usr/share/pgsql/uuid.sql
SET
SET
psql:/usr/share/pgsql/uuid.sql:37: ERROR: function uuid_in(cstr
On Thu, 2010-03-11 at 13:54 +0100, dunas...@dunasoft.es wrote:
> psql:/usr/share/pgsql/uuid.sql:37: ERROR: function uuid_in(cstring)
> does not exist
> psql:/usr/share/pgsql/uuid.sql:38: ERROR: type "uuid" does not exist
> psql:/usr/share/pgsql/uuid.sql:39: ERROR: function
> uuid_recv(intern
Carsten Kropf writes:
> I have a question about the replacement of an item in an index page. I
> want to overwrite an existing item inside an index page.
Why exactly do you want to do that? How are you going to make it
transactionally correct or crash-safe?
FWIW, I think the ItemIdSetUnused cal
> On 3/10/2010 11:52 PM, Chris Travers wrote:
>>
>> There are two major limitations here of schemas:
>>
>> 1) They can't be nested leading again to possible namespace ambiguity.
>> 2) there are a number of requests to try to get the application to
>> install into an arbitrary, nonpublic schema.
>
Stuart Bishop wrote:
It might be possible to trick csvlog to log to a static filename, and
perhaps substituting that with a named pipe might work (under unix at
least).
As someone who did a bit of the work on the CSV log feature, I'll tell
you the way you have to note the log filename, accoun
On Thu, Mar 11, 2010 at 08:38:46AM -0800, Chris Travers wrote:
> > On 3/10/2010 11:52 PM, Chris Travers wrote:
> > Which
> > i'm at a loss why nesting would help solve any problem what so ever. I
> > imagine the search path on some connections would be all inclusive so
> > ambiguous names is not s
I have written a binary wiki engine using PostgreSQL and FPC - it is
sweet. But, now I have a customer and I am here today to install the
product (along with other tasks) and their Linux box does not run X.
My steps are down perfect, run install from EnteriseDB and drop in my
product and .c
I'm stumped about the best was to retrieve the most recent entry in a
one-to-many type of table and combine it with a more standard query
that joins one-to-one.
I have defined these:
jr...@wykids localhost# \d trainer_dates
Table "public.trainer_dates"
Yes the EnterpriseDB installer works from the shell, try running the
installer with ' --mode text ' or --help for all options available.
On 3/11/10 11:17 PM, Ozz Nixon wrote:
I have written a binary wiki engine using PostgreSQL and FPC - it is
sweet. But, now I have a customer and I am here tod
Greg Smith a écrit :
Rodger Donaldson wrote:
Cyril Scetbon wrote:
Does anyone know what can be the differences between linux kernels
2.6.29 and 2.6.30 that can cause this big difference (TPS x 7 !)
http://www.phoronix.com/scan.php?page=article&item=linux_2624_2633&num=2
http://www.csamuel
2010/3/11 Gerhard Heift :
> On Thu, Mar 11, 2010 at 08:38:46AM -0800, Chris Travers wrote:
>> > On 3/10/2010 11:52 PM, Chris Travers wrote:
>> > Which
>> > i'm at a loss why nesting would help solve any problem what so ever. I
>> > imagine the search path on some connections would be all inclusive
Jeff:
I may not fully understand the situation or the data you're trying to retrieve,
but if you're trying to get "show me all trainers whose current status is
Pending", I would go backwards to how you're doing it. If you're only
concerned about those records with tr_date_name = Pending, then
Hi all,
On a new x86_64 windows 7 SMP, a new database server was being set up by
some test automation. We are using official 8.4.2 binaries.
It runs:
initdb -D c:\... --no-locale
... eventually this outputs the "Success. You can now start the database
server using ..." message. Once that e
Hi again,
I'm going to answer my own question. I think there is a race where two
database servers are being setup on the same port at the same time and
two different tests end up trying to create the same DB on the same
server at the same time.
Let me know if you think I'm wrong :).
Dave V
03/11/2010
The hotel discount deadline is today, 03/11/2010. If you have not
purchased your rooms by the end of today, you will pay at least 60.00
more per night.
The hotel is also reaching capacity. It is doubly worth your attention
to register today if you are seeking to do so. If you do not, y
tengo un problema ya habia replicado los datos en las BD
2010-03-11 19:23:58 DEBUG: pid 8252: starting health checking
2010-03-11 19:23:58 DEBUG: pid 8252: health_check: 0 th DB node status: 1
2010-03-11 19:23:58 DEBUG: pid 8252: health_check: 1 th DB node status: 3
2010-03-11 19:24:28 DEBUG: pid
mation from ESET NOD32 Antivirus, version of virus signature
database 4937 (20100311) __
The message was checked by ESET NOD32 Antivirus.
http://www.eset.com
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
I'm to write a query like:-
select
case when column_name1 <> value_of_previous(column_name1)
then column_name1 end as column
,column_name2
from table
ordered by column_name1, column_name2
in order to get:-
column| column_name2
--+--
value_1_c1
In response to Chris Velevitch :
> I'm to write a query like:-
>
> select
> case when column_name1 <> value_of_previous(column_name1)
> then column_name1 end as column
> ,column_name2
> from table
> ordered by column_name1, column_name2
Okay, with this table:
test=# select * f
Chris Velevitch wrote:
I'm to write a query like:-
select
case when column_name1 <> value_of_previous(column_name1)
then column_name1 end as column
,column_name2
from table
ordered by column_name1, column_name2
in order to get:-
column| column_name2
--+--
26 matches
Mail list logo
