pg_dumpall with flag --no-role-passwords omits roles comments as well

From: Bartosz Chroł <bartosz(dot)chrol(at)handen(dot)pl>
To: "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org>
Subject: pg_dumpall with flag --no-role-passwords omits roles comments as well
Date: 2024-03-20 17:40:55
Message-ID: AS8P194MB1271CDA0ADCA7B75FCD8E767F7332@AS8P194MB1271.EURP194.PROD.OUTLOOK.COM
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hello,
I've tried to dump roles using the following call to pg_dumpall:
pg_dumpall.exe --roles-only --no-role-passwords
However I noticed that comments on roles are also omitted from the dump, as if --no--comments flag was set - but it wasn't.
When I call `pg_dumpall.exe --roles-only` than it works as expected - both passwords and comments are dumped.

Is it correct behaviour? It doesn't look like to me, but maybe I'm missing something. I've checked PostgreSQL 16.2 (on Windows 11 and Ubuntu 20) and 14.0 (on Windows Server 2019), same everywhere.

Best regards
Bartek

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Celia McInnis 2024-03-20 17:54:25 Re: Dropping a temporary view?
Previous Message Celia McInnis 2024-03-20 17:22:00 Re: Dropping a temporary view?