| From: | Niels Kristian Schjødt <nielskristian(at)autouncle(dot)com> |
|---|---|
| To: | "pgsql-performance(at)postgresql(dot)org list" <pgsql-performance(at)postgresql(dot)org> |
| Subject: | pg_xlog dir not getting swept |
| Date: | 2016-06-29 10:00:00 |
| Message-ID: | 21D0DA77-ACC3-4859-A391-03EE0B5D7E76@autouncle.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-performance |
About a day ago, there seems to have been some trouble in the network of my database (postgresql 9.3).
I’m running my db with a streaming replication setup with wall shipping.
I sync wal logs to a mounted networkdrive using archive_command = 'rsync -a %p /mnt/wal_drive/wals/%f </dev/null’. Somehow this command was failing, leading to my pg_xlog dir building up (590Gb). I rebooted the server, and the archiving command seems to succeed now - however - After about an hour of running, the pg_xlog drive has not decreased in size - I would have expect that! I can see that lot’s of files get’s synced to the /mnt/wal_drive/wals dir, but somehow the pg_xlog dir is not swept (yet)? Will this happen automatically eventually, or do I need to do something manually?
PS. I found this blog post http://www.hivelogik.com/blog/?p=513, but I’m unsure if it’s necessary and if it can be dangerous?
Best
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Kevin Grittner | 2016-06-29 12:45:49 | Re: Random slow queries |
| Previous Message | devel.brain99 | 2016-06-29 01:24:14 | Random slow queries |