Re: Replication broken. Stale data in slave Database

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(dot)olivares(at)snowflakesoftware(dot)com
Website: www.snowflakesoftware.com
Twitter: @sflakesoftware <http://www,twitter(dot)com(at)sflakesoftware/>
Follow us on LinkedIn <http://www.linkedin.com/company/snowflake-software>

*Winner of IHS Jane's ATC Award - Enabling Technology*
*Read more <http://www.snowflakesoftware.com/2015/03/janes-award/>*

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

On 24 June 2015 at 17:17, Gilberto Castillo <gilberto(dot)castillo(at)etecsa(dot)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*
*Read more <http://www.snowflakesoftware.com/2015/03/janes-award/>*