Re:

Hi everyone, I just installed Postgres and pg_tle extension as I was looking to contribute to pg_tle. 

Somehow, I am unable to update the shared_preload_libraries. It feels like ALTER has happened but the SPL value is not updated:

test=# show shared_preload_libraries;
 shared_preload_libraries
--------------------------
 
(1 row)

test=# ALTER SYSTEM SET shared_preload_libraries TO 'pg_tle';
ALTER SYSTEM
test=# SELECT pg_reload_conf();
 pg_reload_conf
----------------
 t
(1 row)

test=# show shared_preload_libraries;
 shared_preload_libraries
--------------------------
 
(1 row)

test=# 

 

I'm unable to open the postgresql.conf file to update it either. I provided the correct macbook password above. But it is not accepted! :/

rajanx@b0be835adb74 postgresql % cat /usr/local/pgsql/data/postgresql.auto.conf
cat: /usr/local/pgsql/data/postgresql.auto.conf: Permission denied

rajanx@b0be835adb74 postgresql % su cat /usr/local/pgsql/data/postgresql.auto.conf
Password:
su: Sorry

Please help! Thank you. :)

--

Regards

Rajan Pandey