Postgres Pro
Downloads
Home   >   mailing lists

backup and restore - Mailing list pgsql-sql

From Jyoti Seth
Subject backup and restore
Date
Msg-id 004201c9cfbf$b6becab0$243c6010$@com
Whole thread Raw
In response to select regexp_matches('a a a', '([a-z]) a','g');  (Craig Ringer <craig@postnewspapers.com.au>)
Responses Re: backup and restore  (Craig Ringer <craig@postnewspapers.com.au>)
Re: backup and restore  (Gerardo Herzig <gherzig@fmed.uba.ar>)
List pgsql-sql
Tree view 
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

pgsql-sql by date:

Previous
From: Craig Ringer
Date:
Subject: select regexp_matches('a a a', '([a-z]) a','g');
Next
From: "Luigi N. Puleio"
Date:
Subject: RAISE NOTICE