Best results in other decks

If you have a PostgreSQL dump in the custom format you can can view the text format dump (plain SQL statements). PostgreSQL 12 and newer Write it as a textdump...

pg_restore $dumpname -f name.textdump Applying parameters You can apply the same parameters for the output of the textdump as for restoring the dump (for e.g. --clean...

This card is just about creating simple PostgreSQL dumps. This is no instruction for a backup strategy nor a guide for SQL dump performance optimization. Read before starting

...mind that you should stop the replication on a slave PostgreSQL server before creating dumps Dumps can get huge, be careful so that the system running a production PostgreSQL won...