From: Sabin Coanda <sabin.coanda@deuromedia.ro>
To: pgsql-admin@postgresql.org
Subject: recovering using a continuous archive backup doesn't work on Windows
Date: Tue, 20 Mar 2007 17:14:54 +0200
Message-ID: <etotp3$1itm$1@news.hub.org> (raw)
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
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: sabin.coanda@deuromedia.ro
Subject: Re: recovering using a continuous archive backup doesn't work on Windows
In-Reply-To: <etotp3$1itm$1@news.hub.org>
* 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