Search Postgresql Archives

Re: PostgreSQL suitable?

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



Greetings Rakesh,

* Rakesh Kumar (rakeshkumar464@xxxxxxxx) wrote:
> 
> > There are multiple solutions to doing incremental backups with
> > PostgreSQL, so I'm not sure why you're saying that they don't exist,
> > because that's really not accurate.
> 
> PG's incremental backup is essentially WAL logs applied to a point in time.  I am talking about true incremental backup where the db backs up only the changed blocks after the last full backup.  In a DW system where most of the time it is append only, it makes a huge difference in backup time.
> 
> I believe there is one tool which looks at mtime/atime of each of the data file and takes the decision to back it up or lot.  Not sure how robust it is.

Yes, there are multiple such solutions including pgBackRest and barman,
both of which are robust, well supported projects that provide exactly
the incremental backup capability you're asking about.  I can't speak
for barman, but I know that there are many people using pgBackRest
to do incremental backups, some on very large PG databases.

I will point out that supporting incremental backups is tricky to do
correctly, which is why using an existing project that's had years to
work on getting it right is really the best approach.  I wouldn't
recommend trying to roll your own.

Thanks!

Stephen

Attachment: signature.asc
Description: Digital signature


[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]

  Powered by Linux