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
