Received: from localhost (maia-4.hub.org [200.46.204.183]) by postgresql.org (Postfix) with ESMTP id 5C66E9FBA1A for ; Tue, 20 Mar 2007 12:28:05 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.183]) (amavisd-new, port 10024) with ESMTP id 68202-06 for ; Tue, 20 Mar 2007 12:28:04 -0300 (ADT) Received: from news.hub.org (news.hub.org [200.46.204.72]) by postgresql.org (Postfix) with ESMTP id C9B7F9FBA0C for ; Tue, 20 Mar 2007 12:28:04 -0300 (ADT) Received: from news.hub.org (news.hub.org [200.46.204.72]) by news.hub.org (8.13.8/8.13.8) with ESMTP id l2KFS4IO054235 for ; Tue, 20 Mar 2007 12:28:04 -0300 (ADT) (envelope-from news@news.hub.org) Received: (from news@localhost) by news.hub.org (8.13.8/8.13.8/Submit) id l2KFEt5k052156 for pgsql-admin@postgresql.org; Tue, 20 Mar 2007 12:14:55 -0300 (ADT) (envelope-from news) From: "Sabin Coanda" X-Newsgroups: pgsql.admin Subject: recovering using a continuous archive backup doesn't work on Windows Date: Tue, 20 Mar 2007 17:14:54 +0200 Organization: Hub.Org Networking Services Lines: 25 Message-ID: X-Complaints-To: usenet@news.hub.org X-Priority: 3 X-MSMail-Priority: Normal X-Newsreader: Microsoft Outlook Express 6.00.2900.2180 X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.2180 X-RFC2646: Format=Flowed; Original To: pgsql-admin@postgresql.org X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200703/133 X-Sequence-Number: 24957 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