Re: Incremental Backup

On Tue, 19 Aug 2003 theguardian(at)vsnl(dot)net wrote:

> Resp. Sir /Madam,
> We are hosting a website who is having PostgreSQL RDBMS as back-end. In that we have to upload data onto the server from the standalone application on a daily basis. At present, on Standalone application side we are taking the backup of the whole database, While on the server side we are deleting, droping, creation of new tables and inserting the data into it. This is fine untill the data size is small, but it is increasing in abundant.
> So is there any way of doing some kind of incremental backup in which only the daily work which is done is backed up from the standalone machine and is appended into the data which is already existing over there on the server.
> The reply to this mail should be considered as an emergency case and i hope you cooperation for it.

There are a few ways to do this.

One is to have a seperate server that only has today's data, it gets
backed up, the data gets pushed to live (if need be) and it gets wiped
clean. Or use schemas and have one for each day that you can then backup
each day.