Skip site navigation (1) Skip section navigation (2)

Re: backup and restore

From: Jasen Betts <jasen(at)xnet(dot)co(dot)nz>
To: pgsql-sql(at)postgresql(dot)org
Subject: Re: backup and restore
Date: 2009-05-09 11:05:59
Message-ID: gu3o2n$n0$ (view raw, whole thread or download thread mbox)
Lists: pgsql-sql
On 2009-05-08, Jyoti Seth <jyotiseth2001(at)gmail(dot)com> wrote:
> Hello,
> I have two databases db1 and db2 with the same database structure on
> different systems with no network connection. In the first system with the
> db1 database user updates the master data. At the end of every day, the user
> needs to take the backup of updated data of master tables on db1 and update
> the data on another system with db2 database.
> We can't use WAL as in this as we want to take incremental backup of few
> tables only and can't use slony as there is no network connection between
> the systems.
> Please suggest some solution.

some sort of diff?

dump the tables you are interested in in a known order

(perhaps use "copy from select .... order by .... " )

compare it with yesterdays 

ship the differences.

dump the table at the remote end
apply the patch
truncate the table and load the patched version.

In response to

pgsql-sql by date

Next:From: Tom LaneDate: 2009-05-09 14:33:47
Subject: Re: Distinct oddity
Previous:From: Maximilian TyrtaniaDate: 2009-05-09 07:22:24
Subject: Re: Distinct oddity

Privacy Policy | About PostgreSQL
Copyright © 1996-2017 The PostgreSQL Global Development Group