On Thu, Nov 1, 2012 at 1:21 AM, Christian Hammers <ch@xxxxxxxxxxxx> wrote: > Hello > > I run two PostgreSQL servers in a master-slave setup and set > wal_keep_segments=1000 on the master to allow long downtimes on the slave. > > Meanwhile the disk got fuller than I estimated and I changed the config > to wal_keep_segments=500 and restarted the server afterwards. > > Yet, the number of WAL segments in my archive dir was still at 1000! > > I tried a random mix of VACUUM, CHECKPOINT, pg_start_backup(), > pg_stop_backup(), server restarts, googling and just plain waiting > but the number of archived WAL segments just increased to 1018. wal_keep_segments affects the WAL files in pg_xlog directory, not archive directory. When and how to remove archived files is basically responsibility of a user. Regards, -- Fujii Masao -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
