Received: from localhost (maia-3.hub.org [200.46.204.184]) by postgresql.org (Postfix) with ESMTP id 8A46C9FB28E for ; Thu, 18 Jan 2007 07:39:38 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.184]) (amavisd-new, port 10024) with ESMTP id 62662-06 for ; Thu, 18 Jan 2007 07:39:21 -0400 (AST) X-Greylist: from auto-whitelisted by SQLgrey-1.7.4 Received: from newgen.co.in (unknown [202.131.146.233]) by postgresql.org (Postfix) with SMTP id 094099FB1D2 for ; Thu, 18 Jan 2007 07:39:24 -0400 (AST) Received: (qmail 30283 invoked by uid 507); 18 Jan 2007 11:25:17 -0000 Received: from 202.140.41.205 by mx.newgen.co.in (envelope-from , uid 501) with qmail-scanner-1.25 (fireav: ???. spamassassin: 3.1.3. Clear:RC:0(202.140.41.205):SA:0(-100.0/4.5):. Processed in 0.594481 secs); 18 Jan 2007 11:25:17 -0000 Received: from unknown (HELO ngmail.newgen.co.in) (okhlaoffice@202.140.41.205) by mx.newgen.co.in with SMTP; 18 Jan 2007 11:25:16 -0000 Received: (qmail 20159 invoked by uid 504); 18 Jan 2007 11:23:23 -0000 Received: from yogvinder@newgen.co.in by ngmail.newgen.co.in by uid 501 with qmail-scanner-1.21 (fireav: ???. Clear:RC:1(192.168.4.4):. Processed in 2.224914 secs); 18 Jan 2007 11:23:23 -0000 Received: from unknown (HELO ng4244a) (yogvinder@192.168.4.4) by ngmail.newgen.co.in with SMTP; 18 Jan 2007 11:23:20 -0000 Message-ID: <001101c73af3$0f0d43e0$0404a8c0@central.newgen.local> From: "Yogvinder Singh" To: "Shoaib Mir" Cc: References: <001201c73a3e$33bbaf70$0404a8c0@central.newgen.local> <45AE370B.2070805@mailnetwork.co.uk> <000a01c73abf$863c45d0$0404a8c0@central.newgen.local> <009901c73ac5$d45de4c0$0404a8c0@central.newgen.local> Subject: Re: Incremental Backup of a particular database Date: Thu, 18 Jan 2007 16:53:19 +0530 MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_NextPart_000_000E_01C73B21.283FFC30" X-Priority: 3 X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook Express 6.00.2800.1807 X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1896 X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0.241 tagged_above=0 required=5 tests=AWL, HTML_MESSAGE X-Spam-Level: X-Archive-Number: 200701/152 X-Sequence-Number: 24308 This is a multi-part message in MIME format. ------=_NextPart_000_000E_01C73B21.283FFC30 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable 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 -----=20 From: Shoaib Mir=20 To: Yogvinder Singh=20 Cc: pgsql-admin@postgresql.org=20 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.=20 ---------------- 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=20 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?=20 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 -----=20 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,=20 > 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" > 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=20 > > 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.=20 > > > > > > 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=20 > > > 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=20 > > > particular database out of many databases? On which version = this is > > > supported? IF not supported, is there any alternative way to = handle > > > this situatio. > > >=20 > > > Regards, > > > Yogvinder Singh, > > > !DSPAM:37,45ae2b2f137105304223843! Disclaimer :- This e-mail = message > > > including any attachment may contain confidential, proprietary = or=20 > > > 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,=20 > > > 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=20 > > > 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=20 > > > 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? > >=20 > > http://www.postgresql.org/docs/faq > > > > > > Disclaimer :- This e-mail message including any attachment may = contain=20 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=20 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=20 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=20 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. > >=20 > ---------------------------(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.=20 ---------------------------(end of = broadcast)--------------------------- TIP 6: explain analyze is your friend ------=_NextPart_000_000E_01C73B21.283FFC30 Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable
So it means there is no way i can = take=20 incremental backup of  one of the databases from a postgresql = database=20 server??
 
Regards,
Yogvinder Singh,
Software Engineer, E-WorkStyle=20 Group,
Newgen Software Technologies Ltd.
D-152, Okhla Phase - = 1
New=20 Delhi
Tel no 26815467 Ext 143
 
 
----- Original Message -----
From:=20 Shoaib Mir=20
Sent: Thursday, January 18, = 2007 4:07=20 PM
Subject: Re: [ADMIN] = Incremental Backup=20 of a particular database

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

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

On 1/18/07, Yogvinder=20 Singh < yogvinder@newgen.co.in>=20 wrote:
pg_dump=20 is a utility for saving a PostgreSQL database into a script or an=20
archive file. The script files are in plain-text format and=20 contain  the SQL
commands required to reconstruct the = database=20 to the state  it      =20 = was  in
at  the  time  it = ; was=20 saved.

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


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


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


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



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


---------------------------(end of=20 broadcast)---------------------------
TIP 6: explain analyze is = your=20 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. ------=_NextPart_000_000E_01C73B21.283FFC30--