X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id 3DEF55E46F3 for ; Fri, 27 Aug 2004 05:03:38 -0300 (ADT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 02919-01 for ; Fri, 27 Aug 2004 08:03:33 +0000 (GMT) Received: from puesto4.vayven.info (142.Red-213-98-15.pooles.rima-tde.net [213.98.15.142]) by svr1.postgresql.org (Postfix) with ESMTP id E37B25E3639 for ; Fri, 27 Aug 2004 05:03:28 -0300 (ADT) Received: by puesto4.vayven.info (Postfix, from userid 1000) id C6A43168103; Fri, 27 Aug 2004 10:03:07 +0200 (CEST) Date: Fri, 27 Aug 2004 10:03:07 +0200 From: pablobarbachano@yahoo.es To: pgsql-admin@postgresql.org Subject: backups and WAL Message-ID: <20040827080307.GA7494@vayven.info> Reply-To: pablobarbachano@yahoo.es Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline User-Agent: Mutt/1.5.6+20040803i X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=2.0 tagged_above=0.0 required=5.0 tests=NO_REAL_NAME, RCVD_IN_NJABL_DUL, RCVD_IN_RFCI X-Spam-Level: * X-Archive-Number: 200408/271 X-Sequence-Number: 14666 Hi, first of all thanks for postgresql, it has never given a problem and is performing great. Now my question: my employer wants to do backups every 12 hours, and save the logs evry 2 hours to... Can I simply save the logs (cp pg_xlog/* ...) or do I need something more elaborate? Now in a restore situation ... I restore the database, and then what? put the saved files back in the pg_xlog/ dir, then start postmaster and magically all starts working? Am I correct or completely insane? The documentation is not clear in that aspect... Thanks in advance, Pablo.