Search code examples
postgresqlcoverity-prevent

backing up coverity PostgreSQL database to file

We have the "coverity" tool setup and are trying to find a way to backup the database to a file, it uses I believe PostgreSQL. How can we do this, is it using its own independent installation of PostgreSQL?

Solution

  • If it does use PostgreSQL, then there should be a pg_dump utility somewhere in the PostgreSQL installation.

    Taking backups using pg_dump is very well explained in the manual:

    http://www.postgresql.org/docs/current/static/backup-dump.html
    http://www.postgresql.org/docs/current/static/app-pgdump.html