• Browse categories
• PostgreSQL releases
  • PostgreSQL 14 (dev)
  • PostgreSQL 13 (latest)
  • PostgreSQL 12
  • PostgreSQL 11
  • PostgreSQL 10
  • PostgreSQL 9.6
  • PostgreSQL 9.5
  • PostgreSQL 9.4 (EOL)

Useful articles

Useful links

IDENTIFY_SYSTEM

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 the pg_controldata utility)
• the pg_control_recovery() and pg_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.4)
Type "help" for help.

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

References

Categories