| From: | Stephen Frost <sfrost(at)snowman(dot)net> |
|---|---|
| To: | Greg Clough <Greg(dot)Clough(at)ihsmarkit(dot)com> |
| Cc: | Mariel Cherkassky <mariel(dot)cherkassky(at)gmail(dot)com>, PostgreSQL mailing lists <pgsql-admin(at)postgresql(dot)org> |
| Subject: | Re: upgrade to PG11 on secondary fails (no initdb was launched) |
| Date: | 2019-05-23 15:08:35 |
| Message-ID: | 20190523150834.GG2480@tamriel.snowman.net |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-admin pgsql-performance |
Greetings (moved to -admin, where it should be...),
* Greg Clough (Greg(dot)Clough(at)ihsmarkit(dot)com) wrote:
> > 2019-05-23 04:17:02 EDT 23593 DETAIL: The database cluster was initialized with PG_CONTROL_VERSION 960, but the server was compiled with PG_CONTROL_VERSION 1100.
>
> It appears that you have not upgraded the standby server, so either use "rsync" or simply destroy and rebuild it from scratch "repmgr standby clone..."
You can't use the rsync method described in the pg_upgrade documentation
after the primary has been started, you'll end up with corruption.
Thanks,
Stephen
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Jakub Olczyk | 2019-05-24 07:16:08 | Re: pg_backrest build dependencies rpm's |
| Previous Message | Stephen Frost | 2019-05-23 15:06:58 | Re: Fwd: upgrade to PG11 on secondary fails (no initdb was launched) |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tom Lane | 2019-05-23 17:17:30 | Re: Generic Plans for Prepared Statement are 158155 times slower than Custom Plans |
| Previous Message | Stephen Frost | 2019-05-23 15:06:58 | Re: Fwd: upgrade to PG11 on secondary fails (no initdb was launched) |