pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
incrementals with pg-dump
2+ messages / 2 participants
[nested] [flat]

* incrementals with pg-dump
@ 2007-08-02 05:11 David Bear <David.Bear@asu.edu>
  2007-08-04 00:11 ` Re: incrementals with pg-dump Decibel! <decibel@decibel.org>
  0 siblings, 1 reply; 2+ messages in thread

From: David Bear @ 2007-08-02 05:11 UTC (permalink / raw)
  To: pgsql-admin

I googled a bit for an incremental or differential way to backup
postgresq. I was hoping there would be switch on pg-dumpall that would
backup all tupples added since some date. Doesn't look like it exists. 

I did find a backup method using the WAL files on the file system at 

http://www.oreillynet.com/pub/a/databases/2006/07/13/lamp-data-protection.html?page=last

I also found this:

http://www.postgresql.org/docs/8.1/static/backup-online.html

I seem to remember around pg 7.x that file system level backups were
very bad.

Now, it seems the pg 8.x way is to allow the admin to take advantage
of file system tools look tar, cpio, dump, etc.

I was wondering if there any other recommendations beyond what is
mentioned in the docs above?

-- 
David Bear
phone: 	602-496-0424
fax: 	602-496-0955
College of Public Programs/ASU
University Center Rm 622
411 N Central
Phoenix, AZ 85007-0685
 "Beware the IP portfolio, everyone will be suspect of trespassing"



^ permalink  raw  reply  [nested|flat] 2+ messages in thread

* Re: incrementals with pg-dump
  2007-08-02 05:11 incrementals with pg-dump David Bear <David.Bear@asu.edu>
@ 2007-08-04 00:11 ` Decibel! <decibel@decibel.org>
  0 siblings, 0 replies; 2+ messages in thread

From: Decibel! @ 2007-08-04 00:11 UTC (permalink / raw)
  To: David Bear <David.Bear@asu.edu>; +Cc: pgsql-admin

On Wed, Aug 01, 2007 at 10:11:01PM -0700, David Bear wrote:
> I googled a bit for an incremental or differential way to backup
> postgresq. I was hoping there would be switch on pg-dumpall that would
> backup all tupples added since some date. Doesn't look like it exists. 
> 
> I did find a backup method using the WAL files on the file system at 
> 
> http://www.oreillynet.com/pub/a/databases/2006/07/13/lamp-data-protection.html?page=last
> 
> I also found this:
> 
> http://www.postgresql.org/docs/8.1/static/backup-online.html
> 
> I seem to remember around pg 7.x that file system level backups were
> very bad.
> 
> Now, it seems the pg 8.x way is to allow the admin to take advantage
> of file system tools look tar, cpio, dump, etc.
> 
> I was wondering if there any other recommendations beyond what is
> mentioned in the docs above?

No... if you want incremental backups, use PITR. Someone's done some
work on an incremental version of pg_dump, but I haven't heard anything
about it in about a year.
-- 
Decibel!, aka Jim Nasby                        decibel@decibel.org
EnterpriseDB      http://enterprisedb.com      512.569.9461 (cell)

^ permalink  raw  reply  [nested|flat] 2+ messages in thread


end of thread, other threads:[~2007-08-04 00:11 UTC | newest]

Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2007-08-02 05:11 incrementals with pg-dump David Bear <David.Bear@asu.edu>
2007-08-04 00:11 ` Decibel! <decibel@decibel.org>

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