| 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: | Whole Thread | Raw Message | 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
| 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 |