numb3rs <[EMAIL PROTECTED]> 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° ---------------------------(end of broadcast)--------------------------- TIP 3: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faq
