recovering using a continuous archive backup doesn't work on Windows - Mailing list pgsql-admin

From Sabin Coanda
Subject recovering using a continuous archive backup doesn't work on Windows
Date
Msg-id etotp3$1itm$1@news.hub.org
Whole thread Raw
List 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



pgsql-admin by date:

Previous
From: Tom Lane
Date:
Subject: Re: log localization
Next
From: "Alexander B."
Date:
Subject: Trigger using Tsearch