[ADMIN] postgres backup ( logical using pg_dump) using AMANDA

2012-02-13 Thread Dinesh Bhandary
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

Re: [ADMIN] postgres backup ( logical using pg_dump) using AMANDA

2012-02-13 Thread Kevin Grittner
Dinesh Bhandary dbhand...@iii.com 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

Re: [ADMIN] postgres backup ( logical using pg_dump) using AMANDA

2012-02-13 Thread Dinesh Bhandary
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,

Re: [ADMIN] postgres backup ( logical using pg_dump) using AMANDA

2012-02-13 Thread Walter Hurry
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