Re: [ADMIN] Too many WAL archive files

2013-09-17 Thread Keith Ouellette
t manually? Thanks, Keith From: Matheus de Oliveira [matioli.math...@gmail.com] Sent: Saturday, September 14, 2013 11:55 AM To: Keith Ouellette Cc: pgsql-admin@postgresql.org Subject: Re: [ADMIN] Too many WAL archive files On Sat, Sep 14, 2013 at 11:19 AM, Keith

Re: [ADMIN] Too many WAL archive files

2013-09-14 Thread Jorge Torralba
You should consider using the cleanup command in your recovery.conf file, this will make sure that wal files no longer needed by the secondary server are eliminated. If you need the wal files for PITR, yo could also setup your archive command to rchive the wal files to two different locations. a s

Re: [ADMIN] Too many WAL archive files

2013-09-14 Thread Matheus de Oliveira
On Sat, Sep 14, 2013 at 11:19 AM, Keith Ouellette < keith.ouelle...@airgas.com> wrote: > My company is using PostgreSQL 9.1 for one of our applications. We have > it set up replicating between two sites using WAL and Pacemaker to manage > the cluster and failover. I have noticed that archive fold