Re: upgrade to PG11 on secondary fails (no initdb was launched) - Mailing list pgsql-admin

From Stephen Frost
Subject Re: upgrade to PG11 on secondary fails (no initdb was launched)
Date
Msg-id 20190523150834.GG2480@tamriel.snowman.net
Whole thread Raw
In response to upgrade to PG11 on secondary fails (no initdb was launched)  (Mariel Cherkassky <mariel.cherkassky@gmail.com>)
List pgsql-admin
Greetings (moved to -admin, where it should be...),

* Greg Clough (Greg.Clough@ihsmarkit.com) wrote:
> > 2019-05-23 04:17:02 EDT  23593  DETAIL:  The database cluster was initialized with PG_CONTROL_VERSION 960, but the
serverwas 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

Attachment

pgsql-admin by date:

Previous
From: Jakub Olczyk
Date:
Subject: Re: pg_backrest build dependencies rpm's
Next
From: Jakub Olczyk
Date:
Subject: Re: pg_backrest build dependencies rpm's