Search PostgreSQL documentation

pg_uuidv7ExtensionsExtensionsFunctions and aggregates · ExtensionsCreate UUIDv7 values in postgres pg_uuidv7 Functions and aggregates pg_validatorExtensionsExtensionsFeatures · ExtensionsPostgreSQL extension to validate data with trigger postgres postgresql postgresql-extension validate validation validator pg_validator Features pg_variablesExtensionsExtensionsFeatures · ExtensionsSession-scoped variables with scalar, array, and record types pg_variables Features pg_variant_functionsExtensionsExtensionsFunctions and aggregates · ExtensionsVariant summary and allele-frequency functions over TINYINT[] genotype arrays pg_variant_functions Functions and aggregates pg_vartypeExtensionsExtensionsData types · ExtensionsMultiple scalar types in a single column data-type scalar-types pg_vartype Data types pg_vault_tdeExtensionsExtensionsSecurity · ExtensionsTransparent Data Encryption for PostgreSQL through custom table and index access methods encryption tde transparent data encryption aes-256-gcm security table access method encrypted_heap km… pg_vector_embeddingExtensionsExtensionsAI and vectors · ExtensionsTrigger-driven vector embedding through external HTTP services and a background queue. embedding vector http queue pg_vector_embedding AI and vectors pg_verifybackupManual ChaptersPG18verify the integrity of a base backup of a PostgreSQL cluster Synopsis pg_verifybackup [option...] pg_verifybackup --exit-on-errorCommand-line ToolsPG18pg_verifybackup › Optionse--exit-on-error Exit as soon as a problem with the backup is detected. If this option is not specified, pg_verifybackup will continue checking the backup even after a problem has been detec… pg_verifybackup --format=formatCommand-line ToolsPG18pg_verifybackup › OptionsF format--format=format Specifies the format of the backup. format can be one of the following: pplain Backup consists of plain files with the same layout as the source server's data directo… pg_verifybackup --helpCommand-line ToolsPG18pg_verifybackup › Options?--help Show help about pg_verifybackup command line arguments, and exit. pg_verifybackup --ignore=pathCommand-line ToolsPG18pg_verifybackup › Optionsi path--ignore=path Ignore the specified file or directory, which should be expressed as a relative path name, when comparing the list of data files actually present in the backup to those l… pg_verifybackup --manifest-path=pathCommand-line ToolsPG18pg_verifybackup › Optionsm path--manifest-path=path Use the manifest file at the specified path, rather than one located in the root of the backup directory. pg_verifybackup --no-parse-walCommand-line ToolsPG18pg_verifybackup › Optionsn--no-parse-wal Don't attempt to parse write-ahead log data that will be needed to recover from this backup. pg_verifybackup --progressCommand-line ToolsPG18pg_verifybackup › OptionsP--progress Enable progress reporting. Turning this on will deliver a progress report while verifying checksums. This option cannot be used together with the option --quiet. pg_verifybackup --quietCommand-line ToolsPG18pg_verifybackup › Optionsq--quiet Don't print anything when a backup is successfully verified. pg_verifybackup --skip-checksumsCommand-line ToolsPG18pg_verifybackup › Optionss--skip-checksums Do not verify data file checksums. The presence or absence of files and the sizes of those files will still be checked. This is much faster, because the files themselves do… pg_verifybackup --versionCommand-line ToolsPG18pg_verifybackup › OptionsV--version Print the pg_verifybackup version and exit. pg_verifybackup --wal-directory=pathCommand-line ToolsPG18pg_verifybackup › Optionsw path--wal-directory=path Try to parse WAL files stored in the specified directory, rather than in pg_wal. This may be useful if the backup is stored in a separate location from the WAL arc… pg_viewctlExtensionsExtensionsAdministration · ExtensionsView dependency management and safe schema evolution utilities pgrx pg_viewctl Administration pg_viewsManual ChaptersPG18The view pg_views provides access to useful information about each view in the database. Table 53.37. pg_views Columns Column Type Description schemaname name (references pg_namespace.nspnam… pg_visibilityExtensionsPG18pg_visibility — visibility map information and utilitiesvisibility map information and utilities The pg_visibility module provides a means for examining the visibility map (VM) and page-level visibility information of a table. It also provides fu… pg_visibility — visibility map information and utilitiesManual ChaptersPG18The pg_visibility module provides a means for examining the visibility map (VM) and page-level visibility information of a table. It also provides functions to check the integrity of a visib… pg_visibilitymapExtensionsExtensionsAdministration · ExtensionsInspect relation visibility-map bits on historical PostgreSQL releases. administration diagnostics visibility-map pg_visibilitymap Administration pg_volvecExtensionsExtensionsAnalytics · ExtensionsExperimental vectorized execution of selected PostgreSQL OLAP plans. pg_volvec Analytics pg_vxExtensionsExtensionsFeatures · ExtensionsPostgreSQL extension testing vectorization and CustomScanAPI interface postgresql postgresql-customscanapi vectorization pg_vx Features pg_wait_eventsManual ChaptersPG18The view pg_wait_events provides description about the wait events. Table 53.38. pg_wait_events Columns Column Type Description type text Wait event type name text Wait event name descriptio… pg_wait_samplingExtensionsExtensionsMonitoring · Extensionssampling based statistics of wait events pg_wait_sampling Monitoring pg_wal_budgetExtensionsExtensionsAdministration · ExtensionsPostgreSQL extension that observes and enforces WAL generation against configurable budgets by policy scope. pgrx postgresql postgresql-extension rust wal pg_wal_budget Administration pg_wal_extExtensionsExtensionsReplication and streams · ExtensionsRead WAL files and possibly generate the SQL postgres postgresql-extension wal write-ahead-log pg_wal_ext Replication and streams pg_wal_recoveryExtensionsExtensionsAdministration · Extensionspg recovery is an educational PostgreSQL extension for database recovery recovery wal write-ahead-log pg_wal_recovery Administration pg_waldumpManual ChaptersPG18display a human-readable rendering of the write-ahead log of a PostgreSQL database cluster Synopsis pg_waldump [option...] [startseg [endseg]] pg_walinspectExtensionsPG18pg_walinspect — low-level WAL inspectionlow-level WAL inspection The pg_walinspect module provides SQL functions that allow you to inspect the contents of write-ahead log of a running PostgreSQL database cluster at a low level, wh… pg_walinspect — low-level WAL inspectionManual ChaptersPG18The pg_walinspect module provides SQL functions that allow you to inspect the contents of write-ahead log of a running PostgreSQL database cluster at a low level, which is useful for debuggi… pg_walrusExtensionsExtensionsAdministration · ExtensionsAutomatic max_wal_size tuning based on checkpoint activity pgrx pg_walrus Administration pg_walsummaryManual ChaptersPG18print contents of WAL summary files Synopsis pg_walsummary [option...] [file...] pg_walsummary --helpCommand-line ToolsPG18pg_walsummary › Options?--help Shows help about pg_walsummary command line arguments, and exits. pg_walsummary --individualCommand-line ToolsPG18pg_walsummary › Optionsi--individual By default, pg_walsummary prints one line of output for each range of one or more consecutive modified blocks. This can make the output a lot briefer, since a relation where al… pg_walsummary --quietCommand-line ToolsPG18pg_walsummary › Optionsq--quiet Do not print any output, except for errors. This can be useful when you want to know whether a WAL summary file can be successfully parsed but don't care about the contents. pg_walsummary --versionCommand-line ToolsPG18pg_walsummary › OptionsV--version Display version information, then exit.