Difference between revisions of "Postgres config commands"

From UVOO Tech Wiki
Jump to navigation Jump to search
(Created page with "SHOW max_connections; RESET max_connections; SHOW all;")
 
 
Line 4: Line 4:
  
 
SHOW all;
 
SHOW all;
 +
 +
select * from pg_stat_replication;
 +
 +
On replica (streaming replication in my case):
 +
 +
select * from pg_stat_wal_receiver;

Latest revision as of 19:25, 18 November 2022

SHOW max_connections;

RESET max_connections;

SHOW all;

select * from pg_stat_replication;

On replica (streaming replication in my case):

select * from pg_stat_wal_receiver;