Differences

This shows you the differences between two versions of the page.

--- dba:postgresql:postgresql_basic_querys [2023/10/23 07:24] – [Locks] dodger
+++ dba:postgresql:postgresql_basic_querys [2023/12/06 09:22] – [Change user password] dodger
@@ Line 604: / Line 604: @@
 </code>
-This query will list all //blocking sessions//:
+This query will list all //blocking sessions//, see [[https://wiki.postgresql.org/wiki/Lock_Monitoring|official documentation]]:
 <code sql>
 SET application_name='%your_logical_name%';
@@ Line 639: / Line 639: @@
 </code>
+===== dump/export all users with password =====
+<code sql>
+pg_dumpall --globals-only --file=all_roles_and_users.sql -h 127.0.0.1
+</code>
 ===== List extensions installed =====