I found error log entries in the Windows Event Viewer:
----------------
2008-08-01 23:57:55 GMT FATAL: could not remove old lock file
"postmaster.pid": Permission denied
2008-08-01 23:57:55 GMT HINT: The file seems accidentally left over,
but it could not be removed. Please remove the file by hand and try again.
----------------
However, there is no postmaster.pid file in the data directory. (I
can't find one anywhere else, either.)
Any ideas?
Thanks,
--Rob Adams
Lennin Caro wrote:
what error show the log file?
--- On Mon, 8/4/08, Greg Smith <gsmith@xxxxxxxxxxxxx> wrote:
From: Greg Smith <gsmith@xxxxxxxxxxxxx>
Subject: Re: [GENERAL] recovery via base + WAL replay failure
To: "Rob Adams" <robfadams@xxxxxxx>
Cc: "postgres general" <pgsql-general@xxxxxxxxxxxxxx>
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@xxxxxxxxxxxxx http://www.gregsmith.com
Baltimore, MD
--
Sent via pgsql-general mailing list
(pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
