- Neueste
- Die meisten Stimmen
- Die meisten Kommentare
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
Relevanter Inhalt
- AWS OFFICIALAktualisiert vor einem Jahr
- AWS OFFICIALAktualisiert vor 2 Jahren
- AWS OFFICIALAktualisiert vor 3 Jahren
- AWS OFFICIALAktualisiert vor 2 Jahren