Thread: psql meta commands in pg16
Hi All,
[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 |
Sr. PostgreSQL Database Administrator,
Mobile: 7755929449.
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
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,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.
Thanks for the update David. I missed it in release notes.
Thanks & Regards,
Naveen Kumar .M,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.