Re: Replication broken. Stale data in slave Database

[Alberto Olivares <alberto.olivares@xxxxxxxxxxxxxxxxxxxxx>]

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

Tel.: +44 (0)2380 386578

Email: alberto.olivares@xxxxxxxxxxxxxxxxxxxxx

Website: www.snowflakesoftware.com
Twitter: @sflakesoftware

Follow us on LinkedIn

Winner of IHS Jane's ATC Award - Enabling Technology

Read more

Registered in England & Wales. Registered Number: 4294244

-----------------------------------------------------------------------------------------

On 24 June 2015 at 17:17, Gilberto Castillo <gilberto.castillo@xxxxxxxxx> 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

Read more