Search PostgreSQL documentation

pg_recvlogical --passwordCommand-line ToolsPG18pg_recvlogical › OptionsW--password Force pg_recvlogical to prompt for a password before connecting to a database. This option is never essential, since pg_recvlogical will automatically prompt for a password if th… pg_recvlogical --plugin=pluginCommand-line ToolsPG18pg_recvlogical › OptionsP plugin--plugin=plugin When creating a slot, use the specified logical decoding output plugin. See Chapter 47. This option has no effect if the slot already exists. pg_recvlogical --port=portCommand-line ToolsPG18pg_recvlogical › Optionsp port--port=port Specifies the TCP port or local Unix domain socket file extension on which the server is listening for connections. Defaults to the PGPORT environment variable, if set, or … pg_recvlogical --slot=slot_nameCommand-line ToolsPG18pg_recvlogical › OptionsS slot_name--slot=slot_name In --start mode, use the existing logical replication slot named slot_name. In --create-slot mode, create the slot with this name. In --drop-slot mode, delete the… pg_recvlogical --startCommand-line ToolsPG18pg_recvlogical › Optionsstart Begin streaming changes from the logical replication slot specified by --slot, continuing until terminated by a signal. If the server side change stream ends with a server shutdown or … pg_recvlogical --startpos=lsnCommand-line ToolsPG18pg_recvlogical › OptionsI lsn--startpos=lsn In --start mode, start replication from the given LSN. For details on the effect of this, see the documentation in Chapter 47 and Section 54.4. Ignored in other modes. pg_recvlogical --status-interval=interval_secondsCommand-line ToolsPG18pg_recvlogical › Optionss interval_seconds--status-interval=interval_seconds This option has the same effect as the option of the same name in pg_receivewal. See the description there. pg_recvlogical --two-phaseCommand-line ToolsPG18pg_recvlogical › Optionst--enable-two-phase--two-phase (deprecated) Enables decoding of prepared transactions. This option may only be specified with --create-slot. pg_recvlogical --username=userCommand-line ToolsPG18pg_recvlogical › OptionsU user--username=user User name to connect as. Defaults to current operating system user name. pg_recvlogical --verboseCommand-line ToolsPG18pg_recvlogical › Optionsv--verbose Enables verbose mode. pg_recvlogical --versionCommand-line ToolsPG18pg_recvlogical › OptionsV--version Print the pg_recvlogical version and exit. pg_recyclebinExtensionsExtensionsAdministration · ExtensionsIntercepts DROP TABLE and TRUNCATE to retain recoverable table data and metadata in a recycle-bin schema. flashback pgrx recovery pg_recyclebin Administration pg_redispubExtensionsExtensionsReplication and streams · ExtensionsPublish channel messages from PostgreSQL to a local Redis server messaging publish redis pg_redispub Replication and streams pg_registryExtensionsExtensionsFeatures · ExtensionsStores and validates JSON Schemas, generates schemas from tables, and binds schemas to Kafka topics. json-schema pgrx schema-registry pg_registry Features pg_regresqlExtensionsExtensionsProcedural languages · ExtensionsTrust pg_class statistics for planning instead of physical relation size pg_regresql Procedural languages pg_reject_truncateExtensionsExtensionsAdministration · ExtensionsRejects or prevents TRUNCATE operations in PostgreSQL. hook security truncate pg_reject_truncate Administration pg_relation_sqlExtensionsExtensionsUtilities · ExtensionsGenerate inlinable SQL functions for navigating PostgreSQL foreign-key relations foreign-key relations sql-functions code-generation planner inlining ddl pg_relation_sql Utilities pg_relayExtensionsExtensionsFeatures · ExtensionsDurable event processor for PostgreSQL extension go golang listen-notify postgres postgresql postgresql extension relay pg_relay Features pg_relusageExtensionsExtensionsMonitoring · ExtensionsLog all the queries that reference a particular column pg_relusage Monitoring pg_remote_execExtensionsExtensionsAdministration · ExtensionsExecutes shell commands from SQL and optionally returns their standard output. administration shell-execution pg_remote_exec Administration pg_renderExtensionsExtensionsUtilities · ExtensionsRender HTML in SQL pgrx pg_render Utilities pg_repackExtensionsExtensionsAdministration · ExtensionsReorganize tables in PostgreSQL databases with minimal locks pg_repack Administration pg_repeaterExtensionsExtensionsReplication and streams · ExtensionsReplicates utility statements and serialized query plans to a remote PostgreSQL node over postgres_fdw. distributed-query query-plan pg_repeater Replication and streams pg_replicaExtensionsExtensionsAdministration · ExtensionsConsensus-driven automatic failover for PostgreSQL consensus database database-management failover high availability pgrx postgres-extension postgresql raft replication rust streaming replic… pg_replication_originManual ChaptersPG18The pg_replication_origin catalog contains all replication origins created. For more on replication origins see Chapter 48. Unlike most system catalogs, pg_replication_origin is shared acros… pg_replication_origin_statusManual ChaptersPG18The pg_replication_origin_status view contains information about how far replay for a certain origin has progressed. For more on replication origins see Chapter 48. Table 53.19. pg_replicati… pg_replication_slotsManual ChaptersPG18The pg_replication_slots view provides a listing of all replication slots that currently exist on the database cluster, along with their current state. For more on replication slots, see Sec… pg_resetwalCommand-line ToolsPG18reset the write-ahead log and other control information of a PostgreSQL database cluster Synopsis pg_resetwal [ -f | --force ] [ -n | --dry-run ] [option...] [ -D | --pgdata ]datadir pg_resetwalManual ChaptersPG18reset the write-ahead log and other control information of a PostgreSQL database cluster Synopsis pg_resetwal [ -f | --force ] [ -n | --dry-run ] [option...] [ -D | --pgdata ]datadir pg_resetwal --char-signedness=optionCommand-line ToolsPG18pg_resetwal › Optionschar-signedness=option Manually set the default char signedness. Possible values are signed and unsigned. For a database cluster that pg_upgrade upgraded from a PostgreSQL version before 18,… pg_resetwal --commit-timestamp-ids=xid,xidCommand-line ToolsPG18pg_resetwal › Optionsc xid,xid--commit-timestamp-ids=xid,xid Manually set the oldest and newest transaction IDs for which the commit time can be retrieved. A safe value for the oldest transaction ID for which th… pg_resetwal --dry-runCommand-line ToolsPG18pg_resetwal › Optionsn--dry-run The -n/--dry-run option instructs pg_resetwal to print the values reconstructed from pg_control and values about to be changed, and then exit without modifying anything. This is m… pg_resetwal --epoch=xid_epochCommand-line ToolsPG18pg_resetwal › Optionse xid_epoch--epoch=xid_epoch Manually set the next transaction ID's epoch. The transaction ID epoch is not actually stored anywhere in the database except in the field that is set by pg_rese… pg_resetwal --forceCommand-line ToolsPG18pg_resetwal › Optionsf--force Force pg_resetwal to proceed even in situations where it could be dangerous, as explained above. Specifically, this option is required to proceed if the server had not been cleanly … pg_resetwal --helpCommand-line ToolsPG18pg_resetwal › Options?--help Show help, then exit. pg_resetwal --multixact-ids=mxid,mxidCommand-line ToolsPG18pg_resetwal › Optionsm mxid,mxid--multixact-ids=mxid,mxid Manually set the next and oldest multitransaction ID. A safe value for the next multitransaction ID (first part) can be determined by looking for the num… pg_resetwal --multixact-offset=mxoffCommand-line ToolsPG18pg_resetwal › OptionsO mxoff--multixact-offset=mxoff Manually set the next multitransaction offset. A safe value can be determined by looking for the numerically largest file name in the directory pg_multixact/m… pg_resetwal --next-oid=oidCommand-line ToolsPG18pg_resetwal › Optionso oid--next-oid=oid Manually set the next OID. There is no comparably easy way to determine a next OID that's beyond the largest one in the database, but fortunately it is not critical to ge… pg_resetwal --next-transaction-id=xidCommand-line ToolsPG18pg_resetwal › Optionsx xid--next-transaction-id=xid Manually set the next transaction ID. A safe value can be determined by looking for the numerically largest file name in the directory pg_xact under the data d… pg_resetwal --next-wal-file=walfileCommand-line ToolsPG18pg_resetwal › Optionsl walfile--next-wal-file=walfile Manually set the WAL starting location by specifying the name of the next WAL segment file. The name of next WAL segment file should be larger than any WAL s…