PostgreSQL extensions during switchover

From: Marian Pompura <marian(dot)pompura(at)gmail(dot)com>
To: pgsql-general(at)lists(dot)postgresql(dot)org
Subject: PostgreSQL extensions during switchover
Date: 2022-02-14 10:16:24
Message-ID: CAKL=_sjUR6F3DUd9xGD6DNfEtVx=4H8YHGupztyiMVXTFQ3_qw@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Dear all,

I have question regarding how extensions acting during switchover process.

We running PostgreSQL 11 HA primary/replication server that is configured
with repmgr.
Everything works fine but I am interested in matter of how extensions works
during failover/switchover.process.

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?

Thank you in advance,
Marian Pompura

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Julien Rouhaud 2022-02-14 10:27:15 Re: PostgreSQL extensions during switchover
Previous Message Andrus 2022-02-14 10:04:12 Re: How to split normal and overtime hours