recovery via base + WAL replay failure - Mailing list pgsql-general

From Rob Adams
Subject recovery via base + WAL replay failure
Date
Msg-id 48964A93.1090406@cox.net
Whole thread Raw
Responses Re: recovery via base + WAL replay failure  (Magnus Hagander <magnus@hagander.net>)
Re: recovery via base + WAL replay failure  (Greg Smith <gsmith@gregsmith.com>)
List pgsql-general
I'm trying to demonstrate recovery using the "continuous archiving"
backup technique.  I'm using 8.3 on Windows.

I made a base backup while the postgres was running using the following
batch file:

--------------------------
psql -d test_database -U user_name -c "SELECT pg_start_backup('test');"

7za a -tzip "C:\backup\base.zip" "C:\Program Files\PostgreSQL\8.3\data"

psql -d test_database -U user_name -c "SELECT pg_stop_backup();"
--------------------------

No indication of any errors.  However, I am unable to recover.  Here are
my steps:

1. Stop service, replace the data directory w/ the base backup.
2. Create recovery.conf with this setting:
    restore_command = 'copy C:\backup\%f "%p"'
3. Try to start service

After about 90 seconds, the dos prompt displays:
   "(postgres 8.3) service could not be started"
   "The service did not report an error"

Does anyone know what I am probably doing wrong?

Thanks,
--Rob Adams

pgsql-general by date:

Previous
From: "Hiroshi Saito"
Date:
Subject: Re: pgsql-general@postgresql.org.
Next
From: Lew
Date:
Subject: [OT] newsreader issue? (Was: bytea encode performance issues)