Just a note to everyone. I finally managed to scrape enough time out of my
tasklist (by staying late) so I could try this out. Besides some difficulty
with having a RedHat 7.1 / PGSQL 7.2 box on one end and a Mandrake 9.1 /
PGSQL 7.3 box on the other end, everything worked without a hitch.
Th
On Mon, Jun 09, 2003 at 03:24:32PM -0700, Michael A Nachbaur wrote:
> I'm looking at syncronizing two database servers with RServ (production / "hot
> standby"), and I'm trying to figure out a way to get the initial database on
> the slave server syncronized with the master.
>
> Normally, I woul
I think you'd benefit from a two-stage Rsync (this was discussed on this
list in the past few months):
1. Rsync the $PGDATA cluster from the "hot" server to the "standby" server,
with the postmaster running
2. Stop the postmaster and perform the same rsync again (this will take only
a few seconds
"Michael A Nachbaur" <[EMAIL PROTECTED]> wrote:
> I'm looking at syncronizing two database servers with RServ (production /
"hot
> standby"), and I'm trying to figure out a way to get the initial database
on
> the slave server syncronized with the master.
>
> Normally, I would 1) turn off all clien
