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
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 |