creating the "pglogical" extension on Postgresql 9.6.11

Question

Hi,  
  
I'm able to create/add other extensions (pg_hint_plan, postgis) to my database, however when I attempt to create the pglogical extension ("CREATE EXTENSION pglogical"), an error is returned ("pglogical is not in shared_preload_libraries").  
  
"pglogical" appears to be one of the default libraries in the "shared_preload_libraries" parameter group.  
  
Is there a known issue with the "pglogical" extension and RDS at this time?  
  
Thanks

notSoLogical · Answer

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

AWS-JohnH · Answer

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

notSoLogical · Answer

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

Saddam · Answer

Hi,
Am running postgresql on an  ec2 instance and  added 
```
shared_preload_libraries = 'pglogical'
```
  to the  postgresql.conf loacated in /etc/postgresql/13/main/posgresql.config file . After updating posgresql.config file, I have restarted my postgres by command 
```
sudo systemctl restart postgresql
```
 Following posgresql restart I logged into the dba and executed 
```
CREATE EXTENSION pglogical;
```
 which resolved my issue

creating the "pglogical" extension on Postgresql 9.6.11

Relevant content