Re: [GENERAL] Postmaster crashes

2001-02-15 Thread Mark Alliban
> "Mark Alliban" <[EMAIL PROTECTED]> writes: > > pq_recvbuf: unexpected EOF on client connection > > Server process (pid 2087) exited with status 139 at Tue Feb 13 15:38:08 2001 > > Terminating any active server processes... > > Server processes

Re: [GENERAL] Number of open files

2001-02-07 Thread Mark Alliban
> "Mark Alliban" <[EMAIL PROTECTED]> writes: > > I have increased file-max to 16000. However after about 24 hours of running, > > pgsql crashed and errors in the log showed that the system had run out of > > memory. I do not have the exact error message, as I

Re: [GENERAL] Number of open files

2001-02-07 Thread Mark Alliban
> "Mark Alliban" <[EMAIL PROTECTED]> writes: > > I am having problems with the number of open files on Redhat 6.1. The value > > of /proc/sys/fs/file-max is 4096 (the default), but this value is reached > > with about 50 ODBC connections. Increasing the file

Re: [GENERAL] Re: Poor performance - need advice

2000-02-03 Thread Mark Alliban
e WHERE ClientNumber=1234566789::int8; > > >Phil Culberson >DAT Services > >-Original Message- >From: Mark Alliban [mailto:[EMAIL PROTECTED]] >Sent: Wednesday, February 02, 2000 10:16 AM >To: [EMAIL PROTECTED] >Subject: [GENERAL] Re: Poor performance - need advice

Re: [GENERAL] Getting value of SERIAL column after insert from libpq?

1999-12-22 Thread Mark Alliban
Thanks for the help, it works great! However, there is a problem with performance. I am moving from MySQL to Postgres, and to test performance I am inserting a large row (30 fields) into a table from my C program. I am running this program 50 times, and timing the results. The MySQL version of th

[GENERAL] Re: SCO Openserver & pg_hba.conf

1999-12-17 Thread Mark Alliban
Hi, Thanks for the suggestion! I've been trying to get it to work for ages and using the -h option was the workaround I was looking for. However I still have a small problem, in that when I do "CREATE UNIQUE INDEX AcT_AcNo ON AccountTable (AccountNo);" where AccountNo is NUMERIC or DECIMAL I get

Re: [GENERAL] Problem in pg_hba.conf

1999-12-13 Thread Mark Alliban
The environment variables are set OK and export'd. >> Yes the postmaster process is running. >> nohup postmaster -i >pgserver.log 2>&1 & >> The log file is empty until I try to create the database, then it gives the >> error. >then the last thing I can think of, is location of data files:) >chcec

Re: [GENERAL] Problem in pg_hba.conf

1999-12-13 Thread Mark Alliban
Yes the postmaster process is running. nohup postmaster -i >pgserver.log 2>&1 & The log file is empty until I try to create the database, then it gives the error. >> I have already done this, and it completed successfully. >> There is a /usr/local/pgsql/data/base/template1 directory with a lot of

Re: [GENERAL] Problem in pg_hba.conf

1999-12-13 Thread Mark Alliban
I have already done this, and it completed successfully. There is a /usr/local/pgsql/data/base/template1 directory with a lot of pg_ files in it. Mark. >> Postgres$ createdb test >> Connection to database 'template1' failed. >do >initdb >You just don't have "default" database. >mazek *

[GENERAL] Problem in pg_hba.conf

1999-12-13 Thread Mark Alliban
Hi,   I have just installed PostgreSQL on SCO OpenServer 5.05 but I am having problems creating a database. My pg_hba.conf file reads:   local    all trusthost all 127.0.0.1 255.255.255.255   trust When I try to create a dat