Postgres Pro
Downloads
Home   >   mailing lists

Re: Replication broken. Stale data in slave Database - Mailing list pgsql-admin

From Alberto Olivares
Subject Re: Replication broken. Stale data in slave Database
Date
Msg-id CAGdoAziW74B9ve7uXMJemqVKJLZaPBYk6zc-9uo2qfsDKOQufA@mail.gmail.com
Whole thread Raw
In response to Re: Replication broken. Stale data in slave Database  ("Gilberto Castillo" <gilberto.castillo@etecsa.cu>)
Responses Re: Replication broken. Stale data in slave Database
List pgsql-admin
Tree view
Hi Gilberto,

Thanks for your answer.

Do you know how to configure the pg_archivecleanup just in the event the primary database goes down?

Regards,
Alberto.

Alberto Olivares Colas
Technical Consultant
Snowflake Software



Winner of IHS Jane's ATC Award - Enabling Technology

Registered in England & Wales. Registered Number: 4294244
-----------------------------------------------------------------------------------------




On 24 June 2015 at 17:17, Gilberto Castillo <gilberto.castillo@etecsa.cu> wrote:

> Hi John and Gilberto,
>
> Thanks for your answer.
>
> We have a synchronous streaming replication. Database is PostgreSQL 9.1.15
> on linux.


Uhmmmm, see you:
http://www.postgresql.org/docs/current/static/pgarchivecleanup.html

In 9.1 use script what delete for date the wal more old.


Saludos,
Gilberto Castillo
ETECSA, La Habana, Cuba



Winner of IHS Jane's ATC Award - Enabling Technology

pgsql-admin by date:

Previous
From: "Gilberto Castillo"
Date:
Subject: Re: Replication broken. Stale data in slave Database
Next
From: "Gilberto Castillo"
Date:
Subject: Re: Replication broken. Stale data in slave Database