Re: Postgres Incremental Bakcup

Hi Anantha,

I recommend you read this:
http://www.postgresql.org/docs/9.0/static/continuous-archiving.html
You 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(dot)echambadi(at)wipro(dot)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
>
>