You can back up a PostgreSQL database safely while it is online by using the native
pg_dump command.
In this example, the database is dumped into a GNU tar formatted file.
Run this command:
-
pg_dump -Ft -b -o ctfdb > ctfdb.tar
Note: For this example, the name of the CollabNet
TeamForge
database is assumed to be
ctfdb.
Tip: See the PostgreSQL pg_dump man page for more
information and examples.