chris kim wrote: > I have a standby server that is in replication mode only, and is storing > an insane amount of wal files and it's only on the standby not the > master. I have over 50,000 wal files right now. I only have a few > processes running on the background and they all seem to not be the > problem. This is running on postgres 9.2. Any help would be greatly > appreciated. Check the "pg_stat_replication" view to see if the standby keeps up applying the changes - failure to do so could be a reason for WAL piling up. If host standby is active, is "max_standby_streaming_delay" configured so that long running transactions on the standby could block replication? Yours, Laurenz Albe -- Sent via pgsql-admin mailing list (pgsql-admin@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin
