From: Jyoti Seth <jyotiseth2001@gmail.com>
To: pgsql-sql@postgresql.org
Subject: backup and restore
Date: Fri, 8 May 2009 15:01:01 +0530
Message-ID: <004201c9cfbf$b6becab0$243c6010$@com> (raw)
In-Reply-To: <4A03C276.9050007@postnewspapers.com.au>
References: <4A03C276.9050007@postnewspapers.com.au>
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.
Thanks,
Jyoti
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: jyotiseth2001@gmail.com
Subject: Re: backup and restore
In-Reply-To: <004201c9cfbf$b6becab0$243c6010$@com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox