Thread: Incremental Backup of a particular database

Incremental Backup of a particular database

From
"Yogvinder Singh"
Date:
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,
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.

Re: Incremental Backup of a particular database

From
"Andy Shellam (Mailing Lists)"
Date:
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.

Re: Incremental Backup of a particular database

From
"Shoaib Mir"
Date:
Even with ver 8.1 you can use WAL archive backups (PITR) to implement an incremental backup strategy.

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

On 1/17/07, Andy Shellam (Mailing Lists) <andy.shellam-lists@mailnetwork.co.uk> wrote:
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

Re: Incremental Backup of a particular database

From
"Andy Shellam (Mailing Lists)"
Date:
Shoaib Mir wrote:
> Even with ver 8.1 you can use WAL archive backups (PITR) to implement
> an incremental backup strategy.
Yes, true, but it's harder with 8.1 as you always have to start from a
base backup and roll WAL logs forward - without a custom script you
cannot "wait" for new WAL logs to arrive and apply them on top of a base
backup.
There is a project in PgFoundry to allow for warm-standby in the 8.0 and
8.1 series, however this is reportedly built-in to 8.2 now.
>
> -------------
> Shoaib Mir
> EnterpriseDB (www.enterprisedb.com <http://www.enterprisedb.com>)
>
> On 1/17/07, *Andy Shellam (Mailing Lists)*
> <andy.shellam-lists@mailnetwork.co.uk
> <mailto:andy.shellam-lists@mailnetwork.co.uk>> wrote:
>
>     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,
>     > 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
>
>
> !DSPAM:37,45ae3b61137103926781350!

Re: Incremental Backup of a particular database

From
"Shoaib Mir"
Date:
Yes, I guess that is true with 8.2 but with a few configurations for WAL copying scripts.

Saw the following in documentation that specifies a good flow for doing it --> http://www.postgresql.org/docs/8.2/static/warm-standby.html

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

On 1/17/07, Andy Shellam (Mailing Lists) <andy.shellam-lists@mailnetwork.co.uk> wrote:
Shoaib Mir wrote:
> Even with ver 8.1 you can use WAL archive backups (PITR) to implement
> an incremental backup strategy.
Yes, true, but it's harder with 8.1 as you always have to start from a
base backup and roll WAL logs forward - without a custom script you
cannot "wait" for new WAL logs to arrive and apply them on top of a base
backup.
There is a project in PgFoundry to allow for warm-standby in the 8.0 and
8.1 series, however this is reportedly built-in to 8.2 now.
>
> -------------
> Shoaib Mir
> EnterpriseDB (www.enterprisedb.com <http://www.enterprisedb.com>)
>
> On 1/17/07, *Andy Shellam (Mailing Lists)*
> <andy.shellam-lists@mailnetwork.co.uk
> <mailto: andy.shellam-lists@mailnetwork.co.uk>> wrote:
>
>     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,
>     > 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
>
>
> !DSPAM:37,45ae3b61137103926781350!

Re: Incremental Backup of a particular database

From
"Yogvinder Singh"
Date:
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.shellam-lists@mailnetwork.co.uk>
To: "Yogvinder Singh" <yogvinder@newgen.co.in>
Cc: <pgsql-admin@postgresql.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
thismessage. Please delete it immediately and notify the sender. Newgen Software Technologies Ltd and / or its
subsidiaryCompanies accept no responsibility for loss or damage arising from the use of the information transmitted by
thisemail including damage from virus and further acknowledges that any views expressed in this message are those of
theindividual sender and no binding nature of the message shall be implied or assumed unless the sender does so
expresslywith due authority of Newgen Software Technologies Ltd and / or its subsidiary Companies, as applicable. 


Re: Incremental Backup of a particular database

From
"Eduardo J. Ortega"
Date:
Not sure, but i think WAL based incremental backup is for the whole database
cluster, and not for an specific database, so don't think this is going to
work for you. Is yoor database too large? If not, you could stick to the old
fashioned pg_dump output.

On Wednesday 17 January 2007 10:23, Shoaib Mir wrote:
> Yes, I guess that is true with 8.2 but with a few configurations for WAL
> copying scripts.
>
> Saw the following in documentation that specifies a good flow for doing it
> --> http://www.postgresql.org/docs/8.2/static/warm-standby.html
>
> ---------------
> Shoaib Mir
> EnterpriseDB (www.enterprisedb.com)
>
> On 1/17/07, Andy Shellam (Mailing Lists) <
>
> andy.shellam-lists@mailnetwork.co.uk> wrote:
> > Shoaib Mir wrote:
> > > Even with ver 8.1 you can use WAL archive backups (PITR) to implement
> > > an incremental backup strategy.
> >
> > Yes, true, but it's harder with 8.1 as you always have to start from a
> > base backup and roll WAL logs forward - without a custom script you
> > cannot "wait" for new WAL logs to arrive and apply them on top of a base
> > backup.
> > There is a project in PgFoundry to allow for warm-standby in the 8.0 and
> > 8.1 series, however this is reportedly built-in to 8.2 now.
> >
> > > -------------
> > > Shoaib Mir
> > > EnterpriseDB (www.enterprisedb.com <http://www.enterprisedb.com>)
> > >
> > > On 1/17/07, *Andy Shellam (Mailing Lists)*
> > > <andy.shellam-lists@mailnetwork.co.uk
> > > <mailto:andy.shellam-lists@mailnetwork.co.uk>> wrote:
> > >
> > >     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,
> > >     > 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
> > >
> > >
> > > !DSPAM:37,45ae3b61137103926781350!

--
Eduardo J. Ortega - Linux user #222873
"No fake - I'm a big fan of konqueror, and I use it for everything." -- Linus
Torvalds

Re: Incremental Backup of a particular database

From
"Yogvinder Singh"
Date:
Yes Database size is going to grow very large over time. The situation is
going to be like this that ther is one central server where n nr of
databases are there.
I want one of these databases to be restored to the Other database Server.
What i have found so far implies tht the whole of database server will be
restored not one particular database.

Any light on this ??


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: "Eduardo J. Ortega" <ejortegau@cable.net.co>
To: <pgsql-admin@postgresql.org>
Sent: Thursday, January 18, 2007 9:39 AM
Subject: Re: [ADMIN] Incremental Backup of a particular database


> Not sure, but i think WAL based incremental backup is for the whole
database
> cluster, and not for an specific database, so don't think this is going to
> work for you. Is yoor database too large? If not, you could stick to the
old
> fashioned pg_dump output.
>
> On Wednesday 17 January 2007 10:23, Shoaib Mir wrote:
> > Yes, I guess that is true with 8.2 but with a few configurations for WAL
> > copying scripts.
> >
> > Saw the following in documentation that specifies a good flow for doing
it
> > --> http://www.postgresql.org/docs/8.2/static/warm-standby.html
> >
> > ---------------
> > Shoaib Mir
> > EnterpriseDB (www.enterprisedb.com)
> >
> > On 1/17/07, Andy Shellam (Mailing Lists) <
> >
> > andy.shellam-lists@mailnetwork.co.uk> wrote:
> > > Shoaib Mir wrote:
> > > > Even with ver 8.1 you can use WAL archive backups (PITR) to
implement
> > > > an incremental backup strategy.
> > >
> > > Yes, true, but it's harder with 8.1 as you always have to start from a
> > > base backup and roll WAL logs forward - without a custom script you
> > > cannot "wait" for new WAL logs to arrive and apply them on top of a
base
> > > backup.
> > > There is a project in PgFoundry to allow for warm-standby in the 8.0
and
> > > 8.1 series, however this is reportedly built-in to 8.2 now.
> > >
> > > > -------------
> > > > Shoaib Mir
> > > > EnterpriseDB (www.enterprisedb.com <http://www.enterprisedb.com>)
> > > >
> > > > On 1/17/07, *Andy Shellam (Mailing Lists)*
> > > > <andy.shellam-lists@mailnetwork.co.uk
> > > > <mailto:andy.shellam-lists@mailnetwork.co.uk>> wrote:
> > > >
> > > >     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,
> > > >     > 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
> > > >
> > > >
> > > > !DSPAM:37,45ae3b61137103926781350!
>
> --
> Eduardo J. Ortega - Linux user #222873
> "No fake - I'm a big fan of konqueror, and I use it for everything." --
Linus
> Torvalds
>
> ---------------------------(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
thismessage. Please delete it immediately and notify the sender. Newgen Software Technologies Ltd and / or its
subsidiaryCompanies accept no responsibility for loss or damage arising from the use of the information transmitted by
thisemail including damage from virus and further acknowledges that any views expressed in this message are those of
theindividual sender and no binding nature of the message shall be implied or assumed unless the sender does so
expresslywith due authority of Newgen Software Technologies Ltd and / or its subsidiary Companies, as applicable. 


Re: Incremental Backup of a particular database

From
"Yogvinder Singh"
Date:
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@newgen.co.in>
To: "Andy Shellam (Mailing Lists)" <andy.shellam-lists@mailnetwork.co.uk>
Cc: <pgsql-admin@postgresql.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.shellam-lists@mailnetwork.co.uk>
> To: "Yogvinder Singh" <yogvinder@newgen.co.in>
> Cc: <pgsql-admin@postgresql.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
thismessage. Please delete it immediately and notify the sender. Newgen Software Technologies Ltd and / or its
subsidiaryCompanies accept no responsibility for loss or damage arising from the use of the information transmitted by
thisemail including damage from virus and further acknowledges that any views expressed in this message are those of
theindividual sender and no binding nature of the message shall be implied or assumed unless the sender does so
expresslywith due authority of Newgen Software Technologies Ltd and / or its subsidiary Companies, as applicable. 


Re: Incremental Backup of a particular database

From
"Shoaib Mir"
Date:
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@newgen.co.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@newgen.co.in>
To: "Andy Shellam (Mailing Lists)" <andy.shellam-lists@mailnetwork.co.uk >
Cc: <pgsql-admin@postgresql.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.shellam-lists@mailnetwork.co.uk>
> To: "Yogvinder Singh" <yogvinder@newgen.co.in>
> Cc: < pgsql-admin@postgresql.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

Re: Incremental Backup of a particular database

From
"Yogvinder Singh"
Date:
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 -----
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@newgen.co.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@newgen.co.in>
To: "Andy Shellam (Mailing Lists)" <andy.shellam-lists@mailnetwork.co.uk >
Cc: <pgsql-admin@postgresql.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.shellam-lists@mailnetwork.co.uk>
> To: "Yogvinder Singh" <yogvinder@newgen.co.in>
> Cc: < pgsql-admin@postgresql.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.

Re: Incremental Backup of a particular database

From
Scott Marlowe
Date:
On Thu, 2007-01-18 at 05:23, Yogvinder Singh wrote:
> So it means there is no way i can take incremental backup of  one of
> the databases from a postgresql database server??

Correct.  You could replicate its tables to another server with slony
and then use that to make incrementals with PITR.

Maybe a better definition of what you're trying to do from a higher
level would help.

Re: Incremental Backup of a particular database

From
"Jason Minion"
Date:
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.minion@sigler.com

 


From: pgsql-admin-owner@postgresql.org [mailto:pgsql-admin-owner@postgresql.org] On Behalf Of Yogvinder Singh
Sent: Thursday, January 18, 2007 5:23 AM
To: Shoaib Mir
Cc: pgsql-admin@postgresql.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 -----
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@newgen.co.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@newgen.co.in>
To: "Andy Shellam (Mailing Lists)" <andy.shellam-lists@mailnetwork.co.uk >
Cc: <pgsql-admin@postgresql.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.shellam-lists@mailnetwork.co.uk>
> To: "Yogvinder Singh" <yogvinder@newgen.co.in>
> Cc: < pgsql-admin@postgresql.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.

Re: Incremental Backup of a particular database

From
"Samuel B. Quiring"
Date:
You can use pg_dump while the application(s) that use the database are
active.  pg_dump saves that database at a point in time.  If the
application(s)
continue to modify the database after you use pg_dump, the script/archive
file created by pg_dump will not contain those modifications.

----- Original Message -----
From: "Yogvinder Singh" <yogvinder@newgen.co.in>
To: <pgsql-admin@postgresql.org>
Sent: Wednesday, January 17, 2007 9:59 PM
Subject: Re: [ADMIN] Incremental Backup of a particular database


> 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@newgen.co.in>
> To: "Andy Shellam (Mailing Lists)" <andy.shellam-lists@mailnetwork.co.uk>
> Cc: <pgsql-admin@postgresql.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.shellam-lists@mailnetwork.co.uk>
>> To: "Yogvinder Singh" <yogvinder@newgen.co.in>
>> Cc: <pgsql-admin@postgresql.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
>


Re: Incremental Backup of a particular database

From
Naomi Walker
Date:
I've been thinking about PITR.  Since we have one production instance
and one test instance of Postgres, in order to perform a PITR
on any particular database would require reloading the entire instance
onto another server, and extracting what I needed.  Clunky, but
do-able.

From my Informix years, I remember a tool that would read your backups,
and extract out whatever you wanted, down to a table level
SQL.  Wouldn't that be ideal....

Jason Minion wrote:
> 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.minion@sigler.com
>
>
>
> ------------------------------------------------------------------------
> *From:* pgsql-admin-owner@postgresql.org
> [mailto:pgsql-admin-owner@postgresql.org] *On Behalf Of *Yogvinder Singh
> *Sent:* Thursday, January 18, 2007 5:23 AM
> *To:* Shoaib Mir
> *Cc:* pgsql-admin@postgresql.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@gmail.com>
>     *To:* Yogvinder Singh <mailto:yogvinder@newgen.co.in>
>     *Cc:* pgsql-admin@postgresql.org <mailto:pgsql-admin@postgresql.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 <http://www.enterprisedb.com>)
>
>     On 1/18/07, *Yogvinder Singh* < yogvinder@newgen.co.in
>     <mailto:yogvinder@newgen.co.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@newgen.co.in
>         <mailto:yogvinder@newgen.co.in>>
>         To: "Andy Shellam (Mailing Lists)"
>         <andy.shellam-lists@mailnetwork.co.uk
>         <mailto:andy.shellam-lists@mailnetwork.co.uk>>
>         Cc: <pgsql-admin@postgresql.org
>         <mailto:pgsql-admin@postgresql.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.shellam-lists@mailnetwork.co.uk
>         <mailto:andy.shellam-lists@mailnetwork.co.uk>>
>         > To: "Yogvinder Singh" <yogvinder@newgen.co.in
>         <mailto:yogvinder@newgen.co.in>>
>         > Cc: < pgsql-admin@postgresql.org
>         <mailto:pgsql-admin@postgresql.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
>         >
>
>


--
----------------------------------------------------------------------------
Naomi Walker                          Chief Information Officer
Mphasis Healthcare Solutions          nwalker@mhs.mphasis.com
  ---An EDS Company                   602-604-3100
----------------------------------------------------------------------------
A positive attitude may not solve all your problems, but it will annoy
enough people to make it worth the effort. --Herm Albright (1876 - 1944)
----------------------------------------------------------------------------

-- CONFIDENTIALITY NOTICE --

Information transmitted by this e-mail is proprietary to MphasiS and/or its Customers and is intended for use only by
theindividual or entity to which it is addressed, and may contain information that is privileged, confidential or
exemptfrom disclosure under applicable law. If you are not the intended recipient or it appears that this e-mail has
beenforwarded to you without proper authority, you are notified that any use or dissemination of this information in
anymanner is strictly prohibited. In such cases, please notify us immediately at mailmaster@mphasis.com and delete this
mailfrom your records.