Menu
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?
691
On either the source or destination SQL Server instance, launch the Copy Database Wizard in SQL Server Management Studio from Object Explorer and expand Databases. Then right-click a database, point to Tasks, and then select Copy Database.
Data duplication means that a data source has multiple records, usually with different syntaxes for the same object. This problem has been recognized as extremely important to many organizations, due to the size and complexity of today's database systems.
How many database instances are used during a database-duplication process? Answer : Two.
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 :)
58
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With
