Search PostgreSQL documentation

pg_receivewal --no-passwordCommand-line ToolsPG18-w--no-password Never issue a password prompt. If the server requires password authentication and a password is not available by other means such as a .pgpass file, the connection attempt wi…pg_receivewal › Options pg_receivewal --no-syncCommand-line ToolsPG18--no-sync This option causes pg_receivewal to not force WAL data to be flushed to disk. This is faster, but means that a subsequent operating system crash can leave the WAL segments corrupt.…pg_receivewal › Options pg_receivewal --passwordCommand-line ToolsPG18-W--password Force pg_receivewal to prompt for a password before connecting to a database. This option is never essential, since pg_receivewal will automatically prompt for a password if the…pg_receivewal › Options pg_receivewal --port=portCommand-line ToolsPG18-p 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_receivewal › Options pg_receivewal --slot=slotnameCommand-line ToolsPG18-S slotname--slot=slotname Require pg_receivewal to use an existing replication slot (see Section 26.2.6). When this option is used, pg_receivewal will report a flush position to the server,…pg_receivewal › Options pg_receivewal --status-interval=intervalCommand-line ToolsPG18-s interval--status-interval=interval Specifies the number of seconds between status packets sent back to the server. This allows for easier monitoring of the progress from server. A value o…pg_receivewal › Options pg_receivewal --synchronousCommand-line ToolsPG18--synchronous Flush the WAL data to disk immediately after it has been received. Also send a status packet back to the server immediately after flushing, regardless of --status-interval. Thi…pg_receivewal › Options pg_receivewal --username=usernameCommand-line ToolsPG18-U username--username=username User name to connect as.pg_receivewal › Options pg_receivewal --verboseCommand-line ToolsPG18-v--verbose Enables verbose mode.pg_receivewal › Options pg_receivewal --versionCommand-line ToolsPG18-V--version Print the pg_receivewal version and exit.pg_receivewal › Options pg_recvlogicalCommand-line ToolsPG18pg_recvlogical pg_recvlogical — control PostgreSQL logical decoding streams Synopsis pg_recvlogical [option...]pg_recvlogical pg_recvlogical --create-slotCommand-line ToolsPG18--create-slot Create a new logical replication slot with the name specified by --slot, using the output plugin specified by --plugin, for the database specified by --dbname. The --slot and -…pg_recvlogical › Options pg_recvlogical --dbname=dbnameCommand-line ToolsPG18-d dbname--dbname=dbname The database to connect to. See the description of the actions for what this means in detail. The dbname can be a connection string. If so, connection string paramet…pg_recvlogical › Options pg_recvlogical --drop-slotCommand-line ToolsPG18--drop-slot Drop the replication slot with the name specified by --slot, then exit. The --slot is required for this action.pg_recvlogical › Options pg_recvlogical --enable-failoverCommand-line ToolsPG18--enable-failover Enables the slot to be synchronized to the standbys. This option may only be specified with --create-slot.pg_recvlogical › Options pg_recvlogical --endpos=lsnCommand-line ToolsPG18-E lsn--endpos=lsn In --start mode, automatically stop replication and exit with normal exit status 0 when receiving reaches the specified LSN. If specified when not in --start mode, an erro…pg_recvlogical › Options pg_recvlogical --file=filenameCommand-line ToolsPG18-f filename--file=filename Write received and decoded transaction data into this file. Use - for stdout. This parameter is required for --start.pg_recvlogical › Options pg_recvlogical --fsync-interval=interval_secondsCommand-line ToolsPG18-F interval_seconds--fsync-interval=interval_seconds Specifies how often pg_recvlogical should issue fsync() calls to ensure the output file is safely flushed to disk. The server will occasi…pg_recvlogical › Options pg_recvlogical --helpCommand-line ToolsPG18-?--help Show help about pg_recvlogical command line arguments, and exit.pg_recvlogical › Options pg_recvlogical --host=hostname-or-ipCommand-line ToolsPG18-h hostname-or-ip--host=hostname-or-ip Specifies the host name of the machine on which the server is running. If the value begins with a slash, it is used as the directory for the Unix domai…pg_recvlogical › Options pg_recvlogical --if-not-existsCommand-line ToolsPG18--if-not-exists Do not error out when --create-slot is specified and a slot with the specified name already exists.pg_recvlogical › Options pg_recvlogical --no-loopCommand-line ToolsPG18-n--no-loop When the connection to the server is lost, do not retry in a loop, just exit.pg_recvlogical › Options pg_recvlogical --no-passwordCommand-line ToolsPG18-w--no-password Never issue a password prompt. If the server requires password authentication and a password is not available by other means such as a .pgpass file, the connection attempt wi…pg_recvlogical › Options pg_recvlogical --option=name[=value]Command-line ToolsPG18-o name[=value]--option=name[=value] Pass the option name to the output plugin with, if specified, the option value value. Which options exist and their effects depends on the used output pl…pg_recvlogical › Options pg_recvlogical --passwordCommand-line ToolsPG18-W--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 t…pg_recvlogical › Options pg_recvlogical --plugin=pluginCommand-line ToolsPG18-P 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 › Options pg_recvlogical --port=portCommand-line ToolsPG18-p 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 › Options pg_recvlogical --slot=slot_nameCommand-line ToolsPG18-S 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 th…pg_recvlogical › Options pg_recvlogical --startCommand-line ToolsPG18--start 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 o…pg_recvlogical › Options pg_recvlogical --startpos=lsnCommand-line ToolsPG18-I 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 › Options pg_recvlogical --status-interval=interval_secondsCommand-line ToolsPG18-s 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 › Options pg_recvlogical --two-phaseCommand-line ToolsPG18-t--enable-two-phase--two-phase (deprecated) Enables decoding of prepared transactions. This option may only be specified with --create-slot.pg_recvlogical › Options pg_recvlogical --username=userCommand-line ToolsPG18-U user--username=user User name to connect as. Defaults to current operating system user name.pg_recvlogical › Options pg_recvlogical --verboseCommand-line ToolsPG18-v--verbose Enables verbose mode.pg_recvlogical › Options pg_recvlogical --versionCommand-line ToolsPG18-V--version Print the pg_recvlogical version and exit.pg_recvlogical › Options pg_resetwalCommand-line ToolsPG18pg_resetwal pg_resetwal — reset the write-ahead log and other control information of a PostgreSQL database cluster Synopsis pg_resetwal [ -f | --force ] [ -n | --dry-run ] [option...] [ -D |…pg_resetwal pg_resetwal --char-signedness=optionCommand-line ToolsPG18--char-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 1…pg_resetwal › Options pg_resetwal --commit-timestamp-ids=xid,xidCommand-line ToolsPG18-c 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 t…pg_resetwal › Options pg_resetwal --dry-runCommand-line ToolsPG18-n--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 …pg_resetwal › Options pg_resetwal --epoch=xid_epochCommand-line ToolsPG18-e 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_res…pg_resetwal › Options