pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
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)



view thread (2+ messages)

Message-ID: <20070516005716.GB11533@nasby.net>
Permalink:  ../20070516005716.GB11533@nasby.net/
Also on:    postgresql.org/message-id/20070516005716.GB11533@nasby.net

 · 

reply

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