| From: | Andreas Kretschmer <akretschmer(at)spamfence(dot)net> |
|---|---|
| To: | pgsql-general(at)postgresql(dot)org |
| Subject: | Re: Odd dump/restore question |
| Date: | 2006-11-03 21:49:51 |
| Message-ID: | 20061103214951.GA20835@KanotixBox |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
numb3rs <vincej(at)gmail(dot)com> schrieb:
> I have Postgresql DB on a local machine that is updated periodically.
> I could have a script that would run pg_dump and then ftp it up to the
> host machine each 15 minutes say.
>
> Would I then be able to run pg_restore each time autonomously on the
> host machine to load the updated database?
I think, you should read more about replication, for instance with
slony. http://gborg.postgresql.org/project/slony1/projdisplay.php
Andreas
--
Really, I'm not out to destroy Microsoft. That will just be a completely
unintentional side effect. (Linus Torvalds)
"If I was god, I would recompile penguin with --enable-fly." (unknow)
Kaufbach, Saxony, Germany, Europe. N 51.05082°, E 13.56889°
| From | Date | Subject | |
|---|---|---|---|
| Next Message | rloefgren | 2006-11-03 22:03:59 | Re: dividing integers not producing decimal fractions |
| Previous Message | Raymond O'Donnell | 2006-11-03 21:49:06 | Re: Odd dump/restore question |