pg.ddx.io pgsql-admin@postgresql.org mailing list archive
help / color / mirror / Atom feedpostgres backup ( logical using pg_dump) using AMANDA
4+ messages / 3 participants
[nested] [flat]
* postgres backup ( logical using pg_dump) using AMANDA
@ 2012-02-13 18:57 Dinesh Bhandary <dbhandary@iii.com>
0 siblings, 2 replies; 4+ messages in thread
From: Dinesh Bhandary @ 2012-02-13 18:57 UTC (permalink / raw)
To: pgsql-admin
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
^ permalink raw reply [nested|flat] 4+ messages in thread
* Re: postgres backup ( logical using pg_dump) using AMANDA
@ 2012-02-13 19:12 Kevin Grittner <Kevin.Grittner@wicourts.gov>
parent: Dinesh Bhandary <dbhandary@iii.com>
1 sibling, 1 reply; 4+ messages in thread
From: Kevin Grittner @ 2012-02-13 19:12 UTC (permalink / raw)
To: dbhandary@iii.com; pgsql-admin
Dinesh Bhandary <dbhandary@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 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
^ permalink raw reply [nested|flat] 4+ messages in thread
* Re: postgres backup ( logical using pg_dump) using AMANDA
@ 2012-02-13 19:24 Dinesh Bhandary <dbhandary@iii.com>
parent: Kevin Grittner <Kevin.Grittner@wicourts.gov>
0 siblings, 0 replies; 4+ messages in thread
From: Dinesh Bhandary @ 2012-02-13 19:24 UTC (permalink / raw)
To: Kevin Grittner <Kevin.Grittner@wicourts.gov>; +Cc: pgsql-admin
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<dbhandary@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 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
>
>
>
^ permalink raw reply [nested|flat] 4+ messages in thread
* Re: postgres backup ( logical using pg_dump) using AMANDA
@ 2012-02-13 21:04 Walter Hurry <walterhurry@lavabit.com>
parent: Dinesh Bhandary <dbhandary@iii.com>
1 sibling, 0 replies; 4+ messages in thread
From: Walter Hurry @ 2012-02-13 21:04 UTC (permalink / raw)
To: pgsql-admin
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.
^ permalink raw reply [nested|flat] 4+ messages in thread
end of thread, other threads:[~2012-02-13 21:04 UTC | newest]
Thread overview: 4+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2012-02-13 18:57 postgres backup ( logical using pg_dump) using AMANDA Dinesh Bhandary <dbhandary@iii.com>
2012-02-13 19:12 ` Kevin Grittner <Kevin.Grittner@wicourts.gov>
2012-02-13 19:24 ` Dinesh Bhandary <dbhandary@iii.com>
2012-02-13 21:04 ` Walter Hurry <walterhurry@lavabit.com>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox