Prevent new timeline during archive recovery

From: "Jonatan Evald Buus" <jonatan(dot)buus(at)cellpointmobile(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Prevent new timeline during archive recovery
Date: 2008-12-17 16:54:12
Message-ID: 113ce31b0812170854g7bc2c446x386ab4fa4f462147@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Greetings,
We're currently developing an alternative to pg_standby, internally named
pg_ha.
pg_ha uses Record Based Log Shipping fetched by the warm standby server at
millisecond intervals and will automatically restore completed WAL files on
the standby server to minimize the time required when restoring it to
production status after a failure on the primary server.
Once completed we'd be happy to donate the code to the PostGreSQL community
to assist in promoting the database server as a High Availability option.

During each restore cycle however we notice that PostGreSQL spawns a new
timeline for the recovered archive as described in section 24.3.4 at
http://www.postgresql.org/docs/8.3/static/continuous-archiving.html#BACKUP-BASE-BACKUP
.
Is it possible to specify that no new timeline should be spawned during the
archiver recovery process?

The only workaround otherwise appears to be to detect the current timeline
number using pg_controldata and rename copied WAL files accordingly prior to
initiating the archive recovery process.

Any input would be most appreciated.

Cheers
Jona

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Andrew Gould 2008-12-17 17:23:48 Re: Composite type evaluates to Null if any element is null
Previous Message Merlin Moncure 2008-12-17 16:50:57 Re: Composite type evaluates to Null if any element is null