Received: from localhost (unknown [200.46.204.184]) by postgresql.org (Postfix) with ESMTP id AF72D2E00F8 for ; Thu, 21 Feb 2008 19:31:23 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.184]) (amavisd-maia, port 10024) with ESMTP id 84058-01 for ; Thu, 21 Feb 2008 19:31:15 -0400 (AST) Received: from eurogama.ro (mail.eurogama.ro [89.37.121.198]) by postgresql.org (Postfix) with ESMTP id A6E1C2E00F1 for ; Thu, 21 Feb 2008 19:31:20 -0400 (AST) Received: (qmail 3527 invoked by uid 210); 22 Feb 2008 03:08:27 +0200 Received: from 89.42.16.17 by mail (envelope-from , uid 201) with qmail-scanner-1.25st (spamassassin: 3.0.2. perlscan: 1.25st. Clear:RC:0(89.42.16.17):SA:0(-2.6/6.0):. Processed in 0.224239 secs); 22 Feb 2008 01:08:27 -0000 Received: from unknown (HELO server) (lucid@eurogama.ro@89.42.16.17) by 0 with SMTP; 22 Feb 2008 03:08:26 +0200 From: "Lucian DRAGUS" To: "'Shilpa Sudhakar'" , References: <47BE07ED.1070802@internode.com.au> Subject: unsubscribe Date: Fri, 22 Feb 2008 01:31:40 +0200 Message-ID: <002801c874e1$e955ff50$6a0aa8c0@server> MIME-Version: 1.0 Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: 7bit X-Mailer: Microsoft Office Outlook 11 X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.3198 In-Reply-To: <47BE07ED.1070802@internode.com.au> Thread-Index: Ach07sI+nMr3KdG3QhK+8Pk17w+03wADONQg X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0 tagged_above=0 required=5 tests=none X-Spam-Level: X-Archive-Number: 200802/273 X-Sequence-Number: 28347 -----Original Message----- From: pgsql-admin-owner@postgresql.org [mailto:pgsql-admin-owner@postgresql.org] On Behalf Of Shilpa Sudhakar Sent: Friday, February 22, 2008 1:23 AM To: pgsql-admin@postgresql.org Subject: [ADMIN] WAL archiving Hi All, I am new to postgres and have been slowly learning the concepts. Regarding WAL archiving, we first take a base backup and then save all the wal logs for PITR. Both the base backup and wal logs are stored in another disk. Since the wal logs keep increasing, do we take the base backup every now and then so that we can delete the old log files? How often do we take a base filesystem backup keeping in mind that our systems are 24 x 7. Any suggestions are appreciated. Thanks and Regards, Shilpa ---------------------------(end of broadcast)--------------------------- TIP 9: In versions below 8.0, the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match