Received: from localhost (maia-3.hub.org [200.46.204.184]) by postgresql.org (Postfix) with ESMTP id B75A29FB4D7 for ; Mon, 19 Mar 2007 05:28:05 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.184]) (amavisd-new, port 10024) with ESMTP id 16104-06 for ; Mon, 19 Mar 2007 05:28:02 -0300 (ADT) Received: from news.hub.org (news.hub.org [200.46.204.72]) by postgresql.org (Postfix) with ESMTP id 5369F9FB3EE for ; Mon, 19 Mar 2007 05:28:05 -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 l2J8S3Yj095462 for ; Mon, 19 Mar 2007 05: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 l2J7wRl5091462 for pgsql-admin@postgresql.org; Mon, 19 Mar 2007 04:58:27 -0300 (ADT) (envelope-from news) From: "Sabin Coanda" X-Newsgroups: pgsql.admin Subject: WAL based backup/recovery clarifications Date: Mon, 19 Mar 2007 09:58:34 +0200 Organization: Hub.Org Networking Services Lines: 19 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/115 X-Sequence-Number: 24939 Hi there, I'd like to use WAL, but I need some clarifications about the backup/recovery procedure. In Postgresql v8.2.3 documentation, I found I have to make backup between pg_start_backup/pg_stop_backup executions, using tar/cpio tools. May I use pg_dumpall instead ? Is it enough to restore the database later with WAL ? If I cannot use pg_dumpall, please tell me exactly what are the directories that have to be archived. I note that I use a standard configuration on Windows. TIA, Sabin