How to avoid base backup in automated failover

From: chinnaobi <chinnaobi(at)gmail(dot)com>
To: pgsql-hackers(at)postgresql(dot)org
Subject: How to avoid base backup in automated failover
Date: 2012-06-04 13:14:37
Message-ID: 1338815677378-5711147.post@n5.nabble.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general pgsql-hackers

Hi all,

Recently I was writing an application to implement automated failover with
env: Two 2008 R2 servers, Network area storage, asynchronous replication,
WAL archive on primary enabled.

Is there any way to avoid starting standby server always from base backup in
automated failover. I see the database is growing huge. I can't keep doing
base backup every day.

Please suggest solution

Regards,
Reddy

--
View this message in context: http://postgresql.1045698.n5.nabble.com/How-to-avoid-base-backup-in-automated-failover-tp5711147.html
Sent from the PostgreSQL - hackers mailing list archive at Nabble.com.

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Bruce Momjian 2012-06-04 14:16:45 Re: Re: [GENERAL] pg_upgrade from 9.0.7 to 9.1.3: duplicate key pg_authid_oid_index
Previous Message Thomas Kellerer 2012-06-04 13:05:56 Re: TYPE TABLE OF NUMBER

Browse pgsql-hackers by date

  From Date Subject
Next Message Robert Haas 2012-06-04 14:12:03 Re: 9.2beta1, parallel queries, ReleasePredicateLocks, CheckForSerializableConflictIn in the oprofile
Previous Message Peter Eisentraut 2012-06-04 12:14:31 Re: pg_basebackup --xlog compatibility break