Received: from localhost (maia-2.hub.org [200.46.204.187]) by postgresql.org (Postfix) with ESMTP id CF4409FA66C for ; Thu, 18 Jan 2007 13:18:09 -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 32554-05 for ; Thu, 18 Jan 2007 13:18:00 -0400 (AST) X-Greylist: delayed 00:28:05.182417 by SQLgrey-1.7.4 Received: from svr4.postgresql.org (svr4.postgresql.org [66.98.251.159]) by postgresql.org (Postfix) with ESMTP id 1F0819FB2C6 for ; Thu, 18 Jan 2007 13:15:59 -0400 (AST) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.3 Received: from brain.cayuse.com (mail.cayuse.com [66.213.255.190]) by svr4.postgresql.org (Postfix) with ESMTP id 14D0B5AF989 for ; Thu, 18 Jan 2007 16:47:52 +0000 (GMT) Received: from SamsBox2 ([10.255.7.60]) (authenticated bits=0) by brain.cayuse.com (8.13.1/8.13.1) with ESMTP id l0IGlkF8003836 (version=TLSv1/SSLv3 cipher=RC4-MD5 bits=128 verify=NO); Thu, 18 Jan 2007 08:47:47 -0800 Message-ID: <018f01c73b20$633c7fd0$3c07ff0a@SamsBox2> From: "Samuel B. Quiring" To: "Yogvinder Singh" , 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 06:21:29 -0800 MIME-Version: 1.0 Content-Type: text/plain; format=flowed; charset="iso-8859-1"; reply-type=original Content-Transfer-Encoding: 7bit X-Priority: 3 X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook Express 6.00.2900.3028 X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.3028 X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0.001 tagged_above=0 required=5 tests=BAYES_50 X-Spam-Level: X-Archive-Number: 200701/158 X-Sequence-Number: 24314 You can use pg_dump while the application(s) that use the database are active. pg_dump saves that database at a point in time. If the application(s) continue to modify the database after you use pg_dump, the script/archive file created by pg_dump will not contain those modifications. ----- Original Message ----- From: "Yogvinder Singh" To: Sent: Wednesday, January 17, 2007 9:59 PM Subject: Re: [ADMIN] Incremental Backup of a particular database > 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 >