on_heroku.txt

             name             |                                                                                                setting                                                                                                
------------------------------+-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
 application_name             | psql
 archive_command              | test -f /etc/postgresql/wal-e.d/ARCHIVING_OFF || envdir /etc/postgresql/wal-e.d/env wal-e wal-push %p
 archive_mode                 | on
 archive_timeout              | 60
 bytea_output                 | escape
 checkpoint_completion_target | 0.7
 checkpoint_segments          | 40
 client_encoding              | UTF8
 client_min_messages          | notice
 cpu_index_tuple_cost         | 0.001
 cpu_operator_cost            | 0.0005
 cpu_tuple_cost               | 0.003
 DateStyle                    | ISO, MDY
 default_text_search_config   | pg_catalog.english
 effective_cache_size         | 675000
 extwlist.extensions          | btree_gist,chkpass,citext,cube,dblink,dict_int,dict_xsyn,earthdistance,fuzzystrmatch,hstore,isn,ltree,pg_stat_statements,pg_trgm,pgcrypto,pgrowlocks,pgstattuple,plpgsql,tablefunc,unaccent,uuid-ossp
 hot_standby                  | on
 hot_standby_feedback         | on
 lc_collate                   | en_US.UTF-8
 lc_ctype                     | en_US.UTF-8
 lc_messages                  | en_US.UTF-8
 lc_monetary                  | en_US.UTF-8
 lc_numeric                   | en_US.UTF-8
 lc_time                      | en_US.UTF-8
 listen_addresses             | *
 local_preload_libraries      | pgextwlist
 log_checkpoints              | on
 log_destination              | syslog
 log_line_prefix              | %u [BLACK] 
 log_lock_waits               | on
 log_min_duration_statement   | 50
 log_min_messages             | notice
 log_timezone                 | UTC
 logfebe.identity             | 25b09bc9-c115-4915-bdea-6a2f1dfeccf5
 logfebe.unix_socket          | /tmp/pg_logplexcollector/pg_logplexcollector.sock
 logging_collector            | on
 maintenance_work_mem         | 65536
 max_connections              | 500
 max_prepared_transactions    | 500
 max_stack_depth              | 2048
 max_standby_archive_delay    | -1
 max_standby_streaming_delay  | -1
 max_wal_senders              | 10
 port                         | 5432
 random_page_cost             | 2
 server_encoding              | UTF8
 shared_buffers               | 187392
 ssl                          | on
 ssl_renegotiation_limit      | 0
 synchronous_commit           | local
 synchronous_standby_names    | follower
 syslog_ident                 | resource3006113_heroku_com
 TimeZone                     | UTC
 transaction_deferrable       | off
 transaction_isolation        | read committed
 transaction_read_only        | off
 wal_buffers                  | 1024
 wal_keep_segments            | 61
 wal_level                    | hot_standby
 work_mem                     | 102400

really-local.txt

➜  discourse git:(bo-upgrade-to-0.9) psql discourse_development                   
psql (9.2.4)
Type "help" for help.

discourse_development=# select name, setting from pg_settings where source <> 'default';
            name            |                 setting                 
----------------------------+-----------------------------------------
 application_name           | psql
 client_encoding            | UTF8
 config_file                | /usr/local/var/postgres/postgresql.conf
 data_directory             | /usr/local/var/postgres
 DateStyle                  | ISO, MDY
 default_text_search_config | pg_catalog.english
 hba_file                   | /usr/local/var/postgres/pg_hba.conf
 ident_file                 | /usr/local/var/postgres/pg_ident.conf
 lc_collate                 | en_US.UTF-8
 lc_ctype                   | en_US.UTF-8
 lc_messages                | en_US.UTF-8
 lc_monetary                | en_US.UTF-8
 lc_numeric                 | en_US.UTF-8
 lc_time                    | en_US.UTF-8
 log_timezone               | US/Eastern
 max_connections            | 20
 max_stack_depth            | 2048
 server_encoding            | UTF8
 shared_buffers             | 200
 TimeZone                   | US/Eastern
 transaction_deferrable     | off
 transaction_isolation      | read committed
 transaction_read_only      | off
 wal_buffers                | 8
(24 rows)

discourse_development=#