Incremental Refresh - PostgreSQL 9.2 - Mailing list pgsql-admin

From drum.lucas@gmail.com
Subject Incremental Refresh - PostgreSQL 9.2
Date
Msg-id CAE_gQfUqvmewj91Sg81Orc7S+=aO0xG-xftMB4UycByVEdWHZw@mail.gmail.com
Whole thread Raw
Responses Re: Incremental Refresh - PostgreSQL 9.2
Re: Incremental Refresh - PostgreSQL 9.2
List 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

pgsql-admin by date:

Previous
From: Venkata Balaji N
Date:
Subject: Re: PostgreSQL 9.3.5 - Enable SSL
Next
From: "David G. Johnston"
Date:
Subject: Re: Incremental Refresh - PostgreSQL 9.2