Database Reference
In-Depth Information
Backup and Restore
pgAdmin offers a graphical interface to
pg_dump
and
pg_restore
, covered in
“Backup
and Restore” on page 38
. In this section, we'll repeat some of the same examples using
pgAdmin instead of the command line.
If several versions of PostgreSQL or pgAdmin are installed on your computer, it's a good
idea to make sure that the pgAdmin version is using the versions of the utilities that you
expect. Check what the
bin
setting in pgAdmin is pointing to in order to ensure it's the
latest available, as shown in
Figure 4-12
.
Figure 4-12. pgAdmin File→Options
If your server is remote or your databases are huge, we recom‐
mend using the command-line tools for backup and restore in‐
stead of pgAdmin to avoid adding another layer of complexity to
what could already be a pretty lengthy process. Also keep in mind
that if you do a compressed/TAR/directory backup with a newer
version of
pg_dump
, you need to use the same or later version of
pg_restore
.
