Ciberterminal Wiki

User Tools

Site Tools

Trace:
dba:postgresql:postgresql_basic_querys

Differences

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

Link to this comparison view

Both sides previous revisionPrevious revision
Next revision		Previous revision
Next revisionBoth sides next revision
dba:postgresql:postgresql_basic_querys [2023/10/23 07:24] – [Locks] dodgerdba:postgresql:postgresql_basic_querys [2024/03/15 09:16] – [list objects in schema] dodger
Line 235: Line 235:
  
 ===== list objects in schema ===== ===== list objects in schema =====
-Change ''<SCHEMA_NAME>'':+Change ''<SCHEMA_NAME>'' : 
 + 
 <code sql> <code sql>
 select n.nspname as schema_name, select n.nspname as schema_name,
Line 604: Line 606:
 </code> </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> <code sql>
 SET application_name='%your_logical_name%'; SET application_name='%your_logical_name%';
Line 639: Line 641:
 </code> </code>
  
 +
 +===== dump/export all users with password =====
 +<code bash>
 +pg_dumpall --globals-only --file=all_roles_and_users.sql -h 127.0.0.1
 +</code>
  
 ===== List extensions installed ===== ===== List extensions installed =====
dba/postgresql/postgresql_basic_querys.txt · Last modified: 2024/04/19 07:37 by dodger