creating the "pglogical" extension on Postgresql 9.6.11

Hello,

Have you rebooted your instance since adding pglogical into shared_preload_libraries?
If you run the sql command: "show shared_preload_libraries;" does pglogical show up?

Thanks,
John H

Hi John,

"pglogical" was already in "shared_preload_libraries" (I did not type it in.).
I have rebooted the instance.
The "show shared_preload_libraries;" command returned only one library - "rdsutils". This does strongly suggest that the "pglogical" library is not load (and is the root cause of the issue), however I'm unsure how to proceed (as "pglogical" is already in the "shared_preload_libraries" parameter).

Thanks
Jake

Hi John,

Gaaahhhh - user error. I mistook the "allowed" values to be the default values.

I added "pglogical" to the blank "shared_preload_libraries" parameter, rebooted the instance and I have been able to create the pglogical extension as expected.

Thank you for your time
Jake