Re: [GENERAL] Is max connections in a table somewhere?

2011-08-11 Thread Geoffrey Myers
Adrian Klaver wrote: On Wednesday, August 10, 2011 11:47:25 am Geoffrey Myers wrote: Is max connections in any table in the database I can access? SELECT current_setting('max_connections'); current_setting - 100 Thanks for all the responses folks. Obviously, there's

[GENERAL] Is max connections in a table somewhere?

2011-08-10 Thread Geoffrey Myers
Is max connections in any table in the database I can access? -- Until later, Geoffrey I predict future happiness for America if they can prevent the government from wasting the labors of the people under the pretense of taking care of them. - Thomas Jefferson -- Sent via pgsql-general mailing

Re: [GENERAL] Is max connections in a table somewhere?

2011-08-10 Thread Andy Colson
On 8/10/2011 1:47 PM, Geoffrey Myers wrote: Is max connections in any table in the database I can access? Not really a table, but it is selectable: show max_connections; use show all to see everything. -Andy -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make

Re: [GENERAL] Is max connections in a table somewhere?

2011-08-10 Thread Scott Marlowe
On Wed, Aug 10, 2011 at 12:47 PM, Geoffrey Myers li...@serioustechnology.com wrote: Is max connections in any table in the database I can access? No it's in the postgresql.conf file, which is in various places depending on how pg was installed. for debian / ubuntu it's in

Re: [GENERAL] Is max connections in a table somewhere?

2011-08-10 Thread Guillaume Lelarge
On Wed, 2011-08-10 at 13:41 -0500, Andy Colson wrote: On 8/10/2011 1:47 PM, Geoffrey Myers wrote: Is max connections in any table in the database I can access? Not really a table, but it is selectable: show max_connections; use show all to see everything. Actually, it's also

Re: [GENERAL] Is max connections in a table somewhere?

2011-08-10 Thread Ray Stell
On Wed, Aug 10, 2011 at 02:47:25PM -0400, Geoffrey Myers wrote: Is max connections in any table in the database I can access? edbstore= \d pg_catalog.pg_settings; View pg_catalog.pg_settings Column | Type | Modifiers +-+--- name | text| setting

Re: [GENERAL] Is max connections in a table somewhere?

2011-08-10 Thread Andy Colson
On 8/10/2011 1:49 PM, Guillaume Lelarge wrote: On Wed, 2011-08-10 at 13:41 -0500, Andy Colson wrote: On 8/10/2011 1:47 PM, Geoffrey Myers wrote: Is max connections in any table in the database I can access? Not really a table, but it is selectable: show max_connections; use show all to see

Re: [GENERAL] Is max connections in a table somewhere?

2011-08-10 Thread Geoffrey Myers
Scott Marlowe wrote: On Wed, Aug 10, 2011 at 12:47 PM, Geoffrey Myers li...@serioustechnology.com wrote: Is max connections in any table in the database I can access? No it's in the postgresql.conf file, which is in various places depending on how pg was installed. for debian / ubuntu it's

Re: [GENERAL] Is max connections in a table somewhere?

2011-08-10 Thread Adrian Klaver
On Wednesday, August 10, 2011 11:47:25 am Geoffrey Myers wrote: Is max connections in any table in the database I can access? SELECT current_setting('max_connections'); current_setting - 100 -- Adrian Klaver adrian.kla...@gmail.com -- Sent via pgsql-general mailing list