From: | Chris Barnes <compuguruchrisbarnes(at)hotmail(dot)com> |
---|---|
To: | Postgres General Postgres General <pgsql-general(at)postgresql(dot)org> |
Subject: | Re: Archive command seem to be working. |
Date: | 2009-12-23 14:20:36 |
Message-ID: | BLU149-W47A7CB088300A1F94B8DFAD4800@phx.gbl |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Thanks Andrew, I was on vacation and the /var/lib of root did fill up. The on call person was notified and the fix was to copy all of the logs back into /data/pgsql/backup/wal_arch.
Some 6500 files and the copy failed because it couldn't transverse the directory without an error. I moved the files from the server to backup and it started syncing right away.
I will take the perl copy into account. Thank you for the change and response.
Chris :)
From: andrew(dot)crouch(at)ericsson(dot)com
To: compuguruchrisbarnes(at)hotmail(dot)com; pgsql-general(at)postgresql(dot)org
Date: Wed, 23 Dec 2009 03:38:12 +0800
Subject: Re: [GENERAL] Archive command seem to be working.
Hi Chris,
Assuming the error condition is resolved, the process should restart automatically. However, one issue we have found is that there appears to be an upper limit to how many files `test` can actually check for existence. We found that it was returning 1 in error and hence wasn't archiving the files. Replacing test with the perl equivalent seemed to sidestep this issue.
Your archive command would look something like:
perl -e 'exit 1 if -e "/data/pgsql/backups/wal_arch/%f.gz"' && cp %p /var/lib/pgsql/backups/wal_arch/%f
Don't forget to properly escape the quotes.
You should be able to update the archive command by reloading the configuration: '/sbin/service postgresql reload' or equivalent for your system.
After the configuration is loaded (and you aren't hitting any other system limitations) it should begin archiving the files again.
Cheers,
Andrew
From: pgsql-general-owner(at)postgresql(dot)org [mailto:pgsql-general-owner(at)postgresql(dot)org] On Behalf Of Chris Barnes
Sent: terça-feira, 22 de dezembro de 2009 17:03
To: Postgres General Postgres General
Subject: [GENERAL] Archive command seem to be working.
Hi, hoping someone can tell me how to get this running again.
I have pitr running and noticed that the slave is far out of date with wal logs.
Upon investigation I see that on the master that /data/pgsql/backups/wal_logs has over 6000 logs that haven't been moved
to the /var/lib/pgsql/backups/wal_arch/ folder.
The root partition that has /var had been full and logs may have been removed, and it may have run some time in this condition until someone corrected it.
postgresql.conf file.
test ! -f /data/pgsql/backups/wal_arch/%f.gz && cp %p /var/lib/pgsql/backups/wal_arch/%f
Is there a way to restart a service without taking the database down/up?
Any help would be appreciated.
Cheers,
Chris Barnes
Windows Live: Make it easier for your friends to see what you’re up to on Facebook.
_________________________________________________________________
Eligible CDN College & University students can upgrade to Windows 7 before Jan 3 for only $39.99. Upgrade now!
http://go.microsoft.com/?linkid=9691819
From | Date | Subject | |
---|---|---|---|
Next Message | Pau Marc Munoz Torres | 2009-12-23 14:22:45 | Re: Drop/ Alter index if exist |
Previous Message | Grzegorz Jaśkiewicz | 2009-12-23 13:22:04 | Re: reindex |