Postgres Pro
Downloads
Home   >   mailing lists

Re: pg_dumpall with flag --no-role-passwords omits roles comments as well - Mailing list pgsql-general

From Dominique Devienne
Subject Re: pg_dumpall with flag --no-role-passwords omits roles comments as well
Date
Msg-id CAFCRh-86h2-2EAN+8qBmzpS1J4Gxv0U20s6SpNZy_eDv7Tu4sg@mail.gmail.com
Whole thread Raw
In response to Re: pg_dumpall with flag --no-role-passwords omits roles comments as well  (Daniel Gustafsson <daniel@yesql.se>)
Responses Re: pg_dumpall with flag --no-role-passwords omits roles comments as well  (Dominique Devienne <ddevienne@gmail.com>)
List pgsql-general
Tree view
On Thu, Mar 21, 2024 at 11:46 AM Daniel Gustafsson <daniel@yesql.se> wrote:
> However I noticed that comments on roles are also omitted from the dump, as if --no--comments flag was set - but it wasn't.

Comments on roles are stored against the pg_authid catalog relation

Hi. What do you mean? ROLEs are not stored in that relation.
And AFAIK, only accessible via functions using the OID or NAME.

So the relation used, pg_authid or pg_roles, shouldn't matter, no?

Here's my own query for example:
```
select rolname, rolsuper, rolinherit, rolcreaterole,
       rolcreatedb, rolcanlogin, rolreplication, rolbypassrls,
       oid, shobj_description(oid, 'pg_authid')
  from pg_roles
...
```
--DD

pgsql-general by date:

Previous
From: Daniel Gustafsson
Date:
Subject: Re: pg_dumpall with flag --no-role-passwords omits roles comments as well
Next
From: Francisco Olarte
Date:
Subject: Re: Dropping a temporary view?