On Tuesday 09 January 2007 07:32, Carlson, James (Jim) wrote:
> I have two Linux servers running with one as a hot standby should the
> primary fail. It is not critical that they be in sync with every
> transaction, but I would like to sync them up with a cron job in the
> middle of the night.
>
>
>
> Dose anyone have a suggestion on how to do this?
You can certainly use a cron job to dump and reload the database, but you
might want to look at other ways of doing this such as:
http://slony.info
Sean