what error show the log file?
--- On Mon, 8/4/08, Greg Smith <[EMAIL PROTECTED]> wrote: > From: Greg Smith <[EMAIL PROTECTED]> > Subject: Re: [GENERAL] recovery via base + WAL replay failure > To: "Rob Adams" <[EMAIL PROTECTED]> > Cc: "postgres general" <pgsql-general@postgresql.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 [EMAIL PROTECTED] http://www.gregsmith.com > Baltimore, MD > > -- > Sent via pgsql-general mailing list > (pgsql-general@postgresql.org) > To make changes to your subscription: > http://www.postgresql.org/mailpref/pgsql-general -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general