Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- 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).
Advertisement
Add Comment
Please, Sign In to add comment