Search PostgreSQL documentation

pg_basebackup --verboseCommand-line ToolsPG18pg_basebackup › Optionsv--verbose Enables verbose mode. Will output some extra steps during startup and shutdown, as well as show the exact file name that is currently being processed if progress reporting is also… pg_basebackup --versionCommand-line ToolsPG18pg_basebackup › OptionsV--version Prints the pg_basebackup version and exits. pg_basebackup --wal-method=methodCommand-line ToolsPG18pg_basebackup › OptionsX method--wal-method=method Includes the required WAL (write-ahead log) files in the backup. This will include all write-ahead logs generated during the backup. Unless the method none is spe… pg_basebackup --waldir=waldirCommand-line ToolsPG18pg_basebackup › Optionswaldir=waldir Sets the directory to write WAL (write-ahead log) files to. By default WAL files will be placed in the pg_wal subdirectory of the target directory, but this option can be used … pg_basebackup --write-recovery-confCommand-line ToolsPG18pg_basebackup › OptionsR--write-recovery-conf Creates a standby.signal file and appends connection settings to the postgresql.auto.conf file in the target directory (or within the base archive file when using tar … pg_bech32ExtensionsExtensionsUtilities · ExtensionsAdds Bech32, Bech32m, and no-checksum Bech32 encoding/decoding support to PostgreSQL. pgrx pg_bech32 Utilities pg_bedtools_rsExtensionsExtensionsFunctions and aggregates · ExtensionsA PostgreSQL plugin for bedtools, implemented in Rust. bedtools genomics pgrx pg_bedtools_rs Functions and aggregates pg_bertExtensionsExtensionsFull-text search · ExtensionsBERT tokenizer implemented as a PostgreSQL full-text-search parser. pg_bert Full-text search pg_bestmatchExtensionsExtensionsFull-text search · ExtensionsGenerate BM25 sparse vector inside PostgreSQL pgrx pg_bestmatch Full-text search pg_bigmExtensionsExtensionsFull-text search · Extensionscreate 2-gram (bigram) index for faster full text search. pg_bigm Full-text search pg_bigmrExtensionsExtensionsFull-text search · Extensionstext similarity measurement and index searching based on bigrams full-text-search indexing pgrx pg_bigmr Full-text search pg_bikram_sambatExtensionsExtensionsData types · ExtensionsBikram Sambat date type and AD/BS conversion functions pg_bikram_sambat Data types pg_biscuitExtensionsExtensionsFull-text search · ExtensionsA fast bitmap-based index for PostgreSQL bitmap deterministic indexing like matching pattern search wildcard pg_biscuit Full-text search pg_bitcoin_addressExtensionsExtensionsData types · ExtensionsBitcoin address types plus Base58Check and Bech32/Bech32m codecs. bitcoin base58 bech32 address pg_bitcoin_address Data types pg_bitcountExtensionsExtensionsFunctions and aggregates · ExtensionsBit-count scalar and aggregate functions for integers and bit strings. bitcount bitmap aggregate integer pg_bitcount Functions and aggregates pg_bleveExtensionsExtensionsFull-text search · ExtensionsPostgreSQL extension for Bleve search integration bleve full-text-search index pg_bleve Full-text search pg_blkchainExtensionsExtensionsFunctions and aggregates · ExtensionsC extension providing Bitcoin blockchain parsing and helper functions for PostgreSQL. pg_blkchain Functions and aggregates pg_block_if_slowExtensionsExtensionsAdministration · ExtensionsAbort queries that are taking too long based on EXPLAIN estimates. pg_block_if_slow Administration pg_block_systemcatalogExtensionsExtensionsSecurity · ExtensionsPostgreSQL extension to block references to system catalogs. access-control catalog security pg_block_systemcatalog Security pg_bloomExtensionsExtensionsData types · ExtensionsPrototype 64-bit single-item Bloom-like data type and membership operator pg_bloom Data types pg_bm25ExtensionsExtensionsFull-text search · ExtensionsFull text search for PostgreSQL using BM25 bm25 full-text-search pgrx tantivy pg_bm25 Full-text search pg_bmanExtensionsExtensionsAdministration · ExtensionsPostgreSQL hot-backup tooling with remote full/incremental backup and archive-log helpers. pg_bman Administration pg_bofhExtensionsExtensionsAdministration · ExtensionsRejects queries without WHERE clauses using a planner hook loaded via shared_preload_libraries. hook planner preload pg_bofh Administration pg_branchExtensionsExtensionsFeatures · ExtensionsPostgreSQL extension for quickly creating copies of databases and clusters. btrfs database-branching pgrx snapshot pg_branch Features pg_buffercacheExtensionsPG18pg_buffercache — inspect PostgreSQL buffer cache stateinspect PostgreSQL buffer cache state The pg_buffercache module provides a means for examining what's happening in the shared buffer cache in real time. It also offers a low-level way to evi… pg_buffercache — inspect PostgreSQL buffer cache stateManual ChaptersPG18The pg_buffercache module provides a means for examining what's happening in the shared buffer cache in real time. It also offers a low-level way to evict data from it, for testing purposes.… pg_bulkloadExtensionsExtensionsReplication and streams · Extensionsis a high speed data loading utility for PostgreSQL pg_bulkload Replication and streams pg_cache_treeExtensionsExtensionsFeatures · ExtensionsCaches recursive parent and child IDs in array columns using trigger and helper functions. cache hierarchy tree trigger pg_cache_tree Features pg_calcpiExtensionsExtensionsFunctions and aggregates · ExtensionsComputes digits of pi in PostgreSQL with a PL/pgSQL spigot algorithm. math plpgsql pg_calcpi Functions and aggregates pg_cardanoExtensionsExtensionsFeatures · ExtensionsA suite of Cardano-related tools pgrx pg_cardano Features pg_castManual ChaptersPG18The catalog pg_cast stores data type conversion paths, both built-in and user-defined. It should be noted that pg_cast does not represent every type conversion that the system knows how to p… pg_catalog_get_defsExtensionsExtensionsAdministration · ExtensionsAdds PL/pgSQL functions that reconstruct CREATE TYPE definitions from pg_catalog metadata. catalog ddl introspection pg_catalog_get_defs Administration pg_catcheckExtensionsExtensionsAdministration · ExtensionsDiagnosing system catalog corruption pg_catcheck Administration pg_celExtensionsExtensionsSecurity · ExtensionsA pure PostgreSQL implementation of the Google Zanzibar / OpenFGA authorization model. pg_cel Security pg_cextExtensionsExtensionsFunctions and aggregates · ExtensionsA PostgreSQL extension to add two numbers addition c custom extension gsoc postgresql postgresql-extension tutorial pg_cext Functions and aggregates pg_cgroupExtensionsExtensionsAdministration · ExtensionsProvides SQL-callable functions to create, configure, and attach processes to Linux cgroups. cgroup resource-control shared-preload pg_cgroup Administration pg_chainsyncExtensionsExtensionsReplication and streams · ExtensionsAccess blockchain blocks, events, and tasks directly inside PostgreSQL using background workers. background-worker blockchain pgrx pg_chainsync Replication and streams pg_chainutilsExtensionsExtensionsData types · ExtensionsBlockchain utility types and functions for PostgreSQL, built with pgrx. pgrx pg_chainutils Data types pg_change_point_detectionExtensionsExtensionsTime series · ExtensionsA Postgres extension to detect change points in time series data pg_change_point_detection Time series pg_chaos_shuffleExtensionsExtensionsFeatures · ExtensionsChaos-testing hook that randomizes SELECT results lacking ORDER BY. chaos ordering testing executor-hook pg_chaos_shuffle Features