Skip site navigation (1) Skip section navigation (2)

Re: Incremental Backup of a particular database

From: "Yogvinder Singh" <yogvinder(at)newgen(dot)co(dot)in>
To: "Eduardo J(dot) Ortega" <ejortegau(at)cable(dot)net(dot)co>,<pgsql-admin(at)postgresql(dot)org>
Subject: Re: Incremental Backup of a particular database
Date: 2007-01-18 05:30:46
Message-ID: 001901c73ac1$cf841ef0$0404a8c0@central.newgen.local (view raw or flat)
Thread:
Lists: pgsql-admin
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(at)cable(dot)net(dot)co>
To: <pgsql-admin(at)postgresql(dot)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(dot)shellam-lists(at)mailnetwork(dot)co(dot)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(dot)shellam-lists(at)mailnetwork(dot)co(dot)uk
> > > > <mailto:andy(dot)shellam-lists(at)mailnetwork(dot)co(dot)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 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.


In response to

pgsql-admin by date

Next:From: Yogvinder SinghDate: 2007-01-18 05:59:32
Subject: Re: Incremental Backup of a particular database
Previous:From: Yogvinder SinghDate: 2007-01-18 05:14:25
Subject: Re: Incremental Backup of a particular database

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group