Thread: script for unidirectional database update

Hi,

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?

Thanks,

Markus

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