Re: Incremental Backup of a particular database

There is no incremental backup process that focuses on an individual
database for PostgreSQL. Anything that has to do with PITR on a
PostgreSQL installation is system-wide, and cannot be configured to
support a single database out of many in an installation. If you need to
support PITR with a single database, you will need to initdb another
directory and set up another PostgreSQL postmaster to manage that
installation separate from your primary installation (and on a different
port, etc), or set up PostgreSQL for that specific database on another
server.

Also, there really are no incremental backup tools for PostgreSQL,
assuming you are looking at an incremental backup in the way that the
Progress database system takes an incremental backup (copy of all of the
blocks changed since the last full or incremental backup). PostgreSQL
has PITR, which is a roll-forward system using log data from a full
point-in-time backup, as well as pg_dump. One could say that the log
files are the incremental backups. However, many commercial database
systems (that many are migrating to PostgreSQL from) provide both an
"incremental" backup option (very fast recovery) as well as a "log based
recovery" option (slow recovery), and of the two, PostgreSQL supports
only the log based recovery through PITR.

Please correct me where possible guys, I enjoy the stability and
useability of my PostgreSQL very much, but I have to admit that I lose a
bit more sleep over it than some other db's with regards to recovery
time in a DR scenario. I am very eager to see where we go in the future.

Jason Minion
jason(dot)minion(at)sigler(dot)com

________________________________

From: pgsql-admin-owner(at)postgresql(dot)org
[mailto:pgsql-admin-owner(at)postgresql(dot)org] On Behalf Of Yogvinder Singh
Sent: Thursday, January 18, 2007 5:23 AM
To: Shoaib Mir
Cc: pgsql-admin(at)postgresql(dot)org
Subject: Re: [ADMIN] Incremental Backup of a particular database

So it means there is no way i can take incremental backup of one of the
databases from a postgresql database server??

Regards,
Yogvinder Singh,
Software Engineer, E-WorkStyle Group,
Newgen Software Technologies Ltd.
D-152, Okhla Phase - 1
New Delhi
Tel no 26815467 Ext 143

----- Original Message -----
From: Shoaib Mir <mailto:shoaibmir(at)gmail(dot)com>
To: Yogvinder Singh <mailto:yogvinder(at)newgen(dot)co(dot)in>
Cc: pgsql-admin(at)postgresql(dot)org
Sent: Thursday, January 18, 2007 4:07 PM
Subject: Re: [ADMIN] Incremental Backup of a particular database

When the pg_dump process starts it takes one point and then
makes a backup for that specific time even if more updates on the
database are happening during the pg_dump process. So when you restore
on the other machine it will restore to that specific time when the
pg_dump process started.

----------------
Shoaib Mir
EnterpriseDB (www.enterprisedb.com)


On 1/18/07, Yogvinder Singh < yogvinder(at)newgen(dot)co(dot)in> wrote:

pg_dump is a utility for saving a PostgreSQL database
into a script or an
archive file. The script files are in plain-text format
and contain the SQL
commands required to reconstruct the database to the
state it was in
at the time it was saved.

"At the time it was saved" What is the meaning of this
statement?


Regards,
Yogvinder Singh,
Software Engineer, E-WorkStyle Group,
Newgen Software Technologies Ltd.
D-152, Okhla Phase - 1
New Delhi
Tel no 26815467 Ext 143


----- Original Message -----
From: "Yogvinder Singh" <yogvinder(at)newgen(dot)co(dot)in>
To: "Andy Shellam (Mailing Lists)"
<andy(dot)shellam-lists(at)mailnetwork(dot)co(dot)uk >
Cc: <pgsql-admin(at)postgresql(dot)org>
Sent: Thursday, January 18, 2007 10:44 AM
Subject: Re: [ADMIN] Incremental Backup of a particular
database


> I only want one of many databases to be restored to
the other server
> incrementally.
> Is this possible?
> If yes, Wht are the steps??
>
> Regards,
> Yogvinder Singh,
> Software Engineer, E-WorkStyle Group,
> Newgen Software Technologies Ltd.
> D-152, Okhla Phase - 1
> Tel no 26815467 Ext 143
>
>
> ----- Original Message -----
> From: "Andy Shellam (Mailing Lists)"
< andy(dot)shellam-lists(at)mailnetwork(dot)co(dot)uk>
> To: "Yogvinder Singh" <yogvinder(at)newgen(dot)co(dot)in>
> Cc: < pgsql-admin(at)postgresql(dot)org>
> Sent: Wednesday, January 17, 2007 8:17 PM
> Subject: Re: [ADMIN] Incremental Backup of a
particular database
>
>
> > I believe the option for a "warm standby" (which
sounds like it is what
> > you need) was made available in 8.2.0.
> > You'd have to look at the manual though, I haven't
had time to
> > investigate, and I'm not sure whether it's
cluster-wide, or
> > database-specific.
> >
> >
> > Yogvinder Singh wrote:
> > > Hi Ppl,
> > >
> > > I have Two PostgreSQL Database Servers. The
situation is like this:-
> > > 1) On first database server ball the operations
(i.e live server) will
> > > be done. This server may contain n number of
databases.
> > >
> > > 2) On the second database server, i want to keep
one particular
> > > database (from the first database server ) and
keep it updated to the
> > > latest from the First Database Server. I just want
to be able to take
> > > some sort of incremental backup from the first
server and restore it
> > > to the second server.
> > >
> > > Is this situation feasible. How can i take an
incremental backup of a
> > > particular database out of many databases? On
which version this is
> > > supported? IF not supported, is there any
alternative way to handle
> > > this situatio.
> > >
> > > Regards,
> > > Yogvinder Singh,
> > > !DSPAM:37,45ae2b2f137105304223843! Disclaimer :-
This e-mail message
> > > including any attachment may contain confidential,
proprietary or
> > > legally privileged information. It should not be
used by who is not
> > > the original intended recipient. If you have
erroneously received this
> > > message, you are notified that you are strictly
prohibited from using,
> > > copying, altering or disclosing the content of
this message. Please
> > > delete it immediately and notify the sender.
Newgen Software
> > > Technologies Ltd and / or its subsidiary Companies
accept no
> > > responsibility for loss or damage arising from the
use of the
> > > information transmitted by this email including
damage from virus and
> > > further acknowledges that any views expressed in
this message are
> > > those of the individual sender and no binding
nature of the message
> > > shall be implied or assumed unless the sender does
so expressly with
> > > due authority of Newgen Software Technologies Ltd
and / or its
> > > subsidiary Companies, as applicable.
> >
> > ---------------------------(end of
broadcast)---------------------------
> > TIP 3: Have you checked our extensive FAQ?
> >
> > http://www.postgresql.org/docs/faq
> >
>
>
>
> Disclaimer :- This e-mail message including any
attachment may contain
confidential, proprietary or legally privileged
information. It should not
be used by who is not the original intended recipient.
If you have
erroneously received this message, you are notified that
you are strictly
prohibited from using, copying, altering or disclosing
the content of this
message. Please delete it immediately and notify the
sender. Newgen Software
Technologies Ltd and / or its subsidiary Companies
accept no responsibility
for loss or damage arising from the use of the
information transmitted by
this email including damage from virus and further
acknowledges that any
views expressed in this message are those of the
individual sender and no
binding nature of the message shall be implied or
assumed unless the sender
does so expressly with due authority of Newgen Software
Technologies Ltd and
/ or its subsidiary Companies, as applicable.
>
>
> ---------------------------(end of
broadcast)---------------------------
> TIP 6: explain analyze is your friend
>



Disclaimer :- This e-mail message including any
attachment may contain confidential, proprietary or legally privileged
information. It should not be used by who is not the original intended
recipient. If you have erroneously received this message, you are
notified that you are strictly prohibited from using, copying, altering
or disclosing the content of this message. Please delete it immediately
and notify the sender. Newgen Software Technologies Ltd and / or its
subsidiary Companies accept no responsibility for loss or damage arising
from the use of the information transmitted by this email including
damage from virus and further acknowledges that any views expressed in
this message are those of the individual sender and no binding nature of
the message shall be implied or assumed unless the sender does so
expressly with due authority of Newgen Software Technologies Ltd and /
or its subsidiary Companies, as applicable.


---------------------------(end of
broadcast)---------------------------
TIP 6: explain analyze is your friend

Disclaimer :- This e-mail message including any attachment may contain
confidential, proprietary or legally privileged information. It should
not be used by who is not the original intended recipient. If you have
erroneously received this message, you are notified that you are
strictly prohibited from using, copying, altering or disclosing the
content of this message. Please delete it immediately and notify the
sender. Newgen Software Technologies Ltd and / or its subsidiary
Companies accept no responsibility for loss or damage arising from the
use of the information transmitted by this email including damage from
virus and further acknowledges that any views expressed in this message
are those of the individual sender and no binding nature of the message
shall be implied or assumed unless the sender does so expressly with due
authority of Newgen Software Technologies Ltd and / or its subsidiary
Companies, as applicable.