Shoaib Mir wrote:
Even with ver 8.1 you can use WAL archive backups (PITR) to implement
an incremental backup strategy.
Yes, true, but it's harder with 8.1 as you always have to start from a
base backup and roll WAL logs forward - without a custom script you
cannot "wait" for new WAL logs to arrive and apply them on top of a base
backup.
There is a project in PgFoundry to allow for warm-standby in the 8.0 and
8.1 series, however this is reportedly built-in to 8.2 now.
-------------
Shoaib Mir
EnterpriseDB (www.enterprisedb.com <http://www.enterprisedb.com>)
On 1/17/07, *Andy Shellam (Mailing Lists)*
<[EMAIL PROTECTED]
<mailto:[EMAIL PROTECTED]>> wrote:
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,
> 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
!DSPAM:37,45ae3b61137103926781350!
---------------------------(end of broadcast)---------------------------
TIP 5: don't forget to increase your free space map settings
