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
On 3 Nov 2006 at 13:40, numb3rs wrote:
> Would I then be able to run pg_restore each time autonomously on the
> host machine to load the updated database?
I don't see why not.but you might be better off using replication
- have a look at Slony.
http://gborg.postgresql.org/project/slony1/pro
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?
-
