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 <[EMAIL PROTECTED]> http://momjian.us EnterpriseDB http://postgres.enterprisedb.com + If your life is a hard drive, Christ can be your backup. + -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers