pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  

help / color / mirror / Atom feed
From: Gilberto Castillo <gilberto.castillo@etecsa.cu>
To: Alberto Olivares <alberto.olivares@snowflakesoftware.com>
Cc: gilberto.castillo@etecsa.cu
Cc: pgsql-admin@postgresql.org
Subject: Re: Replication broken. Stale data in slave Database
Date: Wed, 24 Jun 2015 13:02:47 -0500 (GMT+5)
Message-ID: <39343.192.168.207.54.1435168967.squirrel@webmail.etecsa.cu> (raw)
In-Reply-To: <CAGdoAzjDx+--LWoZD0Wvmw6gWS3G2wQrSCuL-cJO+Z9s+FqHfw@mail.gmail.com>
References: <CAGdoAzgERUntgCy-gG2wpL+g3T1rEDDSa+G88=W6pAFXscJ2mw@mail.gmail.com>
	<37952.192.168.207.54.1435162036.squirrel@webmail.etecsa.cu>
	<CAGdoAzh+QHVPG1a1Ou+USMHAR-M06y=XGa_5_Y53gr_dzQ6xgw@mail.gmail.com>
	<37964.192.168.207.54.1435162661.squirrel@webmail.etecsa.cu>
	<CAGdoAziW74B9ve7uXMJemqVKJLZaPBYk6zc-9uo2qfsDKOQufA@mail.gmail.com>
	<37991.192.168.207.54.1435164476.squirrel@webmail.etecsa.cu>
	<CAGdoAziFN5ywxxM+uznbt+msh1UL4tW_3m4Wmjhm1YoNMfOH2w@mail.gmail.com>
	<39009.192.168.207.54.1435167945.squirrel@webmail.etecsa.cu>
	<CAGdoAzjDx+--LWoZD0Wvmw6gWS3G2wQrSCuL-cJO+Z9s+FqHfw@mail.gmail.com>
List-Unsubscribe: <mailto:majordomo@postgresql.org?body=unsub%20pgsql-admin>


> Hi,
>
> I thought about creating a cron job but we cannot run it monthly, we need
> to do it just in case the replication fails because the master database
> breaks.

You not use failover?
What use for manager the replication?


Saludos,
Gilberto Castillo
ETECSA, La Habana, Cuba



-- 
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin



view thread (16+ messages)  latest in thread

Message-ID: <39343.192.168.207.54.1435168967.squirrel@webmail.etecsa.cu>
Permalink:  ../39343.192.168.207.54.1435168967.squirrel@webmail.etecsa.cu/
Also on:    postgresql.org/message-id/39343.192.168.207.54.1435168967.squirrel@webmail.etecsa.cu

 · 

reply
Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pgsql-admin@postgresql.org
  Cc: gilberto.castillo@etecsa.cu, alberto.olivares@snowflakesoftware.com
  Subject: Re: Replication broken. Stale data in slave Database
  In-Reply-To: <39343.192.168.207.54.1435168967.squirrel@webmail.etecsa.cu>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox