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@gregsmith.com> wrote:
>
>> From: Greg Smith <gsmith@gregsmith.com>
>> Subject: Re: [GENERAL] recovery via base + WAL replay failure
>> To: "Rob Adams" <robfadams@cox.net>
>> 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 gsmith@gregsmith.com 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
>
>
>
>
>
