From: | M Jane <mskiesewetter(at)gmail(dot)com> |
---|---|
To: | pgsql-admin(at)postgresql(dot)org, pgsql-admin(at)lists(dot)postgresql(dot)org |
Subject: | Postgresql 9.6.12 switchover failing |
Date: | 2019-03-08 14:41:28 |
Message-ID: | CANBd27KqYcdxSfmbyMDCSQLOkLKKrA0BeVwDHfXDbxOdqoa1JA@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-admin |
Hi everyone,
I have a strange issue on my testing postgresql cluster.
I have 2 nodes with postgresql 9.6.12 on RHEL7 .
The slave is being updated through hotstandby streaming replication.
In the past ( 9.6.8 and earlier), I was able to do a clean switchover
without any issues.
I did the following steps:
1. Check if the standby is uptodate
2. If so, shutdown the primary
3. pg_ctl promote the standby
4. Create a recovery.conf on the former primary and start the instance.
This worked just fine, with in the end the roles of the nodes changed.
Now I have version 9.6.12 and am trying to do the same.
The steps 1 to 3 works just fine.
But bringing up the old primary as a slave doesn't work. I get errors (
like >FATAL: requested timeline 5 is not a child of this server's history)
and the instances shuts down automatically.
I know I can fix it with pg_rewind ( have done it), but am confused about
this.
Does anyone have the same issue? Or has anyone encountered the same problem?
Thanks in advance.
regards,
Marian
From | Date | Subject | |
---|---|---|---|
Next Message | Peter | 2019-03-08 15:22:38 | Re: Upgrade 10.5->10.6 : db crash BUS ERROR (sig 10), reproducible |
Previous Message | Shreeyansh Dba | 2019-03-08 13:34:43 | Re: Backup restore question "could not locate required checkpoint record" |