Received: from localhost (maia-4.hub.org [200.46.204.183]) by postgresql.org (Postfix) with ESMTP id 3753B9FA667 for ; Thu, 18 Jan 2007 06:38:02 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.183]) (amavisd-new, port 10024) with ESMTP id 56741-09 for ; Thu, 18 Jan 2007 06:37:58 -0400 (AST) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.4 Received: from nz-out-0506.google.com (nz-out-0506.google.com [64.233.162.236]) by postgresql.org (Postfix) with ESMTP id 23C759FA39A for ; Thu, 18 Jan 2007 06:37:58 -0400 (AST) Received: by nz-out-0506.google.com with SMTP id i11so106411nzh for ; Thu, 18 Jan 2007 02:37:57 -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=dPJZjkXCoKAEl54ni2wWsNKZk7Epnt/oUZP+6Ku34CzgFo1H3PPxlLliw2hijy0HbNslCgGFPhbrzlxFQgHQZNNkoZPK55gMrTuenvn3I+HsR1hmoKHP9wz8LkGAT9w2vQ54eBPdsV/1MXukooIxjH9tzNprwLQBn/3OJGnZxTk= Received: by 10.65.177.6 with SMTP id e6mr606335qbp.1169116676893; Thu, 18 Jan 2007 02:37:56 -0800 (PST) Received: by 10.65.188.5 with HTTP; Thu, 18 Jan 2007 02:37:56 -0800 (PST) Message-ID: Date: Thu, 18 Jan 2007 15:37:56 +0500 From: "Shoaib Mir" To: "Yogvinder Singh" Subject: Re: Incremental Backup of a particular database Cc: pgsql-admin@postgresql.org In-Reply-To: <009901c73ac5$d45de4c0$0404a8c0@central.newgen.local> MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_Part_82701_7740560.1169116676650" References: <001201c73a3e$33bbaf70$0404a8c0@central.newgen.local> <45AE370B.2070805@mailnetwork.co.uk> <000a01c73abf$863c45d0$0404a8c0@central.newgen.local> <009901c73ac5$d45de4c0$0404a8c0@central.newgen.local> X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200701/151 X-Sequence-Number: 24307 ------=_Part_82701_7740560.1169116676650 Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit Content-Disposition: inline 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 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" > To: "Andy Shellam (Mailing Lists)" > Cc: > 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)" > > > To: "Yogvinder Singh" > > Cc: > > 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 > ------=_Part_82701_7740560.1169116676650 Content-Type: text/html; charset=ISO-8859-1 Content-Transfer-Encoding: quoted-printable Content-Disposition: inline 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 d= uring 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 &= lt; yogvinder@newgen.co.in> wr= ote:
pg_dum= p 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&nbs= p; the SQL
commands required to reconstruct the database to the sta= te  it       was  in
a= t  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
Ne= w Delhi
Tel no 26815467 Ext 143


----- Original Message -----
From: "Yogvinder Singh" <yogvinder@newgen.co.in>
To: "Andy Shellam (Mailing = Lists)" <an= dy.shellam-lists@mailnetwork.co.uk >
Cc: <pgsql-adm= in@postgresql.org>
Sent: Thursday, January 18, 2007 10:44 AM
S= ubject: 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 Messa= ge -----
> 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-wi= de, or
> > database-specific.
> >
> >
> &g= t; Yogvinder Singh wrote:
> > > Hi Ppl,
> > >
> > > I have Two PostgreSQL Database Servers. The situation is lik= e 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 wa= nt to keep one particular
> > > database (from the first databa= se 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 an= d restore it
> > > to the second server.
> > >
&= gt; > > Is this situation feasible. How can i take an incremental bac= kup of a
> > > particular database out of many databases? On which vers= ion this is
> > > supported? IF not supported, is there any alt= ernative way to handle
> > > this situatio.
> > >
> > > Regards,
> > > Yogvinder Singh,
> >= > !DSPAM:37,45ae2b2f137105304223843! Disclaimer :- This e-mail message<= br>> > > including any attachment may contain confidential, propri= etary 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 mess= age. 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 o= f the
> > > information transmitted by this email including dam= age from virus and
> > > further acknowledges that any views ex= pressed 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?
> >
> >          &n= bsp;     
http://www.postgresql.org/docs/faq
> >
>
>>
> Disclaimer :- This e-mail message including any attachment m= ay contain
confidential, proprietary or legally privileged information. It should = not
be used by who is not the original intended recipient. If you haveerroneously received this message, you are notified that you are strictly
prohibited from using, copying, altering or disclosing the content of t= his
message. Please delete it immediately and notify the sender. Newgen = Software
Technologies Ltd and / or its subsidiary Companies accept no re= sponsibility
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 a= nd no
binding nature of the message shall be implied or assumed unless the se= nder
does so expressly with due authority of Newgen Software Technologie= s 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 con= fidential, 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 f= rom using, copying, altering or disclosing the content of this message. Ple= ase delete it immediately and notify the sender. Newgen Software Technologi= es 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 expres= sed in this message are those of the individual sender and no binding natur= e of the message shall be implied or assumed unless the sender does so expr= essly with due authority of Newgen Software Technologies Ltd and / or its s= ubsidiary Companies, as applicable.


---------------------------(end of broadcast)------------------= ---------
TIP 6: explain analyze is your friend
------=_Part_82701_7740560.1169116676650--