pg.ddx.io pgsql-sql@postgresql.org mailing list archive
help / color / mirror / Atom feedbackup and restore
5+ messages / 4 participants
[nested] [flat]
* backup and restore
@ 2009-05-08 09:31 Jyoti Seth <jyotiseth2001@gmail.com>
2009-05-08 10:28 ` Re: backup and restore Craig Ringer <craig@postnewspapers.com.au>
2009-05-08 11:44 ` Re: backup and restore Gerardo Herzig <gherzig@fmed.uba.ar>
2009-05-09 11:05 ` Re: backup and restore Jasen Betts <jasen@xnet.co.nz>
0 siblings, 3 replies; 5+ messages in thread
From: Jyoti Seth @ 2009-05-08 09:31 UTC (permalink / raw)
To: pgsql-sql
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
^ permalink raw reply [nested|flat] 5+ messages in thread
* Re: backup and restore
2009-05-08 09:31 backup and restore Jyoti Seth <jyotiseth2001@gmail.com>
@ 2009-05-08 10:28 ` Craig Ringer <craig@postnewspapers.com.au>
2009-05-08 10:38 ` Re: backup and restore Craig Ringer <craig@postnewspapers.com.au>
2 siblings, 1 reply; 5+ messages in thread
From: Craig Ringer @ 2009-05-08 10:28 UTC (permalink / raw)
To: Jyoti Seth <jyotiseth2001@gmail.com>; +Cc: pgsql-sql
Wow, I'm impressed. Let me quote part of the message you just replied to
with a TOTALLY UNRELATED NEW THREAD:
"First: Please don't reply to an existing message to create a new
thread. Your mail client copies the replied-to message ID into the
References: header, and well-implemented mail clients will thread your
message under a now-unrelated thread.
Compose a new message instead."
--
Craig Ringer
^ permalink raw reply [nested|flat] 5+ messages in thread
* Re: backup and restore
2009-05-08 09:31 backup and restore Jyoti Seth <jyotiseth2001@gmail.com>
2009-05-08 10:28 ` Re: backup and restore Craig Ringer <craig@postnewspapers.com.au>
@ 2009-05-08 10:38 ` Craig Ringer <craig@postnewspapers.com.au>
0 siblings, 0 replies; 5+ messages in thread
From: Craig Ringer @ 2009-05-08 10:38 UTC (permalink / raw)
To: Jyoti Seth <jyotiseth2001@gmail.com>; +Cc: pgsql-sql
Craig Ringer wrote:
... something kinda rude, in retrospect. Sorry. Unpleasantness is going
around in my immediate environment, and I'm apparently prickly and grumpy.
--
Craig Ringer
^ permalink raw reply [nested|flat] 5+ messages in thread
* Re: backup and restore
2009-05-08 09:31 backup and restore Jyoti Seth <jyotiseth2001@gmail.com>
@ 2009-05-08 11:44 ` Gerardo Herzig <gherzig@fmed.uba.ar>
2 siblings, 0 replies; 5+ messages in thread
From: Gerardo Herzig @ 2009-05-08 11:44 UTC (permalink / raw)
To: Jyoti Seth <jyotiseth2001@gmail.com>; +Cc: pgsql-sql
Jyoti Seth 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.
>
> Thanks,
> Jyoti
>
>
I guess you are triyng to avoid the 'pg_dump - save_to_floppy -
walk_to_db2_place - pg_restore' pattern. Well, can you save `pg_dump' in
some middle place? One place which machine1 and machine2 have access to?
If so, you can kind of automate the job using two programs, one (in the
master) who 'upload' (via ftp maybe, scp or whatever) in this middle
place, ando other in the slave who 'download' and process the file using
pg_restore.
HTH
Gerardo
^ permalink raw reply [nested|flat] 5+ messages in thread
* Re: backup and restore
2009-05-08 09:31 backup and restore Jyoti Seth <jyotiseth2001@gmail.com>
@ 2009-05-09 11:05 ` Jasen Betts <jasen@xnet.co.nz>
2 siblings, 0 replies; 5+ messages in thread
From: Jasen Betts @ 2009-05-09 11:05 UTC (permalink / raw)
To: pgsql-sql
On 2009-05-08, Jyoti Seth <jyotiseth2001@gmail.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.
^ permalink raw reply [nested|flat] 5+ messages in thread
end of thread, other threads:[~2009-05-09 11:05 UTC | newest]
Thread overview: 5+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2009-05-08 09:31 backup and restore Jyoti Seth <jyotiseth2001@gmail.com>
2009-05-08 10:28 ` Craig Ringer <craig@postnewspapers.com.au>
2009-05-08 10:38 ` Craig Ringer <craig@postnewspapers.com.au>
2009-05-08 11:44 ` Gerardo Herzig <gherzig@fmed.uba.ar>
2009-05-09 11:05 ` Jasen Betts <jasen@xnet.co.nz>
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