Server Configuration (for troubleshooting support)
===
SELECT version();
SELECT name, current_setting(name), SOURCE
FROM pg_settings
WHERE SOURCE NOT IN ('default', 'override');
View encoding
===
SHOW SERVER_ENCODING;
SHOW CLIENT_ENCODING;
SELECT pg_encoding_to_char(encoding) FROM pg_database WHERE datname = 'db_name';
View data file path
===
SHOW DATA_DIRECTORY;
View postgresql.conf
===
SELECT * FROM pg_settings;
Check if PG is in recovery mode
===
SELECT pg_is_in_recovery();
View replication status
===
SELECT * FROM pg_stat_replication;
pid: Process id of walsender process
usesysid: OID of user which is used for Streaming replication.
usename: Name of user which is used for Streaming replication
application_name: Application name connected to master
client_addr: Address of standby/streaming replication
client_hostname: Hostname of standby.
client_port: TCP port number on which standby communicating with WAL sender
backend_start: Start time when SR connected to Master.
state: Current WAL sender state i.e streaming
sent_location: Last transaction location sent to standby.
write_location: Last transaction written on disk at standby
flush_location: Last transaction flush on disk at standby.
replay_location: Last transaction flush on disk at standby.
sync_priority: Priority of standby server being chosen as synchronous standby
sync_state: Sync State of standby (is it async or synchronous).
Comments