On Tue, 19 Aug 2003 theguardian@vsnl.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
serverfrom the standalone application on a daily basis. At present, on Standalone application side we are taking the
backupof the whole database, While on the server side we are deleting, droping, creation of new tables and inserting
thedata 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
fromthe 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.