Search PostgreSQL documentation

pg_dump --use-set-session-authorizationCommand-line ToolsPG18--use-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-compa…pg_dump › Options pg_dump --username=usernameCommand-line ToolsPG18-U username--username=username User name to connect as.pg_dump › Options pg_dump --verboseCommand-line ToolsPG18-v--verbose Specifies verbose mode. This will cause pg_dump to output detailed object comments and start/stop times to the dump file, and progress messages to standard error. Repeating the o…pg_dump › Options pg_dump --versionCommand-line ToolsPG18-V--version Print the pg_dump version and exit.pg_dump › Options pg_dumpallCommand-line ToolsPG18pg_dumpall pg_dumpall — extract a PostgreSQL database cluster into a script file Synopsis pg_dumpall [connection-option...] [option...]pg_dumpall pg_dumpall --attribute-insertsCommand-line ToolsPG18--column-inserts--attribute-inserts Dump data as INSERT commands with explicit column names (INSERT INTO table (column, ...) VALUES ...). This will make restoration very slow; it is mainly u…pg_dumpall › Options pg_dumpall --binary-upgradeCommand-line ToolsPG18--binary-upgrade This option is for use by in-place upgrade utilities. Its use for other purposes is not recommended or supported. The behavior of the option may change in future releases wi…pg_dumpall › Options pg_dumpall --cleanCommand-line ToolsPG18-c--clean Emit SQL commands to DROP all the dumped databases, roles, and tablespaces before recreating them. This option is useful when the restore is to overwrite an existing cluster. If an…pg_dumpall › Options pg_dumpall --data-onlyCommand-line ToolsPG18-a--data-only Dump only the data, not the schema (data definitions) or statistics.pg_dumpall › Options pg_dumpall --database=dbnameCommand-line ToolsPG18-l dbname--database=dbname Specifies the name of the database to connect to for dumping global objects and discovering what other databases should be dumped. If not specified, the postgres d…pg_dumpall › Options pg_dumpall --dbname=connstrCommand-line ToolsPG18-d connstr--dbname=connstr Specifies parameters used to connect to the server, as a connection string; these will override any conflicting command line options. The option is called --dbname…pg_dumpall › Options pg_dumpall --disable-dollar-quotingCommand-line ToolsPG18--disable-dollar-quoting This option disables the use of dollar quoting for function bodies, and forces them to be quoted using SQL standard string syntax.pg_dumpall › Options pg_dumpall --disable-triggersCommand-line ToolsPG18--disable-triggers This option is relevant only when creating a dump with data and without schema. It instructs pg_dumpall to include commands to temporarily disable triggers on the target t…pg_dumpall › Options pg_dumpall --encoding=encodingCommand-line ToolsPG18-E encoding--encoding=encoding Create the dump in the specified character set encoding. By default, the dump is created in the database encoding. (Another way to get the same result is to se…pg_dumpall › Options pg_dumpall --exclude-database=patternCommand-line ToolsPG18--exclude-database=pattern Do not dump databases whose name matches pattern. Multiple patterns can be excluded by writing multiple --exclude-database switches. The pattern parameter is inter…pg_dumpall › Options pg_dumpall --extra-float-digits=ndigitsCommand-line ToolsPG18--extra-float-digits=ndigits Use the specified value of extra_float_digits when dumping floating-point data, instead of the maximum available precision. Routine dumps made for backup purpose…pg_dumpall › Options pg_dumpall --file=filenameCommand-line ToolsPG18-f filename--file=filename Send output to the specified file. If this is omitted, the standard output is used.pg_dumpall › Options pg_dumpall --filter=filenameCommand-line ToolsPG18--filter=filename Specify a filename from which to read patterns for databases excluded from the dump. The patterns are interpreted according to the same rules as --exclude-database. To read…pg_dumpall › Options pg_dumpall --globals-onlyCommand-line ToolsPG18-g--globals-only Dump only global objects (roles and tablespaces), no databases.pg_dumpall › Options pg_dumpall --helpCommand-line ToolsPG18-?--help Show help about pg_dumpall command line arguments, and exit.pg_dumpall › Options pg_dumpall --host=hostCommand-line ToolsPG18-h host--host=host Specifies the host name of the machine on which the database server is running. If the value begins with a slash, it is used as the directory for the Unix domain socket. T…pg_dumpall › Options pg_dumpall --if-existsCommand-line ToolsPG18--if-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…pg_dumpall › Options pg_dumpall --insertsCommand-line ToolsPG18--inserts Dump data as INSERT commands (rather than COPY). This will make restoration very slow; it is mainly useful for making dumps that can be loaded into non-PostgreSQL databases. Note t…pg_dumpall › Options pg_dumpall --load-via-partition-rootCommand-line ToolsPG18--load-via-partition-root When dumping data for a table partition, make the COPY or INSERT statements target the root of the partitioning hierarchy that contains it, rather than the partitio…pg_dumpall › Options pg_dumpall --lock-wait-timeout=timeoutCommand-line ToolsPG18--lock-wait-timeout=timeout Do not wait forever to acquire shared table locks at the beginning of the dump. Instead, fail if unable to lock a table within the specified timeout. The timeout …pg_dumpall › Options pg_dumpall --no-aclCommand-line ToolsPG18-x--no-privileges--no-acl Prevent dumping of access privileges (grant/revoke commands).pg_dumpall › Options pg_dumpall --no-commentsCommand-line ToolsPG18--no-comments Do not dump COMMENT commands.pg_dumpall › Options pg_dumpall --no-dataCommand-line ToolsPG18--no-data Do not dump data.pg_dumpall › Options pg_dumpall --no-ownerCommand-line ToolsPG18-O--no-owner Do not output commands to set ownership of objects to match the original database. By default, pg_dumpall issues ALTER OWNER or SET SESSION AUTHORIZATION statements to set owner…pg_dumpall › Options pg_dumpall --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_dumpall › Options pg_dumpall --no-policiesCommand-line ToolsPG18--no-policies Do not dump row security policies.pg_dumpall › Options pg_dumpall --no-publicationsCommand-line ToolsPG18--no-publications Do not dump publications.pg_dumpall › Options pg_dumpall --no-role-passwordsCommand-line ToolsPG18--no-role-passwords Do not dump passwords for roles. When restored, roles will have a null password, and password authentication will always fail until the password is set. Since password va…pg_dumpall › Options pg_dumpall --no-schemaCommand-line ToolsPG18--no-schema Do not dump schema (data definitions).pg_dumpall › Options pg_dumpall --no-security-labelsCommand-line ToolsPG18--no-security-labels Do not dump security labels.pg_dumpall › Options pg_dumpall --no-statisticsCommand-line ToolsPG18--no-statistics Do not dump statistics. This is the default.pg_dumpall › Options pg_dumpall --no-subscriptionsCommand-line ToolsPG18--no-subscriptions Do not dump subscriptions.pg_dumpall › Options pg_dumpall --no-syncCommand-line ToolsPG18--no-sync By default, pg_dumpall will wait for all files to be written safely to disk. This option causes pg_dumpall to return without waiting, which is faster, but means that a subsequent o…pg_dumpall › Options pg_dumpall --no-table-access-methodCommand-line ToolsPG18--no-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_dumpall › Options pg_dumpall --no-tablespacesCommand-line ToolsPG18--no-tablespaces Do not output commands to create tablespaces nor select tablespaces for objects. With this option, all objects will be created in whichever tablespace is the default during …pg_dumpall › Options