dba:postgresql:postgresql_basic_querys
Differences
This shows you the differences between two versions of the page.
| Both sides previous revisionPrevious revision | Next revisionBoth sides next revision | ||
| dba:postgresql:postgresql_basic_querys [2023/12/06 09:22] – [Change user password] dodger | dba:postgresql:postgresql_basic_querys [2023/12/06 09:22] – [dump/export all users with password] dodger | ||
|---|---|---|---|
| Line 641: | Line 641: | ||
| ===== dump/export all users with password ===== | ===== dump/export all users with password ===== | ||
| - | < | + | < |
| pg_dumpall --globals-only --file=all_roles_and_users.sql -h 127.0.0.1 | pg_dumpall --globals-only --file=all_roles_and_users.sql -h 127.0.0.1 | ||
| </ | </ | ||
dba/postgresql/postgresql_basic_querys.txt · Last modified: 2024/04/19 07:37 by dodger