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
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 |