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

[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 to the backup
destination using AMANDA.

Any help or workable solution is greatly appreciated.

Thanks.

Dinesh

[Kevin Grittner]

Post by Dinesh Bhandary
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

[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

Post by Kevin Grittner

Post by Dinesh Bhandary
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

[Walter Hurry]

Post by 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 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.