Incremental Refresh - PostgreSQL 9.2

From: "drum(dot)lucas(at)gmail(dot)com" <drum(dot)lucas(at)gmail(dot)com>
To: pgsql-admin(at)postgresql(dot)org
Subject: Incremental Refresh - PostgreSQL 9.2
Date: 2016-02-23 21:59:25
Message-ID: CAE_gQfUqvmewj91Sg81Orc7S+=aO0xG-xftMB4UycByVEdWHZw@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

Hi all,

I've got a Master server and a Test Server.

Master server has a 1.7 TB
Test server has a full copy from master - 1.7 TB.

The copy was made using pg_dump

I.E: /usr/pgsql-9.2/bin/pg_dump --exclude-table-data='junk.*'
--format=custom geoop_live > bigdump.sql

Question:
Now that the test server has a full copy from master, how could I just do a
incremental refreshing once a month?

Instead copying all the DB (1.7GB), just copy what has been changed?
Is that possible?

Cheers

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message David G. Johnston 2016-02-23 22:14:26 Re: Incremental Refresh - PostgreSQL 9.2
Previous Message Venkata Balaji N 2016-02-23 20:58:41 Re: PostgreSQL 9.3.5 - Enable SSL