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
