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?