Database Reference
In-Depth Information
Backing Up an Entire Database
In
“Selective Backup Using pg_dump” on page 38
, we demonstrated how to back up a
database. To repeat the same steps using the pgAdmin interface, right-click the database
you want to back up and choose Custom for format, as shown in
Figure 4-13
.
Figure 4-13. Backup database
Backing up system-wide objects
pgAdmin provides a graphical interface to
pg_dumpall
for backing up system objects.
To use the interface, first connect to the server you want to back up. Then, from the top
menu, choose Tools→Backup Globals.
pgAdmin doesn't give you control over which global objects to back up, as the
command-line interface does. pgAdmin backs up all tablespaces and roles.
If you ever want to back up the entire server, perform a
pg_dumpall
by going to the top
menu and choosing Tools→Backup Server.
Selective backup of database assets
pgAdmin provides a graphical interface to
pg_dump
for selective backup. Right-click the
asset you want to back up and select Backup (see
Figure 4-14
). You can back up an entire
database, a particular schema, a table, or anything else.