Recreating archive_status
During recovery procedures, there is a step that says
"If you didn't archive pg_xlog/ at all, then recreate it, and be sure to
recreate the subdirectory pg_xlog/archive_status/ as well."
If you forget to do this, you may not realise until the recovering
server comes up and tries writing to the directory. The message that is
spat out when this happens is
LOG: could not create archive status file
"pg_xlog/archive_status/00000001000003CE0000009E.ready": No such file or
directory
We could check this just as the server comes up and then re-create it if
necessary. So we have one less step in the process to remember. Existing
scripts which perform this automatically will not need changing.
We can keep the message in case something removes the directory later.
Views?
--
Simon Riggs
2ndQuadrant http://www.2ndQuadrant.com
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1
On Wed, 12 Dec 2007 22:28:58 +0000
Simon Riggs <simon@2ndquadrant.com> wrote:
We could check this just as the server comes up and then re-create it
if necessary. So we have one less step in the process to remember.
Existing scripts which perform this automatically will not need
changing.We can keep the message in case something removes the directory later.
Views?
+1
Sincerely,
Joshua D. Drake
- --
The PostgreSQL Company: Since 1997, http://www.commandprompt.com/
Sales/Support: +1.503.667.4564 24x7/Emergency: +1.800.492.2240
Donate to the PostgreSQL Project: http://www.postgresql.org/about/donate
SELECT 'Training', 'Consulting' FROM vendor WHERE name = 'CMD'
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.6 (GNU/Linux)
iD8DBQFHYGH0ATb/zqfZUUQRAlwiAJ4/GtkdBhtwFqOv71V8QIkJTg+WwgCglDip
3zLszrv1bmqEsDPRtuj1w04=
=bFdr
-----END PGP SIGNATURE-----
Simon Riggs wrote:
We could check this just as the server comes up and then re-create it if
necessary. So we have one less step in the process to remember. Existing
scripts which perform this automatically will not need changing.
Oh please yes
--
Peter Eisentraut
http://developer.postgresql.org/~petere/
Added to TODO:
o Recreate pg_xlog/archive_status/ if it doesn't exist after
restoring from a PITR backup
http://archives.postgresql.org/pgsql-hackers/2007-12/msg00487.php
---------------------------------------------------------------------------
Simon Riggs wrote:
During recovery procedures, there is a step that says
"If you didn't archive pg_xlog/ at all, then recreate it, and be sure to
recreate the subdirectory pg_xlog/archive_status/ as well."If you forget to do this, you may not realise until the recovering
server comes up and tries writing to the directory. The message that is
spat out when this happens isLOG: could not create archive status file
"pg_xlog/archive_status/00000001000003CE0000009E.ready": No such file or
directoryWe could check this just as the server comes up and then re-create it if
necessary. So we have one less step in the process to remember. Existing
scripts which perform this automatically will not need changing.We can keep the message in case something removes the directory later.
Views?
--
Simon Riggs
2ndQuadrant http://www.2ndQuadrant.com---------------------------(end of broadcast)---------------------------
TIP 6: explain analyze is your friend
--
Bruce Momjian <bruce@momjian.us> http://momjian.us
EnterpriseDB http://postgres.enterprisedb.com
+ If your life is a hard drive, Christ can be your backup. +