Received: from makus.postgresql.org (makus.postgresql.org [98.129.198.125]) by mail.postgresql.org (Postfix) with ESMTP id C760E144B902 for ; Mon, 13 Feb 2012 17:05:23 -0400 (AST) Received: from plane.gmane.org ([80.91.229.3]) by makus.postgresql.org with esmtp (Exim 4.72) (envelope-from ) id 1Rx35O-0000Es-1t for pgsql-admin@postgresql.org; Mon, 13 Feb 2012 21:05:22 +0000 Received: from list by plane.gmane.org with local (Exim 4.69) (envelope-from ) id 1Rx357-0008Nh-71 for pgsql-admin@postgresql.org; Mon, 13 Feb 2012 22:05:05 +0100 Received: from cpc3-walt15-2-0-cust148.13-2.cable.virginmedia.com ([86.21.186.149]) by main.gmane.org with esmtp (Gmexim 0.1 (Debian)) id 1AlnuQ-0007hv-00 for ; Mon, 13 Feb 2012 22:05:05 +0100 Received: from walterhurry by cpc3-walt15-2-0-cust148.13-2.cable.virginmedia.com with local (Gmexim 0.1 (Debian)) id 1AlnuQ-0007hv-00 for ; Mon, 13 Feb 2012 22:05:05 +0100 X-Injected-Via-Gmane: http://gmane.org/ To: pgsql-admin@postgresql.org From: Walter Hurry Subject: Re: postgres backup ( logical using pg_dump) using AMANDA Date: Mon, 13 Feb 2012 21:04:53 +0000 (UTC) Lines: 14 Message-ID: References: <4F395D23.2090009@iii.com> Mime-Version: 1.0 Content-Type: text/plain; charset=UTF-8 Content-Transfer-Encoding: 8bit X-Complaints-To: usenet@dough.gmane.org X-Gmane-NNTP-Posting-Host: cpc3-walt15-2-0-cust148.13-2.cable.virginmedia.com User-Agent: Pan/0.135 (Tomorrow I'll Wake Up and Scald Myself with Tea; GIT 30dc37b master) X-Pg-Spam-Score: -1.9 (-) X-Archive-Number: 201202/55 X-Sequence-Number: 39115 On Mon, 13 Feb 2012 10:57:39 -0800, Dinesh Bhandary wrote: > Hello, > > 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. Is it possible to call a script that does > pg_dump and move a dump file to the backup destination using AMANDA. > > Any help or workable solution is greatly appreciated. I've never heard of AMANDA, but I don't understand the problem. The output of pg_dump is just a file, albeit usually a large one.