Skip to content

Instantly share code, notes, and snippets.

@vadv
Created March 14, 2016 07:42
Show Gist options
  • Save vadv/99b0140c98eb68a1faac to your computer and use it in GitHub Desktop.
Save vadv/99b0140c98eb68a1faac to your computer and use it in GitHub Desktop.
postgres=# select * from pg_file_settings where name = 'max_connections';
sourcefile | sourceline | seqno | name | setting | applied | error
----------------------------------------+------------+-------+-----------------+---------+---------+-------
/var/lib/postgres/data/postgresql.conf | 64 | 1 | max_connections | 100 | t |
(1 row)
postgres=# select * from pg_file_settings where name = 'max_connections';
sourcefile | sourceline | seqno | name | setting | applied | error
----------------------------------------+------------+-------+-----------------+---------+---------+------------------------------
/var/lib/postgres/data/postgresql.conf | 64 | 1 | max_connections | 100 | f |
/var/lib/postgres/data/postgresql.conf | 633 | 13 | max_connections | 200 | f | setting could not be applied
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment