Browse articles Database backup # How to back up PostgreSQL automatically with Linuxteknosia Cloud Scheduled PostgreSQL backups with pg\_dump: install the agent, add a connection, create a full or per-table incremental job, optional encryption, restore from the dashboard. 1 min readUpdated: October 22, 2026[Baca dalam Bahasa Indonesia](/docs/backup-postgresql) The agent runs `pg_dump` (custom format) on a schedule and streams it to object storage. Incremental mode stores only the tables that changed since the previous backup. ## 1\. Prepare the server Make sure `pg_dump`, `pg_dumpall`, `pg_restore`, and `psql` are on the PATH in a version matching the database server. Incremental mode requires one specific database per job, and incremental restores require a superuser (the restore uses `session_replication_role` and `--disable-triggers`). ## 2\. Install the agent Dashboard → **Servers → Add server**, then run the command shown on the server as root. ```bash curl -fsSL https://linuxteknosia.cloud/install.sh | sudo bash -s -- --server https://linuxteknosia.cloud --token ``` ## 3\. Add a connection and create a job Add a PostgreSQL database connection on the server page, then create a job with the wizard: choose the schedule, Full or Full + incremental mode, retention, and encryption (encrypted or unencrypted). ## 4\. Restore Open the run under **History → Restore**. The target database must already exist. An incremental point is restored as the base full backup plus every incremental up to that point, automatically in order; status and logs are shown on the run page. ## See also - [How to back up MySQL / MariaDB automatically with Linuxteknosia Cloud](/docs/backup-mysql) - [How to back up MongoDB automatically with incremental oplog](/docs/backup-mongodb) - [How to use rclone with Linuxteknosia Cloud](/docs/rclone) Still need help? Open a support ticket from the dashboard and our team will reply as soon as possible. [Help center](/en/help)[Open a ticket](/app/support/new)