Search PostgreSQL documentation

pg_resetwal --oldest-transaction-id=xidCommand-line ToolsPG18pg_resetwal › Optionsu xid--oldest-transaction-id=xid Manually set the oldest unfrozen transaction ID. A safe value can be determined by looking for the numerically smallest file name in the directory pg_xact un… pg_resetwal --pgdata=datadirCommand-line ToolsPG18pg_resetwal › Optionsdatadir-D datadir--pgdata=datadir Specifies the location of the database directory. For safety reasons, you must specify the data directory on the command line. pg_resetwal does not use the … pg_resetwal --versionCommand-line ToolsPG18pg_resetwal › OptionsV--version Display version information, then exit. pg_resetwal --wal-segsize=wal_segment_sizeCommand-line ToolsPG18pg_resetwal › Optionswal-segsize=wal_segment_size Set the new WAL segment size, in megabytes. The value must be set to a power of 2 between 1 and 1024 (megabytes). See the same option of initdb for more informat… pg_resetxlog renamed to pg_resetwalManual ChaptersPG18PostgreSQL 9.6 and below provided a command named pg_resetxlog to reset the write-ahead-log (WAL) files. This command was renamed to pg_resetwal, see pg_resetwal for documentation of pg_rese… pg_restoreCommand-line ToolsPG18restore a PostgreSQL database from an archive file created by pg_dump Synopsis pg_restore [connection-option...] [option...] [filename] pg_restoreManual ChaptersPG18restore a PostgreSQL database from an archive file created by pg_dump Synopsis pg_restore [connection-option...] [option...] [filename] pg_restore --cleanCommand-line ToolsPG18pg_restore › Optionsc--clean Before restoring database objects, issue commands to DROP all the objects that will be restored. This option is useful for overwriting an existing database. If any of the objects do… pg_restore --createCommand-line ToolsPG18pg_restore › OptionsC--create Create the database before restoring into it. If --clean is also specified, drop and recreate the target database before connecting to it. With --create, pg_restore also restores t… pg_restore --data-onlyCommand-line ToolsPG18pg_restore › Optionsa--data-only Restore only the data, not the schema (data definitions) or statistics. Table data, large objects, and sequence values are restored, if present in the archive. This option is si… pg_restore --dbname=dbnameCommand-line ToolsPG18pg_restore › Optionsd dbname--dbname=dbname Connect to database dbname and restore directly into the database. The dbname can be a connection string. If so, connection string parameters will override any confli… pg_restore --disable-triggersCommand-line ToolsPG18pg_restore › Optionsdisable-triggers This option is relevant only when performing a restore without schema. It instructs pg_restore to execute commands to temporarily disable triggers on the target tables while… pg_restore --enable-row-securityCommand-line ToolsPG18pg_restore › Optionsenable-row-security This option is relevant only when restoring the contents of a table which has row security. By default, pg_restore will set row_security to off, to ensure that all data i… pg_restore --exclude-schema=schemaCommand-line ToolsPG18pg_restore › OptionsN schema--exclude-schema=schema Do not restore objects that are in the named schema. Multiple schemas to be excluded may be specified with multiple -N switches. When both -n and -N are given… pg_restore --exit-on-errorCommand-line ToolsPG18pg_restore › Optionse--exit-on-error Exit if an error is encountered while sending SQL commands to the database. The default is to continue and to display a count of errors at the end of the restoration. pg_restore --file=filenameCommand-line ToolsPG18pg_restore › Optionsf filename--file=filename Specify output file for generated script, or for the listing when used with -l. Use - for stdout. pg_restore --filter=filenameCommand-line ToolsPG18pg_restore › Optionsfilter=filename Specify a filename from which to read patterns for objects excluded or included from restore. The patterns are interpreted according to the same rules as -n/--schema for incl… pg_restore --format=formatCommand-line ToolsPG18pg_restore › OptionsF format--format=format Specify format of the archive. It is not necessary to specify the format, since pg_restore will determine the format automatically. If specified, it can be one of the… pg_restore --function=function-name(argtype [, ...])Command-line ToolsPG18pg_restore › OptionsP function-name(argtype [, ...])--function=function-name(argtype [, ...]) Restore the named function only. Be careful to spell the function name and arguments exactly as they appear in the d… pg_restore --helpCommand-line ToolsPG18pg_restore › Options?--help Show help about pg_restore command line arguments, and exit. pg_restore --host=hostCommand-line ToolsPG18pg_restore › Optionsh host--host=host 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 domain socket. The default… pg_restore --if-existsCommand-line ToolsPG18pg_restore › Optionsif-exists Use DROP ... IF EXISTS commands to drop objects in --clean mode. This suppresses “does not exist” errors that might otherwise be reported. This option is not valid unless --clean i… pg_restore --index=indexCommand-line ToolsPG18pg_restore › OptionsI index--index=index Restore definition of named index only. Multiple indexes may be specified with multiple -I switches. pg_restore --jobs=number-of-jobsCommand-line ToolsPG18pg_restore › Optionsj number-of-jobs--jobs=number-of-jobs Run the most time-consuming steps of pg_restore — those that load data, create indexes, or create constraints — concurrently, using up to number-of-jobs… pg_restore --listCommand-line ToolsPG18pg_restore › Optionsl--list List the table of contents of the archive. The output of this operation can be used as input to the -L option. Note that if filtering switches such as -n or -t are used with -l, they… pg_restore --no-aclCommand-line ToolsPG18pg_restore › Optionsx--no-privileges--no-acl Prevent restoration of access privileges (grant/revoke commands). pg_restore --no-commentsCommand-line ToolsPG18pg_restore › Optionsno-comments Do not output commands to restore comments, even if the archive contains them. pg_restore --no-dataCommand-line ToolsPG18pg_restore › Optionsno-data Do not output commands to restore data, even if the archive contains them. pg_restore --no-data-for-failed-tablesCommand-line ToolsPG18pg_restore › Optionsno-data-for-failed-tables By default, table data is restored even if the creation command for the table failed (e.g., because it already exists). With this option, data for such a table is s… pg_restore --no-ownerCommand-line ToolsPG18pg_restore › OptionsO--no-owner Do not output commands to set ownership of objects to match the original database. By default, pg_restore issues ALTER OWNER or SET SESSION AUTHORIZATION statements to set owners… pg_restore --no-passwordCommand-line ToolsPG18pg_restore › Optionsw--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 wil… pg_restore --no-policiesCommand-line ToolsPG18pg_restore › Optionsno-policies Do not output commands to restore row security policies, even if the archive contains them. pg_restore --no-publicationsCommand-line ToolsPG18pg_restore › Optionsno-publications Do not output commands to restore publications, even if the archive contains them. pg_restore --no-reconnectCommand-line ToolsPG18pg_restore › OptionsR--no-reconnect This option is obsolete but still accepted for backwards compatibility. pg_restore --no-schemaCommand-line ToolsPG18pg_restore › Optionsno-schema Do not output commands to restore schema (data definitions), even if the archive contains them. pg_restore --no-security-labelsCommand-line ToolsPG18pg_restore › Optionsno-security-labels Do not output commands to restore security labels, even if the archive contains them. pg_restore --no-statisticsCommand-line ToolsPG18pg_restore › Optionsno-statistics Do not output commands to restore statistics, even if the archive contains them. pg_restore --no-subscriptionsCommand-line ToolsPG18pg_restore › Optionsno-subscriptions Do not output commands to restore subscriptions, even if the archive contains them. pg_restore --no-table-access-methodCommand-line ToolsPG18pg_restore › Optionsno-table-access-method Do not output commands to select table access methods. With this option, all objects will be created with whichever table access method is the default during restore. pg_restore --no-tablespacesCommand-line ToolsPG18pg_restore › Optionsno-tablespaces Do not output commands to select tablespaces. With this option, all objects will be created in whichever tablespace is the default during restore.