Search PostgreSQL documentation

pg_restore --passwordCommand-line ToolsPG18pg_restore › OptionsW--password Force pg_restore to prompt for a password before connecting to a database. This option is never essential, since pg_restore will automatically prompt for a password if the server… pg_restore --port=portCommand-line ToolsPG18pg_restore › 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_restore --restrict-key=restrict_keyCommand-line ToolsPG18pg_restore › Optionsrestrict-key=restrict_key Use the provided string as the psql \restrict key in the dump output. This can only be specified for SQL script output, i.e., when the --file option is used. If no … pg_restore --role=rolenameCommand-line ToolsPG18pg_restore › Optionsrole=rolename Specifies a role name to be used to perform the restore. This option causes pg_restore to issue a SET ROLE rolename command after connecting to the database. It is useful when … pg_restore --schema-onlyCommand-line ToolsPG18pg_restore › Optionss--schema-only Restore only the schema (data definitions), not data, to the extent that schema entries are present in the archive. This option cannot be used with --data-only or --statistics… pg_restore --schema=schemaCommand-line ToolsPG18pg_restore › Optionsn schema--schema=schema Restore only objects that are in the named schema. Multiple schemas may be specified with multiple -n switches. This can be combined with the -t option to restore jus… pg_restore --section=sectionnameCommand-line ToolsPG18pg_restore › Optionssection=sectionname Only restore the named section. The section name can be pre-data, data, or post-data. This option can be specified more than once to select multiple sections. The default… pg_restore --single-transactionCommand-line ToolsPG18pg_restore › Options1--single-transaction Execute the restore as a single transaction (that is, wrap the emitted commands in BEGIN/COMMIT). This ensures that either all the commands complete successfully, or no… pg_restore --statisticsCommand-line ToolsPG18pg_restore › Optionsstatistics Output commands to restore statistics, if the archive contains them. This is the default. pg_restore --statistics-onlyCommand-line ToolsPG18pg_restore › Optionsstatistics-only Restore only the statistics, not schema (data definitions) or data. pg_restore --strict-namesCommand-line ToolsPG18pg_restore › Optionsstrict-names Require that each schema (-n/--schema) and table (-t/--table) qualifier match at least one schema/table in the file to be restored. pg_restore --superuser=usernameCommand-line ToolsPG18pg_restore › OptionsS username--superuser=username Specify the superuser user name to use when disabling triggers. This is relevant only if --disable-triggers is used. pg_restore --table=tableCommand-line ToolsPG18pg_restore › Optionst table--table=table Restore definition and/or data of only the named table. For this purpose, “table” includes views, materialized views, sequences, and foreign tables. Multiple tables can … pg_restore --transaction-size=NCommand-line ToolsPG18pg_restore › Optionstransaction-size=N Execute the restore as a series of transactions, each processing up to N database objects. This option implies --exit-on-error. --transaction-size offers an intermediate c… pg_restore --trigger=triggerCommand-line ToolsPG18pg_restore › OptionsT trigger--trigger=trigger Restore named trigger only. Multiple triggers may be specified with multiple -T switches. pg_restore --use-list=list-fileCommand-line ToolsPG18pg_restore › OptionsL list-file--use-list=list-file Restore only those archive elements that are listed in list-file, and restore them in the order they appear in the file. Note that if filtering switches such … pg_restore --use-set-session-authorizationCommand-line ToolsPG18pg_restore › Optionsuse-set-session-authorization Output SQL-standard SET SESSION AUTHORIZATION commands instead of ALTER OWNER commands to determine object ownership. This makes the dump more standards-compati… pg_restore --username=usernameCommand-line ToolsPG18pg_restore › OptionsU username--username=username User name to connect as. pg_restore --verboseCommand-line ToolsPG18pg_restore › Optionsv--verbose Specifies verbose mode. This will cause pg_restore to output detailed object comments and start/stop times to the output file, and progress messages to standard error. Repeating t… pg_restore --versionCommand-line ToolsPG18pg_restore › OptionsV--version Print the pg_restore version and exit. pg_restore_pointsExtensionsExtensionsAdministration · ExtensionsCreate, catalog, list, and remove named PostgreSQL restore points. restore-point wal backup recovery pg_restore_points Administration pg_retryExtensionsExtensionsUtilities · ExtensionsRetry SQL statements on transient errors with exponential backoff pg_retry Utilities pg_reversiExtensionsExtensionsFeatures · ExtensionsReversi game implemented as a PostgreSQL extension. game reversi pg_reversi Features pg_rewindCommand-line ToolsPG18synchronize a PostgreSQL data directory with another data directory that was forked from it Synopsis pg_rewind [option...] { -D | --target-pgdata } directory { --source-pgdata=directory | --… pg_rewindManual ChaptersPG18synchronize a PostgreSQL data directory with another data directory that was forked from it Synopsis pg_rewind [option...] { -D | --target-pgdata } directory { --source-pgdata=directory | --… pg_rewind --config-file=filenameCommand-line ToolsPG18pg_rewind › Optionsconfig-file=filename Use the specified main server configuration file for the target cluster. This affects pg_rewind when it uses internally the postgres command for the rewind operation on … pg_rewind --debugCommand-line ToolsPG18pg_rewind › Optionsdebug Print verbose debugging output that is mostly useful for developers debugging pg_rewind. pg_rewind --dry-runCommand-line ToolsPG18pg_rewind › Optionsn--dry-run Do everything except actually modifying the target directory. pg_rewind --helpCommand-line ToolsPG18pg_rewind › Options?--help Show help, then exit. pg_rewind --no-ensure-shutdownCommand-line ToolsPG18pg_rewind › Optionsno-ensure-shutdown pg_rewind requires that the target server is cleanly shut down before rewinding. By default, if the target server is not shut down cleanly, pg_rewind starts the target ser… pg_rewind --no-syncCommand-line ToolsPG18pg_rewind › OptionsN--no-sync By default, pg_rewind will wait for all files to be written safely to disk. This option causes pg_rewind to return without waiting, which is faster, but means that a subsequent op… pg_rewind --progressCommand-line ToolsPG18pg_rewind › OptionsP--progress Enables progress reporting. Turning this on will deliver an approximate progress report while copying data from the source cluster. pg_rewind --restore-target-walCommand-line ToolsPG18pg_rewind › Optionsc--restore-target-wal Use restore_command defined in the target cluster configuration to retrieve WAL files from the WAL archive if these files are no longer available in the pg_wal director… pg_rewind --source-pgdata=directoryCommand-line ToolsPG18pg_rewind › Optionssource-pgdata=directory Specifies the file system path to the data directory of the source server to synchronize the target with. This option requires the source server to be cleanly shut do… pg_rewind --source-server=connstrCommand-line ToolsPG18pg_rewind › Optionssource-server=connstr Specifies a libpq connection string to connect to the source PostgreSQL server to synchronize the target with. The connection must be a normal (non-replication) connect… pg_rewind --sync-method=methodCommand-line ToolsPG18pg_rewind › Optionssync-method=method When set to fsync, which is the default, pg_rewind will recursively open and synchronize all files in the data directory. The search for files will follow symbolic links f… pg_rewind --target-pgdata=directoryCommand-line ToolsPG18pg_rewind › OptionsD directory--target-pgdata=directory This option specifies the target data directory that is synchronized with the source. The target server must be shut down cleanly before running pg_rewin… pg_rewind --versionCommand-line ToolsPG18pg_rewind › OptionsV--version Display version information, then exit. pg_rewind --write-recovery-confCommand-line ToolsPG18pg_rewind › OptionsR--write-recovery-conf Create standby.signal and append connection settings to postgresql.auto.conf in the output directory. The dbname will be recorded only if the dbname was specified expl… pg_rewriteManual ChaptersPG18The catalog pg_rewrite stores rewrite rules for tables and views. Table 52.45. pg_rewrite Columns Column Type Description oid oid Row identifier rulename name Rule name ev_class oid (referen…