Postgres Pro
Downloads
Home   >   mailing lists

Thread: Recreating archive_status

Recreating archive_status

From
Simon Riggs
Date:
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

Re: Recreating archive_status

From
"Joshua D. Drake"
Date:
-----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-----

Re: Recreating archive_status

From
Peter Eisentraut
Date:
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/

Re: Recreating archive_status

From
Bruce Momjian
Date:
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 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
> 
> 
> ---------------------------(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. +