Incremental Backup

From: theguardian(at)vsnl(dot)net
To: pgsql-admin(at)postgresql(dot)org
Subject: Incremental Backup
Date: 2003-08-20 00:19:19
Message-ID: 200308200019.h7K0JJ503902@webmail2.vsnl.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

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.

Thanks,
Regards,

The Guardian.

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Nick Fankhauser 2003-08-20 00:37:38 Re: changing field length
Previous Message Adi Alurkar 2003-08-19 22:05:28 pg_dump does not dump index, constraints, sequences