Replication order - Mailing list pgsql-general

From Martin S
Subject Replication order
Date
Msg-id CAFTQ5y0OErxv919tHPpSDzPOi40rPptdB_+6Av01o_pcEe5SCQ@mail.gmail.com
Whole thread Raw
List pgsql-general
Hello List!


I've been playing around with replication for a few weeks. What I made
was master+slave with both log shipping (NFS on a 3rd server) and
streaming replication.

Before hitting production environment with this schema, I was trying
to reproduce some issues that we may face in the future. You know,
things happens.
One test included shutting down NFS. Replication stopped. I tried to
restart the slave with "-m immediate", and see if it acknowledged that
log shipping wasn't working any more. Didn't work.

I had to edit recovery.conf, and disable log shipping.

The question is, is there any way to set streaming as the primary
replication method? Or timeout log shipping in order to disable it?

May be I'm doing something wrong, so any advice or idea is welcomed.


Thanks!

Martín

pgsql-general by date:

Previous
From: Merlin Moncure
Date:
Subject: Re: postgresql triggers - defining a global resource (java)
Next
From: bricklen
Date:
Subject: Re: Example of a pg_gethostname() function. Feedback?