Hello

In Postgres "Backup and Restore" documentation I found
"Before restoring a SQL dump, all the users who own objects or were
granted permissions on objects in the dumped database must already
exist". How can I backup postgres users ?


Thanks in advance
GG

GG <gg (AT) mymail (DOT) pl> wrote:
pg_dumpall --globals-only >metadata.sql

will create a dump of users, roles and tablespaces as SQL script.

You can edit it if you only want specific users.

Yours,
Laurenz Albe