Summary
The pg_dump and pg_dumpall tools can be used to create a backup of a PostgreSQL database. pg_dump can be used to back up a single table, multiple tables, or an entire database
1
, while pg_dumpall can be used to back up all databases at once.
2
The dumps can be output in script or archive file formats.
3
4
pg_dump does not block other users accessing the database while the backup is being created.
3
4
According to
Summary
This tutorial provides step-by-step instructions on how to backup PostgreSQL databases using the pg_dump and pg_dumpall tools. It explains how to backup one database, all databases, and only database objects, as well as how to use the pg_dumpall tool to back up all databases at once. It also provides tips on how to use the pg_dumpall tool to back up all databases at once, as it prevents parallel restore and takes longer to process the backup process.
Backup Databases Using PostgreSQL Backup Tools: pg_dump & pg_dumpall
postgresqltutorial.com
Summary
This blog post provides an overview of the two built-in backup utilities, pg_dump and pg_dumpall, for PostgreSQL databases. It explains how to back up a single table, multiple tables, and a database, as well as how to customize the backup and create a script file. It also provides tips on how to use pg_dump to create a script file and how to use pg_dumpall to back up a cluster database.
Backup PostgreSQL Using pg_dump and pg_dumpall | Severalnines
severalnines.com
Summary
pg_dump is a utility for backing up a PostgreSQL database. It makes consistent backups even if the database is being used concurrently. pg_dump does not block other users accessing the database (readers or writers).
Dumps can be output in script or archive file formats.
PostgreSQL: Documentation: 9.0: pg_dump
postgresql.org
The idea behind this dump method is to generate a text file with SQL commands that, when fed back to the server, will recreate the database in the same state ...
PostgreSQL: Documentation: 9.1: SQL Dump
postgresql.org
Summary
pg_dump is a utility for backing up a PostgreSQL database. It makes consistent backups even if the database is being used concurrently. pg_dump does not block other users accessing the database (readers or writers).
Dumps can be output in script or archive file formats.
pg_dump
iac.es
pg_dump internally executes SELECT statements. If you have problems running pg_dump , make sure you are able to select information from the database using, for ...
PostgreSQL: Documentation: 9.3: pg_dump
postgresql.org
You will learn how to copy a PostgreSQL database on the same database server or from a ... PostgreSQL makes it easy to do it via the CREATE DATABASE statement ...
PostgreSQL Copy Database Made Easy
postgresqltutorial.com
We often need to export a dump from one database and then import it into another. Here is ... for restoring from a plain SQL script file created with pg_dump ...
Backup and Restore a PostgreSQL Database
axiomq.com
pg_dump internally executes SELECT statements. If you have problems running pg_dump , make sure you are able to select information from the database using, for ...
PostgreSQL: Documentation: 9.1: pg_dump
postgresql.org
