Skip to content

Instantly share code, notes, and snippets.

@blkperl
Created March 1, 2013 21:08
Show Gist options
  • Save blkperl/5067785 to your computer and use it in GitHub Desktop.
Save blkperl/5067785 to your computer and use it in GitHub Desktop.
portal settings
postgres=# select name,setting || unit as setting from pg_settings where source != 'default';
name | setting
----------------------------+---------
application_name |
client_encoding |
config_file |
data_directory |
DateStyle |
default_text_search_config |
external_pid_file |
hba_file |
ident_file |
lc_collate |
lc_ctype |
lc_messages |
lc_monetary |
lc_numeric |
lc_time |
listen_addresses |
log_line_prefix |
log_timezone |
max_connections | 100
max_stack_depth | 2048kB
port | 5432
server_encoding |
shared_buffers | 30728kB
ssl |
TimeZone |
transaction_deferrable |
transaction_isolation |
transaction_read_only |
unix_socket_directory |
wal_buffers | 968kB
(30 rows)
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment