Skip to main content

Postgres Backup

Compatibility​

PostgreSQL Compatibility​

VersionSupport
PostgreSQL 11✔
PostgreSQL 12✔
PostgreSQL 13✔
PostgreSQL 14✔
PostgreSQL 15✔
PostgreSQL 16✔
PostgreSQL 17✔

Supports all editions of PostgreSQL. Including managed services like Amazon RDS, Azure Database for PostgreSQL, and Google Cloud SQL as long as you have access to the database server.

Supported Backup Types​

Backup TypeSupport
Full✔

All PostgreSQL versions supports full backups only supporting the pg_dump utility.

I. Adding a Server​

The first and foremost step involves adding a server. In the platform selection, select PostgreSQL.

II. Setting up the Agent​

The second step is to set up the agent on your server. Follow the linux agent installation guide to set up the agent on your Linux server.

note

Kindly make sure that the agent is running with sufficient privileges to access the PostgreSQL server.

III. Setting up the connection​

After the agent is installed and running, you need to set up the connection to your PostgreSQL instance. PettiCloud requires you to specify the following details:

  • Host: The hostname or IP address of your PostgreSQL server.
  • Port: The port number on which your PostgreSQL server is running (default is 5432).
  • User: The username to connect to the PostgreSQL server.
  • Password: The password for the specified user.
  • Authentication Database: The database to authenticate against (default is postgres).

Now click on authenticate to verify the connection. If the connection is successful, you will be navigated to the Create Backup Job page where you can create your first backup job.

IV. Creating a Backup Job​

Once the connection is set up, you can create a backup job. The backup job allows you to specify the type of backup you want to perform, the frequency of the backup, and other options. You can choose to perform a full backup of your PostgreSQL database. The backup job can also be exclusive to a single database or all databases in the PostgreSQL server. You can start the backup job after specifying the required jobs.

V. Viewing Snapshots​

Once the backup job is created, you can view the snapshots of your PostgreSQL database in the dashboard. The snapshots will show the details of the backup, including the size, type, and status.

With this, your PostgreSQL backup is set up and running. You can now manage your backups from the PettiCloud dashboard.

Known Limitations​

Snapshot sizes greater than 1,048,576,000,000 bytes (~ 976 GiB) are not supported.