From: Jim C. Nasby <decibel@decibel.org>
To: Nykolyn, Andrew <andrew.nykolyn@ngc.com>
Cc: pgsql-admin@postgresql.org
Subject: Re: Problem Recovering from Windows PITR
Date: Tue, 15 May 2007 19:57:16 -0500
Message-ID: <20070516005716.GB11533@nasby.net> (raw)
In-Reply-To: <207D25A8ABDD2E4894A0F7E461ACC395590A6A@xcgny106.northgrum.com>
References: <207D25A8ABDD2E4894A0F7E461ACC395590A6A@xcgny106.northgrum.com>
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@decibel.org
EnterpriseDB http://enterprisedb.com 512.569.9461 (cell)
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: decibel@decibel.org, andrew.nykolyn@ngc.com
Subject: Re: Problem Recovering from Windows PITR
In-Reply-To: <20070516005716.GB11533@nasby.net>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox