Re: PostgreSQL extensions during switchover - Mailing list pgsql-general

From Julien Rouhaud
Subject Re: PostgreSQL extensions during switchover
Date
Msg-id 20220214102715.6ozlrp52ciukus4f@jrouhaud
Whole thread Raw
In response to PostgreSQL extensions during switchover  (Marian Pompura <marian.pompura@gmail.com>)
List pgsql-general
Hi,

On Mon, Feb 14, 2022 at 11:16:24AM +0100, Marian Pompura wrote:
> 
> Let's say:
> 
> postgresql.conf configuration file on primary server:
> 
> shared_preload_libraries = 'pg_stat_statements,xxxx'
> 
> *Contrib package is installed on primary and replication server too.
> 
> postgresql.conf configuratioj file on replication server
> 
> shared_preload_libraries = '' is empty on replication server.
> 
> In case some scenario which will include switchover or failover to
> replication server.
> How it will act ? Switchover will be successful but new primary node will
> fail at startup process because shared_preload_libraries is empty but
> extensions are created in database? Or it's better to pre-configure same
> extensions into shared_preload_libraries parameter on replication server?

Having some extension installed without the required shared_preload_libraries
setting won't prevent postgres from starting.  The only thing that won't work
is using at least part of what the extension created on the database.

So the question is whether you want to make sure you have the same feature
available after a switchover, and if you do then yes you should make sure that
you have a consistent configuration across all your nodes.



pgsql-general by date:

Previous
From: Marian Pompura
Date:
Subject: PostgreSQL extensions during switchover
Next
From: Radoslav Nedyalkov
Date:
Subject: Re: table not found on publisher