Обсуждение: psql meta commands in pg16

Поиск
Список
Период
Сортировка

psql meta commands in pg16

От
Naveen Kumar
Дата:
Hi All,

I recently upgraded my database from pg14 to pg16. found change with pg16 psql meta command \du. 
Is anyone seeing the same thing? Is this change in pg16 or is it missed in pg16?

[root@db-101]# /usr/pgsql-14/bin/psql -U postgres -d postgres -p 5432 -h localhost
Password for user postgres:
psql (14.11, server 16.2)
WARNING: psql major version 14, server major version 16.
         Some psql features might not work.
SSL connection (protocol: TLSv1.3, cipher: TLS_AES_256_GCM_SHA384, bits: 256, compression: off)
Type "help" for help.

postgres=> \du naveen
            List of roles
 Role name | Attributes | Member of
-----------+------------+------------
 naveen    |            | {deployer}

postgres=> \q

[root@ db-101]# /usr/pgsql-16/bin/psql -U postgres -d postgres -p 5432 -h localhost
Password for user postgres:
psql (16.2)
SSL connection (protocol: TLSv1.3, cipher: TLS_AES_256_GCM_SHA384, compression: off)
Type "help" for help.

postgres=> \du naveen
     List of roles
 Role name | Attributes
-----------+------------
 naveen    |


Thanks & Regards,
Naveen Kumar .M,
Sr. PostgreSQL Database Administrator,
Mobile: 7755929449.

Re: psql meta commands in pg16

От
"David G. Johnston"
Дата:
On Tue, Mar 12, 2024 at 7:03 PM Naveen Kumar <naveenchowdaryon@gmail.com> wrote:

I recently upgraded my database from pg14 to pg16. found change with pg16 psql meta command \du. 
Is anyone seeing the same thing? Is this change in pg16 or is it missed in pg16?

It made the release notes in the psql section. Not important enough for top-of-page.

David J.

Re: psql meta commands in pg16

От
Naveen Kumar
Дата:
Thanks for the update David. I missed it in release notes. 

psql command \drg to show role membership details


Thanks & Regards,
Naveen Kumar .M,
Sr. PostgreSQL Database Administrator,
Mobile: 7755929449.



On Wed, 13 Mar 2024 at 5:40 AM, David G. Johnston <david.g.johnston@gmail.com> wrote:
On Tue, Mar 12, 2024 at 7:03 PM Naveen Kumar <naveenchowdaryon@gmail.com> wrote:

I recently upgraded my database from pg14 to pg16. found change with pg16 psql meta command \du. 
Is anyone seeing the same thing? Is this change in pg16 or is it missed in pg16?

It made the release notes in the psql section. Not important enough for top-of-page.

David J.