IDENTIFY_SYSTEM

A replication command providing basic replication information about a PostgreSQL node.

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:

Change history

Examples

$ psql "dbname=postgres host=localhost user=repl_user replication=1"
psql (12.4)
Type "help" for help.

postgres=# IDENTIFY_SYSTEM;
      systemid       | timeline |  xlogpos  | dbname
---------------------+----------+-----------+--------
 6301592708518993068 |        1 | 0/5002168 | 
(1 row)

Categories

Replication