Received: from magus.postgresql.org (magus.postgresql.org [87.238.57.229]) by mail.postgresql.org (Postfix) with ESMTP id D6EAE1F2F312 for ; Mon, 13 Feb 2012 15:24:47 -0400 (AST) Received: from mailgate.iii.com ([205.227.88.3]) by magus.postgresql.org with esmtp (Exim 4.72) (envelope-from ) id 1Rx1W1-0002h4-3d for pgsql-admin@postgresql.org; Mon, 13 Feb 2012 19:24:47 +0000 Received: from mailhub.iii.com (mailhub [10.1.2.3]) by mailgate.iii.com (8.13.6/8.13.6) with ESMTP id q1DJO4lY013611; Mon, 13 Feb 2012 11:24:04 -0800 (PST) Received: from [10.1.3.160] ([10.1.3.160]) by mailhub.iii.com (8.13.6/8.13.6) with ESMTP id q1DJTE7G020187; Mon, 13 Feb 2012 11:29:14 -0800 (PST) Message-ID: <4F396377.2080303@iii.com> Date: Mon, 13 Feb 2012 11:24:39 -0800 From: Dinesh Bhandary Reply-To: dbhandary@iii.com Organization: Innovative Interfaces User-Agent: Mozilla/5.0 (Windows NT 6.1; WOW64; rv:8.0) Gecko/20111105 Thunderbird/8.0 MIME-Version: 1.0 To: Kevin Grittner CC: pgsql-admin@postgresql.org Subject: Re: postgres backup ( logical using pg_dump) using AMANDA References: <4F395D23.2090009@iii.com> <4F390C4F0200002500045488@gw.wicourts.gov> In-Reply-To: <4F390C4F0200002500045488@gw.wicourts.gov> Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit X-Pg-Spam-Score: -1.9 (-) X-Archive-Number: 201202/54 X-Sequence-Number: 39114 Yes, by wall logging I meant to say PITR backup. We have a need for logical backup (pg_dump) in addition to PTIR backup using wall logs. I can't quite understand why there is no plugin for pg_dump since it is such a popular tool to do logical backup. Thanks. Dinesh On 2/13/2012 11:12 AM, Kevin Grittner wrote: > Dinesh Bhandary wrote: > >> Has anyone done postgres logical backup (pg_dump) using Amanda ( >> Advanced Maryland Automatic Network Disk Archiver). >> So far I have seen plugin for wall logging method, but have not >> found any information on pg_dump. > > IMO, there aren't many situations where regular backups should be > done with pg_dump instead of PITR backup techniques. (Is that what > you meant by "wall logging method"?) You might take lack of a > pg_dump plugin as a sign that nobody else has yet considered it a > good idea. > > -Kevin > > >