Обсуждение:
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
Hi
On Thu, May 9, 2024 at 2:50 PM Rajan Pandey <rajanpandey2508@gmail.com> wrote:
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 deniedrajanx@b0be835adb74 postgresql % su cat /usr/local/pgsql/data/postgresql.auto.conf
Password:
su: Sorry
The issue is related with permissions, please make sure which user did the installation and update the postgresql.auto.conf file with that user permissions.
Regards
Kashif Zeeshan
Bitnine Global
Please help! Thank you. :)--RegardsRajan Pandey
Rajan Pandey <rajanpandey2508@gmail.com> writes: >> test=# ALTER SYSTEM SET shared_preload_libraries TO 'pg_tle'; >> ALTER SYSTEM >> test=# SELECT pg_reload_conf(); >> pg_reload_conf >> ---------------- >> t >> (1 row) Changing shared_preload_libraries requires a postmaster restart, not just config reload. The postmaster log would have told you that, but pg_reload_conf() can't really see the effects of its signal. regards, tom lane
On Thu, May 9, 2024 at 2:50 PM Rajan Pandey <rajanpandey2508@gmail.com> wrote: > > 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 notupdated: >> >> 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 itis 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 It seems you're trying to use the su command to switch to another user to read a file, but the su command is not the appropriate command for this purpose on macOS. If you want to read a file located in another user's directory, and you have the necessary permissions to access that file, you can simply use the cat command without su. Here's how you can do it: > > > Please help! Thank you. :) > -- > Regards > Rajan Pandey