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:
In response to
pgsql-novice by date
|Next:||From: Bruno Wolff III||Date: 2007-01-09 17:09:00|
|Subject: Re: Column Name = column does not exist|
|Previous:||From: Carlson, James (Jim)||Date: 2007-01-09 12:32:16|
|Subject: Keeping a Backup database in sync with the primary|