Re: pg_xlog question - Mailing list pgsql-general

From Mario Weilguni
Subject Re: pg_xlog question
Date
Msg-id 001101c35bf0$40f6f170$1e01c00a@icomedias.com
Whole thread Raw
In response to pg_xlog question  (Mario Weilguni <mweilguni@sime.com>)
Responses Re: pg_xlog question
List pgsql-general
> > If you could replicate/rsync  pg_xlog to another machine, you could get
it
> > correctly in case of failover.
>
> Argh.. I forgot.. Simple option is to sync the pg_xlog while doing
failover. It
> might add some 10 odd sec to failover process but should be bullet proof..
>
> I don't know if PG is nose poking about permissions of those files.
otheriwse
> it might refuse to start.. Check out..
>
> Worth adding to failover HOWTO. I doubt if one exists for postgresql.

Thanks for the response, but syncing pg_xlog separatly (without DRBD device)
is useless, because a failover will take place when there's an error, so the
extra sync of pg_xlog is very likely to fail.

Regards,
    Mario Weilguni



pgsql-general by date:

Previous
From: Peter Eisentraut
Date:
Subject: Re: plPHP -- sort of an announcement.. but not commercial
Next
From: "Sander Steffann"
Date:
Subject: Re: Changing DB ownership