Re: [HACKERS] Recreating archive_status

2008-03-17 Thread Bruce Momjian
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:

Re: [HACKERS] Recreating archive_status

2007-12-12 Thread Peter Eisentraut
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.postgresq

Re: [HACKERS] Recreating archive_status

2007-12-12 Thread Joshua D. Drake
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 On Wed, 12 Dec 2007 22:28:58 + Simon Riggs <[EMAIL PROTECTED]> 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 thi

[HACKERS] Recreating archive_status

2007-12-12 Thread Simon Riggs
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 di