Too many clients.

"Belcher, Jim" schrieb:

In 7.0 am i supposed to set the number of users or something.

After running for awhile and try to use psql, psql complains about
too many clients. After that, clients cannot connect either.

Hello Jim,

sounds like this is answered in a FAQ! Please check this:
http://www.postgresql.org/docs/faq-english.html#3.9

Best Regards,

Jos� Manuel Lorenzo L�pez

--
**********************************************************************
** Jos� Manuel Lorenzo L�pez **
** **
** ICA Informationssysteme Consulting & Anwendungsgesellschaft mbH **
** Dept. SAP Basis R/3 VBue **
** **
** phone: (+49511) 938-2961 **
** fax : (+49511) 938-2270 **
** e-mail to: jose-manuel.lorenzo-lopez@conti.de **
**********************************************************************

you also want to make sure that your application is releasing the
connections. if you never release a connection, it won't matter how high
you set the connection parameter...

-----Original Message-----
From: pgsql-general-owner@postgresql.org
[mailto:pgsql-general-owner@postgresql.org]On Behalf Of Jose Manuel
Lorenzo Lopez
Sent: Friday, February 02, 2001 10:21 AM
To: Belcher, Jim
Cc: pgsql-general@postgresql.org
Subject: Re: Too many clients.

"Belcher, Jim" schrieb:

In 7.0 am i supposed to set the number of users or something.

After running for awhile and try to use psql, psql complains about
too many clients. After that, clients cannot connect either.

Hello Jim,

sounds like this is answered in a FAQ! Please check this:
http://www.postgresql.org/docs/faq-english.html#3.9

Best Regards,

Jos� Manuel Lorenzo L�pez

--
**********************************************************************
** Jos� Manuel Lorenzo L�pez **
** **
** ICA Informationssysteme Consulting & Anwendungsgesellschaft mbH **
** Dept. SAP Basis R/3 VBue **
** **
** phone: (+49511) 938-2961 **
** fax : (+49511) 938-2270 **
** e-mail to: jose-manuel.lorenzo-lopez@conti.de **
**********************************************************************

Hi,

I've recently updated my PostgreSQL 6.5 to version 7.0.3. I had dumped all data
and reloaded it correctly. It is running in a Pentium III 550 in RedHat 6.1. My
problem is that one of my databases, although it is running correctly and all
data is retrievable, can't be dumped. As soon as I do a 'pg_dump buscamores', I
receive the following error:

getInherits(): SELECT failed. Explanation from backend: 'ERROR: Attribute 'inhrel' not found
'.

I tried to do the same in 7.0.2 with the same database and it performs the
dumping. None of my tables use the concept of inheritance nor foreign keys. I
need the dump for backup purposes.

One more thing: pg_attribute doesn't have this attribute. Is this an extra
requirement of 7.0.3 that hasn't been satisfied by the initdb and the 'psql -e
buscamores < buscamores.out'?

Please help me !!!

Thanks in advance,

Fernando del Valle
SysAdmin

Fernando del Valle <fdv@statics.com.ar> writes:

getInherits(): SELECT failed. Explanation from backend: 'ERROR: Attribute 'inhrel' not found
'.

You're using the wrong version of pg_dump for the database (still 6.5
pg_dump, probably). Check your PATH...

regards, tom lane

Fernando del Valle writes:

getInherits(): SELECT failed. Explanation from backend: 'ERROR: Attribute 'inhrel' not found
'.

You must use the pg_dump that came with 6.5 to dump databases running on a
6.5 server, and you must use 7.0's pg_dump for 7.0's databases.

--
Peter Eisentraut peter_e@gmx.net http://yi.org/peter-e/