From: Rajan Pandey <rajanpandey2508(at)gmail(dot)com>
To: pgsql-hackers(at)postgresql(dot)org
Subject:
Date: 2024-05-09 09:50:36
Message-ID: CAPr50M=JnKaaJ3B9zaDFr5dHRCKFOB4qy6G+TDXJYtEs0jCHNw@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

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(at)b0be835adb74 postgresql % cat
> /usr/local/pgsql/data/postgresql.auto.conf
> cat: /usr/local/pgsql/data/postgresql.auto.conf: Permission denied

rajanx(at)b0be835adb74 postgresql % su cat
> /usr/local/pgsql/data/postgresql.auto.conf
> Password:
> su: Sorry
>

Please help! Thank you. :)
--
Regards
Rajan Pandey

Responses

  • Re: at 2024-05-09 09:59:40 from Kashif Zeeshan
  • Re: at 2024-05-09 13:29:55 from Tom Lane
  • Re: at 2024-05-10 03:14:57 from zaidagilist

Browse pgsql-hackers by date

  From Date Subject
Next Message Kashif Zeeshan 2024-05-09 09:59:40 Re:
Previous Message Andy Fan 2024-05-09 09:44:49 Re: Parallel CREATE INDEX for GIN indexes