2011/8/10, Greg Smith <g...@2ndquadrant.com>: > On 08/10/2011 02:46 PM, Geoffrey Myers wrote: >> Is the max connections value in a system table somewhere?
Yes, it is in the table "pg_catalog.pg_database". The column is named "datconnlimit" and is of type "int4". See this: http://www.postgresql.org/docs/9.0/interactive/catalog-pg-database.html. But this would be the appropiate way of getting the value: > SELECT CAST(current_setting('max_connections') AS integer); You would rather use that form instead of messing up with the catalogs. -- Diego Augusto Molina diegoaugustomol...@gmail.com ES: Por favor, evite adjuntar documentos de Microsoft Office. Serán desestimados. EN: Please, avoid attaching Microsoft Office documents. They shall be discarded. LINK: http://www.gnu.org/philosophy/no-word-attachments.html -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
