PostgreSQL 管理函数参考

Configuration Settings Functions

current_setting set_config

Server Signaling Functions

pg_cancel_backend pg_log_backend_memory_contexts pg_reload_conf pg_rotate_logfile pg_terminate_backend

Backup Control Functions

pg_create_restore_point pg_current_wal_flush_lsn pg_current_wal_insert_lsn pg_current_wal_lsn pg_start_backup pg_stop_backup pg_switch_wal pg_is_in_backup pg_backup_start_time pg_walfile_name pg_walfile_name_offset pg_wal_lsn_diff

Recovery Information Functions

pg_is_in_recovery pg_last_wal_receive_lsn pg_last_wal_replay_lsn pg_last_xact_replay_timestamp

Recovery Control Functions

pg_is_wal_replay_paused pg_get_wal_replay_pause_state pg_promote pg_wal_replay_pause pg_get_wal_replay_pause_state() pg_is_wal_replay_paused() pg_wal_replay_resume

Snapshot Synchronization Functions

pg_export_snapshot

Replication Management Functions

pg_create_physical_replication_slot pg_drop_replication_slot pg_create_logical_replication_slot pg_copy_physical_replication_slot pg_copy_logical_replication_slot pg_logical_slot_get_changes pg_logical_slot_peek_changes pg_logical_slot_get_changes() pg_logical_slot_get_binary_changes pg_logical_slot_peek_binary_changes pg_logical_slot_peek_changes() pg_replication_slot_advance pg_replication_origin_create pg_replication_origin_drop pg_replication_origin_oid pg_replication_origin_session_setup pg_replication_origin_session_reset pg_replication_origin_session_setup() pg_replication_origin_session_is_setup pg_replication_origin_session_progress pg_replication_origin_xact_setup pg_replication_origin_xact_reset pg_replication_origin_xact_setup() pg_replication_origin_advance pg_replication_origin_progress pg_logical_emit_message

Database Object Size Functions

pg_column_size pg_column_compression pg_database_size pg_indexes_size pg_relation_size pg_total_relation_size pg_table_size pg_size_bytes pg_size_pretty pg_tablespace_size

Database Object Location Functions

pg_relation_filenode pg_relation_filepath pg_filenode_relation

Collation Management Functions

pg_collation_actual_version pg_import_system_collations

Partitioning Information Functions

pg_partition_tree pg_partition_ancestors pg_partition_root

Index Maintenance Functions

brin_summarize_new_values brin_summarize_range brin_summarize_new_values brin_desummarize_range gin_clean_pending_list

Generic File Access Functions

pg_ls_dir pg_ls_logdir pg_ls_waldir pg_ls_archive_statusdir pg_ls_tmpdir pg_read_file pg_read_binary_file pg_read_file convert_from pg_stat_file

Advisory Lock Functions

pg_advisory_lock pg_advisory_lock_shared pg_advisory_unlock pg_advisory_unlock_all pg_advisory_unlock_shared pg_advisory_xact_lock pg_advisory_xact_lock_shared pg_try_advisory_lock pg_try_advisory_lock_shared pg_try_advisory_xact_lock pg_try_advisory_xact_lock_shared