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?
