Re: PostgreSQL suitable? - Mailing list pgsql-general

From Rakesh Kumar
Subject Re: PostgreSQL suitable?
Date
Msg-id trinity-acba7d1e-51f3-4465-a57c-8a65e523bece-1513699967925@3c-app-mailcom-lxa07
Whole thread Raw
In response to Re: PostgreSQL suitable?  (Stephen Frost <sfrost@snowman.net>)
Responses Re: PostgreSQL suitable?
Re: PostgreSQL suitable?
List pgsql-general
> 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
wherethe db backs up only the changed blocks after the last full backup.  In a DW system where most of the time it is
appendonly, 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.
 


pgsql-general by date:

Previous
From: Melvin Davidson
Date:
Subject: Re: Re: PostgreSQL needs percentage function
Next
From: Vincenzo Romano
Date:
Subject: Re: PostgreSQL suitable?