pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
Problem Recovering from Windows PITR
2+ messages / 2 participants
[nested] [flat]

* Problem Recovering from Windows PITR
@ 2007-05-15 21:43  Nykolyn, Andrew <andrew.nykolyn@ngc.com>
  0 siblings, 1 reply; 2+ messages in thread

From: Nykolyn, Andrew @ 2007-05-15 21:43 UTC (permalink / raw)
  To: pgsql-admin

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.

Greatly Appreciated
Andy Nykolyn
Northrop Grumman

^ permalink  raw  reply  [nested|flat] 2+ messages in thread

* Re: Problem Recovering from Windows PITR
@ 2007-05-16 00:57  Jim C. Nasby <decibel@decibel.org>
  parent: Nykolyn, Andrew <andrew.nykolyn@ngc.com>
  0 siblings, 0 replies; 2+ messages in thread

From: Jim C. Nasby @ 2007-05-16 00:57 UTC (permalink / raw)
  To: Nykolyn, Andrew <andrew.nykolyn@ngc.com>; +Cc: 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@decibel.org
EnterpriseDB      http://enterprisedb.com      512.569.9461 (cell)



^ permalink  raw  reply  [nested|flat] 2+ messages in thread


end of thread, other threads:[~2007-05-16 00:57 UTC | newest]

Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2007-05-15 21:43 Problem Recovering from Windows PITR Nykolyn, Andrew <andrew.nykolyn@ngc.com>
2007-05-16 00:57 ` Jim C. Nasby <decibel@decibel.org>

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