Hi Anantha,
I recommend you read this:
http://www.postgresql.org/docs/9.0/static/continuous-archiving.htmlYou can instantly stream(hot standby) or with a slight delay copy(warm standby) the WAL information/files to a different server. You can have a second PostgreSQL. If you just want to store the files on disk be sure to make full backups periodically to reduce WAL playback time.
The most simple script is to setup a rsync or scp cron job on the WAL folder after setting your postgres.conf to keep the WAL files. This will use more disk space.
On Thu, May 12, 2011 at 6:26 AM,
<anantha.echambadi@wipro.com> wrote:
Hi,
We are using Postgres 9.0.1 and in which we store the information of the clients, Say it to be user name and other details.
Now we are currently running full backup, As the client and user increases we need to have incremental backup,
How do we do that and if we do so how will be the restoration part.
If you have any script for the same , pl. share it
Regards,
Anantha Narayanan T.E
Mb: 09538881524
Please do not print this email unless it is absolutely necessary.
The information contained in this electronic message and any attachments to this message are intended for the exclusive use of the addressee(s) and may contain proprietary, confidential or privileged information. If you are not the intended recipient, you should not disseminate, distribute or copy this e-mail. Please notify the sender immediately and destroy all copies of this message and any attachments.
WARNING: Computer viruses can be transmitted via email. The recipient should check this email and any attachments for the presence of viruses. The company accepts no liability for any damage caused by any virus transmitted by this email.
www.wipro.com