Received: from localhost (maia-1.hub.org [200.46.204.191]) by postgresql.org (Postfix) with ESMTP id 06A079F9FDA for ; Wed, 17 Jan 2007 11:23:40 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.191]) (amavisd-new, port 10024) with ESMTP id 41492-08 for ; Wed, 17 Jan 2007 11:23:08 -0400 (AST) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.4 Received: from an-out-0708.google.com (an-out-0708.google.com [209.85.132.242]) by postgresql.org (Postfix) with ESMTP id 963999FA49D for ; Wed, 17 Jan 2007 11:23:08 -0400 (AST) Received: by an-out-0708.google.com with SMTP id c24so1235935ana for ; Wed, 17 Jan 2007 07:23:07 -0800 (PST) DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=beta; h=received:message-id:date:from:to:subject:cc:in-reply-to:mime-version:content-type:references; b=llzxHJ/EXdAna7SCF3QKmyk5vEchlr5CaIfH6wm4eaObwmy/pjG7YqUCFwSxWrAl0gSMAzAnyshwADvvrBIFHISLqFAgAyPBprzx7Ez4NOucbGAE55WFdaR70o1WZJCcp6yVTyZvUM2oU6SPYicLYYjlWUwUZBuValWHm0wBGTc= Received: by 10.65.234.2 with SMTP id l2mr3596604qbr.1169047386928; Wed, 17 Jan 2007 07:23:06 -0800 (PST) Received: by 10.65.188.5 with HTTP; Wed, 17 Jan 2007 07:23:06 -0800 (PST) Message-ID: Date: Wed, 17 Jan 2007 20:23:06 +0500 From: "Shoaib Mir" To: "Andy Shellam (Mailing Lists)" Subject: Re: Incremental Backup of a particular database Cc: "Yogvinder Singh" , pgsql-admin@postgresql.org In-Reply-To: <45AE3D9A.7010908@mailnetwork.co.uk> MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_Part_71445_9549850.1169047386890" References: <001201c73a3e$33bbaf70$0404a8c0@central.newgen.local> <45AE370B.2070805@mailnetwork.co.uk> <45AE3D9A.7010908@mailnetwork.co.uk> X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200701/135 X-Sequence-Number: 24291 ------=_Part_71445_9549850.1169047386890 Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit Content-Disposition: inline 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 ) > > > > On 1/17/07, *Andy Shellam (Mailing Lists)* > > > > 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! > ------=_Part_71445_9549850.1169047386890 Content-Type: text/html; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit Content-Disposition: inline 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!

------=_Part_71445_9549850.1169047386890--