Re:

2024-05-09 Thread zaidagilist
On Thu, May 9, 2024 at 2:50 PM Rajan Pandey  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 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




Re: PostgreSQL 17 Beta 1 release announcement draft

2024-05-15 Thread zaidagilist
Hello,

I am trying to open the 17 docs but it looks removed. Getting
following message "Page not found"

https://www.postgresql.org/docs/17/


Regards,
Zaid Shabbir

On Thu, May 16, 2024 at 10:16 AM Bertrand Drouvot
 wrote:
>
> Hi,
>
> On Wed, May 15, 2024 at 09:45:35PM -0400, Jonathan S. Katz wrote:
> > Hi,
> >
> > Attached is a copy of the PostgreSQL 17 Beta 1 release announcement draft.
>
> Thanks for working on it!
>
> I've one comment:
>
> > PostgreSQL 17 also introduces a new view, 
> > [`pg_wait_events`](https://www.postgresql.org/docs/17/view-pg-wait-events.html),
> >  which provides descriptions about wait events and can be combined with 
> > `pg_stat_activity` to give more insight into an operation.
>
> Instead of "to give more insight into an operation", what about "to give more
> insight about what a session is waiting for (should it be active)"?
>
> Regards,
>
> --
> Bertrand Drouvot
> PostgreSQL Contributors Team
> RDS Open Source Databases
> Amazon Web Services: https://aws.amazon.com
>
>