> "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
> "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
> "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
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
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
*
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
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
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
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
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
10 matches
Mail list logo
