From: "Markus Wagner" <wagner@imsd.uni-mainz.de>
> I need to periodically transfer the content of one db into another. The
> target db should be deleted before and there should be one ascii file
> containing the data, because there's a firewall between the two db's and
> file transfer ist the most simple thing to do. Does anyone have a script
> to automate this?
>
Look into pg_dumpall
- Richard Huxton