recovering using a continuous archive backup doesn't work on Windows

From: "Sabin Coanda" <sabin(dot)coanda(at)deuromedia(dot)ro>
To: pgsql-admin(at)postgresql(dot)org
Subject: recovering using a continuous archive backup doesn't work on Windows
Date: 2007-03-20 15:14:54
Message-ID: etotp3$1itm$1@news.hub.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

Hi there,

I try to use WAL support for backup/recovery on Windows.

I applied the procedures from PostgreSQL 8.2.3 Documentation / 23.3.3.
Recovering using a Continuous Archive Backup.

I set the following archive commands:
- archive_command = 'copy "%p" "D:/Program
Files/PostgreSQL/8.2/test_sabin/%f"' #in postgresql.conf
- restore_command = 'copy "D:/Program Files/PostgreSQL/8.2/test_sabin/%f"
"%p"' #in recovery.conf

At the step 8, I start Postgresql Windows service. It starts, work about 30
seconds, then silently stops. In the event viewer I found just one message:
'The PostgreSQL Database Server 8.2 service entered the stopped state'. I
found no log in ../data/pg_log/, and my recovery.conf file is not renamed to
'recovery.done'.

What's happen ?

TIA,
Sabin

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Tom Lane 2007-03-20 15:25:59 Re: log localization
Previous Message Sabin Coanda 2007-03-20 11:59:26 log localization