| 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: | URGENT issue: pg-xlog growing on master! |
| Date: | 2013-06-10 11:29:46 |
| Message-ID: | BCE969C3-612D-4622-8E7D-B3241D23EEA4@autouncle.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-performance |
Hi, My pg_xlog dir has been growing rapidly the last 4 days, and my disk is now almost full (1000Gb) even though the database is only 50Gb. I have a streaming replication server running, and in the log of the slave it says:
cp: cannot stat `/var/lib/postgresql/9.2/wals/0000000200000E1B000000A9': No such file or directory
cp: cannot stat `/var/lib/postgresql/9.2/wals/0000000200000E1B000000A9': No such file or directory
2013-06-10 11:21:45 GMT FATAL: could not connect to the primary server: could not connect to server: No route to host
Is the server running on host "192.168.0.4" and accepting
TCP/IP connections on port 5432?
All the time.
I have tried to restart the server, but that didn't help. I checked the master, and the file /var/lib/postgresql/9.2/wals/0000000200000E1B000000A9 does not exist! I'm pretty lost here, can someone help me solve this and get my master server cleaned up. What is causing this, and what do I need to do?
Kind regards
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Dinesh Kumar | 2013-06-10 11:47:38 | Re: URGENT issue: pg-xlog growing on master! |
| Previous Message | Amit Kapila | 2013-06-10 09:02:20 | Re: Not same plan between static and prepared query |