Re: recovery via base + WAL replay failure

what error show the log file?

--- On Mon, 8/4/08, Greg Smith <gsmith(at)gregsmith(dot)com> wrote:

> From: Greg Smith <gsmith(at)gregsmith(dot)com>
> Subject: Re: [GENERAL] recovery via base + WAL replay failure
> To: "Rob Adams" <robfadams(at)cox(dot)net>
> Cc: "postgres general" <pgsql-general(at)postgresql(dot)org>
> Date: Monday, August 4, 2008, 5:58 PM
> On Sun, 3 Aug 2008, Rob Adams wrote:
>
> > 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');"
>
> What did you have archive_command set to? That needs to
> dump the WAL
> files generated while the backup is going on somewhere that
> gets copied
> over after the main copy is done, and you need the last of
> them referenced
> by the backup copied over before you can use that backup.
> Steps (1) and
> (5) of
> http://www.postgresql.org/docs/current/static/continuous-archiving.html
>
> are the hard parts here and I don't see that you're
> addressing them so
> far, and that will keep the copy from starting if all the
> files aren't
> there.
>
> --
> * Greg Smith gsmith(at)gregsmith(dot)com http://www.gregsmith.com
> Baltimore, MD
>
> --
> Sent via pgsql-general mailing list
> (pgsql-general(at)postgresql(dot)org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-general