Received: from magus.postgresql.org (magus.postgresql.org [87.238.57.229]) by mail.postgresql.org (Postfix) with ESMTP id 9D215FD3E20 for ; Tue, 12 Jun 2012 15:00:23 -0300 (ADT) Received: from mx2.d2.com ([66.251.81.121]) by magus.postgresql.org with esmtp (Exim 4.72) (envelope-from ) id 1SeVO7-0005TH-NJ for pgsql-admin@postgresql.org; Tue, 12 Jun 2012 18:00:22 +0000 Received: from mxb.d2.com ([10.85.4.6]) by mx2.d2.com (8.13.8/8.13.8) with ESMTP id q5CIu6Sb030122 for ; Tue, 12 Jun 2012 11:56:18 -0700 X-ASG-Debug-ID: 1339523985-01d10a738c2790c0001-ysJW5H Received: from mail01.d2.com ([172.16.66.171]) by mxb.d2.com with ESMTP id V99eXy4mFb2Qc9MF for ; Tue, 12 Jun 2012 10:59:45 -0700 (PDT) X-Barracuda-Envelope-From: aalvarez@d2.com Received: from exbew2k3-02.d2.com (exbew2k3-02 [10.78.2.16]) by mail01.d2.com (8.13.8/8.13.8/Debian-3) with ESMTP id q5CHxjhP023155 for ; Tue, 12 Jun 2012 10:59:45 -0700 Received: from [10.126.2.220] ([10.126.2.220] RDNS failed) by exbew2k3-02.d2.com with Microsoft SMTPSVC(6.0.3790.3959); Tue, 12 Jun 2012 10:59:45 -0700 Message-ID: <4FD78390.7050900@d2.com> Date: Tue, 12 Jun 2012 10:59:44 -0700 From: Amador Alvarez User-Agent: Mozilla/5.0 (X11; U; Linux i686 (x86_64); en-US; rv:1.9.2.27) Gecko/20120216 Lightning/1.0b2 Thunderbird/3.1.19 MIME-Version: 1.0 To: pgsql-admin@postgresql.org Subject: Hot backup for postgres 8.4 Content-Type: text/plain; charset=ISO-8859-1; format=flowed X-ASG-Orig-Subj: Hot backup for postgres 8.4 Content-Transfer-Encoding: 7bit X-OriginalArrivalTime: 12 Jun 2012 17:59:45.0073 (UTC) FILETIME=[263A6210:01CD48C5] X-Barracuda-Connect: UNKNOWN[172.16.66.171] X-Barracuda-Start-Time: 1339523985 X-Barracuda-URL: http://10.85.4.6:8000/cgi-mod/mark.cgi X-Virus-Scanned: by bsmtpd at d2.com X-Barracuda-Spam-Score: 0.00 X-Barracuda-Spam-Status: No, SCORE=0.00 using per-user scores of TAG_LEVEL=1000.0 QUARANTINE_LEVEL=1000.0 KILL_LEVEL=9.0 tests= X-Barracuda-Spam-Report: Code version 3.2, rules version 3.2.2.99659 Rule breakdown below pts rule name description ---- ---------------------- -------------------------------------------------- X-Spam-Status: NO, score=-1.7 required=3.0 tests=ALL_TRUSTED,AWL,BAYES_05, RATWARE_GECKO_BUILD autolearn=ham version=3.2.4 X-Spam-Checker-Version: SpamAssassin 3.2.4 (2008-01-01) on mx2.d2.com X-Pg-Spam-Score: -1.9 (-) X-Archive-Number: 201206/63 X-Sequence-Number: 39654 Hi there, I have been looking for a good solution to backup a postgresql 8.4 database server (not pg_dump) and the only options that it seems that I have are either a Omnipitr or a custom-coded solution. I am a little bit afraid about setting up omipitr in production for archiving & backup, even though it has been running seamlessly on a testing environment. I wish I could use pg_basebackup but unfortunately it is V. 9 oriented. Does anyone have production experience with Omnipitr ? If not, is there something out there trustworthy enough for production use ? Thanks in advance, A.A.