Okay, I guess it makes sense that I am at 16GB based on your explanation below. I do not have a space constraint, so having 16GB is not the problem. The problem is that we have experienced connectivity issues in the past where replication would not startup. I would do a "manual" sync using rsync for the data directory. That includes the archive directory. I tried to exclude the archive directory, but when restarting PostgreSQL, I would get the archive missing errors in the startup log and PostgreSQL would not start. I guess I could reduce the number from 1000 (which looks like about 55 days with an average of 18 files being created each day) to a lower number. We picked 1000 as this is a new application for us and we did not know how fast the WAL files would fill. If I do make that change, will the excess files be automatically deleted or do I have to do that manually?
Thanks,
Keith
From: Matheus de Oliveira [matioli.matheus@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