Received: from localhost (maia-2.hub.org [200.46.204.187]) by postgresql.org (Postfix) with ESMTP id CC2D39FB2B6 for ; Thu, 18 Jan 2007 01:23:06 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.187]) (amavisd-new, port 10024) with ESMTP id 16007-07 for ; Thu, 18 Jan 2007 01:22:56 -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 4FA6B9FB2B4 for ; Thu, 18 Jan 2007 01:22:59 -0400 (AST) Received: (qmail 17907 invoked by uid 507); 18 Jan 2007 05:15:48 -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.196475 secs); 18 Jan 2007 05:15:48 -0000 Received: from unknown (HELO ngmail.newgen.co.in) (okhlaoffice@202.140.41.205) by mx.newgen.co.in with SMTP; 18 Jan 2007 05:15:48 -0000 Received: (qmail 16513 invoked by uid 504); 18 Jan 2007 05:14:29 -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.139865 secs); 18 Jan 2007 05:14:29 -0000 Received: from unknown (HELO ng4244a) (yogvinder@192.168.4.4) by ngmail.newgen.co.in with SMTP; 18 Jan 2007 05:14:26 -0000 Message-ID: <000a01c73abf$863c45d0$0404a8c0@central.newgen.local> From: "Yogvinder Singh" To: "Andy Shellam \(Mailing Lists\)" Cc: References: <001201c73a3e$33bbaf70$0404a8c0@central.newgen.local> <45AE370B.2070805@mailnetwork.co.uk> Subject: Re: Incremental Backup of a particular database Date: Thu, 18 Jan 2007 10:44:25 +0530 MIME-Version: 1.0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: 7bit 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.485 tagged_above=0 required=5 tests=AWL, DNS_FROM_RFC_ABUSE X-Spam-Level: X-Archive-Number: 200701/147 X-Sequence-Number: 24303 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.