Re: Is max connections in a table somewhere?
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
Import Notes
Reply to msg id not found: 4E42D23D.2090907@serioustechnology.comReference msg id not found: 4E42D23D.2090907@serioustechnology.com
On Wed, Aug 10, 2011 at 12:47 PM, Geoffrey Myers
<lists@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
/etc/postgresql/8.x/main for the default cluster. It's in
/var/lib/pgsql/data for RHEL 5. Not sure about other distros.
Import Notes
Reply to msg id not found: 4E42D23D.2090907@serioustechnology.comReference msg id not found: 4E42D23D.2090907@serioustechnology.com | Resolved by subject fallback
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 available in a table (pg_settings).
--
Guillaume
http://blog.guillaume.lelarge.info
http://www.dalibo.com
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 everything.
Actually, it's also available in a table (pg_settings).
Well thats cool, I did not realize there was a table.
-Andy
Scott Marlowe wrote:
On Wed, Aug 10, 2011 at 12:47 PM, Geoffrey Myers
<lists@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
/etc/postgresql/8.x/main for the default cluster. It's in
/var/lib/pgsql/data for RHEL 5. Not sure about other distros.
Yeah, I knew it was in the postgresql.conf file, but since I've got a
piece of code that's already connected to the database, I figured I'd
get it from the database, rather then open the file and read it from there.
--
Geoffrey Myers
Myers Consulting Inc.
770.592.1651