PostgreSQL logical incremental backup for version 9.6 and above

From: girish R G peetle <giri(dot)anamika0(at)gmail(dot)com>
To: pgsql-admin <pgsql-admin(at)postgresql(dot)org>
Subject: PostgreSQL logical incremental backup for version 9.6 and above
Date: 2019-11-06 17:02:59
Message-ID: CAKKd0665D1uOCGE+4TSSiMbQjZ6GmCatwgJ+RadNV_S3jhKLsg@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

Hi,
I've a requirement to backup incremental data from PostgreSQL database
server which are hosted as 'database as a service' like 'Amazon RDS' ,
Azure Database etc.

Full dump can be taken using pg_dump. But is there is a way to capture
incremental changes to the database ? I read about logical replication
slots which can be created for each database to capture incremental
changes.
But how do we know from where we should backup the SQL statements (as we
need need skip those statements already backed up by pg_dump).

I thinking of following steps.
Step 1: Create logical replication slot
Step 2: Run pg_dump ( for full load ).
Step 3: Capture the changes since last pg_dump using replication slot - How
to know this information ?

Thanks in advance for any advise.

Thanks
Girish

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message PASCAL CROZET 2019-11-06 19:05:24 RE : PostgreSQL logical incremental backup for version 9.6 and above
Previous Message Andreas Joseph Krogh 2019-11-05 11:40:09 Re: Create a logical and physical replication