Postgres Pro
Downloads
Home   >   mailing lists

Thread: Help for incremental backup

Help for incremental backup

From
Neeraj
Date:
Sir

 I m using POSTGRESQL as backend.I need to take the INCREMENTAL backup
of the database.But I am unable to find any way to fulfill my
requirement.So its a request to you to help me in this case.
I will be thankful for this..

Waiting for reply..


Regards
  Neeraj

Re: Help for incremental backup

From
"Henshall, Stuart - WCP"
Date:
Currently there is no method for incremental backups :(
There has been some mention of using cutdown WAL files
for this, but nothing has come of this yet so pg_dump
remains the method of backing up.
As a thought it might be possible to setup rserv to feed
everything to another server as a backup method.
Sorry I couldn't be of more help,
- Stuart


> From: Neeraj [mailto:neeraj@intelesoftech.com]
>
>
> Sir
>
>  I m using POSTGRESQL as backend.I need to take the INCREMENTAL backup
> of the database.But I am unable to find any way to fulfill my
> requirement.So its a request to you to help me in this case.
> I will be thankful for this..
>
> Waiting for reply..
>
>
> Regards
>   Neeraj

Re: Help for incremental backup

From
"Josh Berkus"
Date:
Neeraj,

>  I m using POSTGRESQL as backend.I need to take the INCREMENTAL
> backup
> of the database.But I am unable to find any way to fulfill my
> requirement.So its a request to you to help me in this case.
> I will be thankful for this..

PostgreSQL does not support incremental backups.  As even a 200mb
database in Postgres can be backed up in < 15 minutes, without shutting
down the database, there has not been any reason to implement
incremental backups.

Please describe what you are trying to accomplish, and maybe we can
reccommend a backup strategy which will fulfill your needs.

-Josh Berkus

______AGLIO DATABASE SOLUTIONS___________________________
                                       Josh Berkus
  Complete information technology      josh@agliodbs.com
   and data management solutions       (415) 565-7293
  for law firms, small businesses        fax 621-2533
    and non-profit organizations.      San Francisco

Re: Help for incremental backup

From
"Joshua b. Jore"
Date:
> > From: Neeraj [mailto:neeraj@intelesoftech.com]
> >
> >  I m using POSTGRESQL as backend.I need to take the INCREMENTAL backup
> > of the database.But I am unable to find any way to fulfill my
> > requirement.So its a request to you to help me in this case.
> > I will be thankful for this..

Ok, so here's an idea. You could track row creation/modification timestamps
and just copy off the data that has changed in a given period. I don't do
this specific task but you could adapt this idea for your use.

Check out http://www.greentechnologist.org/political/Voter/dev. The tables
exist in 2_tables.sql. Look for the Audit table and then note how the other
tables inherit from it. It uses a sequence to keep the most recent changes
up front for the auditsomething view. There are some important triggers in
5_trig.sql. Specifically AuditIns() and AuditUpd(). You'll note that all
the child tables use the same trigger which just says that CreatedDate is
only set at creation time and ModifiedDate is always updated.


---
Joshua b. Jore
http://www.greentechnologist.org