data type can be used to store LSN (Log Sequence Number) data which is a pointer to a location in the XLOG. This type is a representation of XLogRecPtr and an internal system type of PostgreSQL. Internally pg_ident.conf | 10 global | 11 pg_clog | 12 pg_snapshots | 13 pg_multixact | 14 PG_VERSION | 15 pg_xlog | 16 pg_hba.conf | 17 pg_stat_tmp | 18 pg_subtrans | 19 (19 rows) 9.25. System Information Functions non-exclusive pg_start_backup, non-exclusive pg_stop_backup, pg_is_in_backup, pg_backup_start_time and pg_xlog_location_diff). Table 9-78. Backup Control Functions Name Return Type Description pg_create_restore_point(name

data type can be used to store LSN (Log Sequence Number) data which is a pointer to a location in the XLOG. This type is a representation of XLogRecPtr and an internal system type of PostgreSQL. Internally pg_ident.conf | 10 global | 11 pg_clog | 12 pg_snapshots | 13 pg_multixact | 14 PG_VERSION | 15 pg_xlog | 16 pg_hba.conf | 17 pg_stat_tmp | 18 pg_subtrans | 19 (19 rows) 9.25. System Information Functions non-exclusive pg_start_backup, non-exclusive pg_stop_backup, pg_is_in_backup, pg_backup_start_time and pg_xlog_location_diff). Table 9-78. Backup Control Functions Name Return Type Description pg_create_restore_point(name

data type can be used to store LSN (Log Sequence Number) data which is a pointer to a location in the XLOG. This type is a representation of XLogRecPtr and an internal system type of PostgreSQL. Internally pg_ident.conf | 10 global | 11 pg_clog | 12 pg_snapshots | 13 pg_multixact | 14 PG_VERSION | 15 pg_xlog | 16 pg_hba.conf | 17 pg_stat_tmp | 18 pg_subtrans | 19 (19 rows) 9.25. System Information Functions functions cannot be executed during recovery (except pg_is_in_backup, pg_backup_start_time and pg_xlog_location_diff). Table 9-68. Backup Control Functions Name Return Type Description pg_create_restore_point(name

data type can be used to store LSN (Log Sequence Number) data which is a pointer to a location in the XLOG. This type is a representation of XLogRecPtr and an internal system type of PostgreSQL. Internally pg_ident.conf | 10 global | 11 pg_clog | 12 pg_snapshots | 13 pg_multixact | 14 PG_VERSION | 15 pg_xlog | 16 pg_hba.conf | 17 pg_stat_tmp | 18 323 Chapter 9. Functions and Operators pg_subtrans | 19 functions cannot be executed during recovery (except pg_is_in_backup, pg_backup_start_time and pg_xlog_location_diff). 338 Chapter 9. Functions and Operators Table 9-68. Backup Control Functions Name

data type can be used to store LSN (Log Sequence Number) data which is a pointer to a location in the XLOG. This type is a representation of XLogRecPtr and an internal system type of PostgreSQL. Internally pg_ident.conf | 10 global | 11 pg_clog | 12 pg_snapshots | 13 pg_multixact | 14 PG_VERSION | 15 pg_xlog | 16 pg_hba.conf | 17 pg_stat_tmp | 18 pg_subtrans | 19 (19 rows) 9.25. System Information Functions functions cannot be executed during recovery (except pg_is_in_backup, pg_backup_start_time and pg_xlog_location_diff). Table 9-65. Backup Control Functions Name Return Type Description pg_create_restore_point(name

data type can be used to store LSN (Log Sequence Number) data which is a pointer to a location in the XLOG. This type is a representation of XLogRecPtr and an internal system type of PostgreSQL. Internally pg_ident.conf | 10 global | 11 pg_clog | 12 pg_snapshots | 13 pg_multixact | 14 PG_VERSION | 15 pg_xlog | 16 pg_hba.conf | 17 pg_stat_tmp | 18 pg_subtrans | 19 (19 rows) 9.25. System Information Functions functions cannot be executed during recovery (except pg_is_in_backup, pg_backup_start_time and pg_xlog_location_diff). Table 9-65. Backup Control Functions 302 Chapter 9. Functions and Operators Name

functions cannot be executed during recovery (except pg_is_in_backup, pg_backup_start_time and pg_xlog_location_diff). Table 9-61. Backup Control Functions Name Return Type Description pg_create_restore_point(name performing restore (restricted to superusers) pg_current_xlog_insert_location() text Get current transaction log insert location pg_current_xlog_location() text Get current transaction log write location ) timestamp with time zone Get start time of an on-line exclusive backup in progress. pg_switch_xlog() text Force switch to a new transaction log file (restricted to superusers) pg_xlogfile_name(location

functions cannot be executed during recovery (except pg_is_in_backup, pg_backup_start_time and pg_xlog_location_diff). Table 9-61. Backup Control Functions Name Return Type Description 303 Chapter performing restore (restricted to superusers) pg_current_xlog_insert_location() text Get current transaction log insert location pg_current_xlog_location() text Get current transaction log write location () timestamp with time zone Get start time of an on-line exclusive backup in progress. pg_switch_xlog() text Force switch to a new transaction log file (restricted to superusers) pg_xlogfile_name(location

assist in making on-line backups. These functions cannot be exe- cuted during recovery (except pg_xlog_location_diff). Table 9-60. Backup Control Functions Name Return Type Description pg_create_restore_point(name performing restore (restricted to superusers) pg_current_xlog_insert_location() text Get current transaction log insert location pg_current_xlog_location() text Get current transaction log write location pg_stop_backup() text Finish performing on-line backup (restricted to superusers or replication roles) pg_switch_xlog() text Force switch to a new transaction log file (restricted to superusers) pg_xlogfile_name(location

9-60 assist in making on-line backups. These functions cannot be executed during recovery (except pg_xlog_location_diff). Table 9-60. Backup Control Functions Name Return Type Description pg_create_restore_point(name performing restore (restricted to superusers) pg_current_xlog_insert_location() text Get current transaction log insert location pg_current_xlog_location() text Get current transaction log write location pg_stop_backup() text Finish performing on-line backup (restricted to superusers or replication roles) pg_switch_xlog() text Force switch to a new transaction log file (restricted to superusers) pg_xlogfile_name(location