IDENTIFY_SYSTEM
A replication command providing basic replication information
IDENTIFY_SYSTEM
is a replication command providing basic replication-related information about the PostgreSQL node it is executed on.
IDENTIFY_SYSTEM
was added in PostgreSQL 9.0.
Alternatives
The information provided by IDENTIFY_SYSTEM
can also be extracted from:
- the
pg_control
file (using thepg_controldata
utility) - the
pg_control_recovery()
andpg_control_system()
functions (PostgreSQL 9.6 and later)
Change history
- PostgreSQL 9.0
- added (commit 40f908bd)
Examples
$ psql "dbname=postgres host=localhost user=repl_user replication=1" psql (12.7) Type "help" for help. postgres=# IDENTIFY_SYSTEM; systemid | timeline | xlogpos | dbname ---------------------+----------+-----------+-------- 6301592708518993068 | 1 | 0/5002168 | (1 row)
References
- PostgreSQL documentation: Replication protocol