Re: Problem Recovering from Windows PITR

From: "Jim C(dot) Nasby" <decibel(at)decibel(dot)org>
To: "Nykolyn, Andrew" <andrew(dot)nykolyn(at)ngc(dot)com>
Cc: pgsql-admin(at)postgresql(dot)org
Subject: Re: Problem Recovering from Windows PITR
Date: 2007-05-16 00:57:16
Message-ID: 20070516005716.GB11533@nasby.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

On Tue, May 15, 2007 at 05:43:06PM -0400, Nykolyn, Andrew wrote:
> In testing my PITR on windows 8.1.4 I find the server does not go into
> recovery mode and will not start after restoring the base backup and
> setting up the recovery.conf file as described in the PostgreSQL
> documentation. All permissions appear to be set correctly on the new
> data directories and files. There are no log files generated that I can
> see anywhere to give me a clue on what is happening. The service
> message indicates that there are no error messages but the service did
> not start. Does anybody have any ideas on where I should look to solve
> my problem.

Can you launch PostgreSQL from the command line instead? You might get
more output that way... also try increasing the logging verbosity;
setting log_min_messages to debug might help. You could also try
bringing up a postmaster in standalone mode, though I'm not sure if it
will attempt a PITR recovery in that case...
--
Jim Nasby decibel(at)decibel(dot)org
EnterpriseDB http://enterprisedb.com 512.569.9461 (cell)

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message Jim C. Nasby 2007-05-16 00:59:54 Re: How far does interrupting vacuum full rollback?
Previous Message Jim C. Nasby 2007-05-16 00:54:29 Re: query becomes much slower after Postgres 8.2.4 and Postgis 1.2.1 upgrade