Re: [ADMIN] ssl database connection problems...

2008-12-30 Thread Ray Stell
On Tue, Dec 30, 2008 at 03:53:37PM -0500, Carol Walter wrote: > > OpenSSL is telling me that ssl is > not properly configured. how so? >> openssl verify -CAfile ./root.crt testcert.pem can you verify the server crt against the CA? That is the starting place. -- Sent via pgsql-admin mailing

Re: [ADMIN] ssl database connection problems...

2008-12-30 Thread Carol Walter
Thanks to all of you. Many of my problems have been fixed. My "listening_addresses" was not set correctly. After I fixed that problem, I started getting an SSL error. I'm now getting this error as follows: walt...@fac-staff:~$ psql -U walterc -d walterc -h db -p 5433 psql: SSL SYSCALL e

Re: [ADMIN] postgres block_size problem

2008-12-30 Thread Scott Marlowe
On Tue, Dec 30, 2008 at 12:56 PM, Tom Lane wrote: > "Scott Marlowe" writes: >> On Tue, Dec 30, 2008 at 5:28 AM, Bhujbal, Santosh >> wrote: >>> SQL execution failed, Internal error. SQL Statement: (COPY command failed >>> with error: ERROR: row is too big: size 8200, maximum size 8136) > >> Hmmm

Re: [ADMIN] postgres block_size problem

2008-12-30 Thread Tom Lane
"Scott Marlowe" writes: > On Tue, Dec 30, 2008 at 5:28 AM, Bhujbal, Santosh > wrote: >> SQL execution failed, Internal error. SQL Statement: (COPY command failed >> with error: ERROR: row is too big: size 8200, maximum size 8136) > Hmmm. What exactly are you trying to insert into what? Normal

Re: [ADMIN] Context-switch storm in 8.1.15

2008-12-30 Thread Scott Marlowe
On Tue, Dec 30, 2008 at 4:02 AM, Iñigo Martinez Lasala wrote: > Hi everybody. > > Recently our company has been granted with a contract for an on-line store > mainteinance. > The website has been developed under J2EE and Postgres 8.1 as database > backend. The system has been working without probl

Re: [ADMIN] postgres block_size problem

2008-12-30 Thread Scott Marlowe
On Tue, Dec 30, 2008 at 5:28 AM, Bhujbal, Santosh wrote: > Hi All, > > We were getting the following error on executing a COPY command on > postgres8.2.0. First and foremost, you need to run the latest version of 8.2, not 8.2.0. .0 releases of postgresql tend to have the most bugs. You're missi

Re: [ADMIN] postgres block_size problem

2008-12-30 Thread Peter Eisentraut
Bhujbal, Santosh wrote: Hi All, We were getting the following error on executing a COPY command on postgres8.2.0. SQL execution failed, Internal error. SQL Statement: (COPY command failed with error: ERROR: row is too big: size 8200, maximum size 8136) So, in order to fix the error we trie

Re: [ADMIN] rebellious pg stats collector (reopened case)

2008-12-30 Thread Laszlo Nagy
alive". Otherwise you'll have trouble with the collector not stopping when you want it to. Look into src/backend/storage/ipc/pmsignal.c: - return (getppid() == PostmasterPid); + return (getppid() != 1); (Obviously this is a hack, but it should work on any Unixish

[ADMIN] postgres block_size problem

2008-12-30 Thread Bhujbal, Santosh
Hi All, We were getting the following error on executing a COPY command on postgres8.2.0. SQL execution failed, Internal error. SQL Statement: (COPY command failed with error: ERROR: row is too big: size 8200, maximum size 8136) So, in order to fix the error we tried increasing the block size t

[ADMIN] Context-switch storm in 8.1.15

2008-12-30 Thread Iñigo Martinez Lasala
Hi everybody. Recently our company has been granted with a contract for an on-line store mainteinance. The website has been developed under J2EE and Postgres 8.1 as database backend. The system has been working without problem for several month, but with Christmas access to web portal has raised a