How could one duplicate the same environment configuration as a database server?

Question

I'm interested in making my local postgres server config match the production one. Given a psql connection to it, would it be possible to run some queries and extract the relevant performance options? Alternatively, if this is not possible, does anyone know the configuration options for heroku's paid postgres plans?

Answer 1

This will show you all settings for the server.

SELECT current_setting(name), * FROM pg_catalog.pg_settings

Then you can look at the postgresql.conf to see what has been set manually.

If you don't have any access to the postgresql.conf, use the above query on some other server and see what's different :)