Search PostgreSQL documentation

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 pg_dumpall --no-toast-compressionCommand-line ToolsPG18--no-toast-compression Do not output commands to set TOAST compression methods. With this option, all columns will be restored with the default compression setting.pg_dumpall › Options pg_dumpall --no-unlogged-table-dataCommand-line ToolsPG18--no-unlogged-table-data Do not dump the contents of unlogged tables. This option has no effect on whether or not the table definitions (schema) are dumped; it only suppresses dumping the ta…pg_dumpall › Options pg_dumpall --on-conflict-do-nothingCommand-line ToolsPG18--on-conflict-do-nothing Add ON CONFLICT DO NOTHING to INSERT commands. This option is not valid unless --inserts or --column-inserts is also specified.pg_dumpall › Options pg_dumpall --passwordCommand-line ToolsPG18-W--password Force pg_dumpall to prompt for a password before connecting to a database. This option is never essential, since pg_dumpall will automatically prompt for a password if the serve…pg_dumpall › Options pg_dumpall --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_dumpall › Options pg_dumpall --quote-all-identifiersCommand-line ToolsPG18--quote-all-identifiers Force quoting of all identifiers. This option is recommended when dumping a database from a server whose PostgreSQL major version is different from pg_dumpall's, or w…pg_dumpall › Options pg_dumpall --restrict-key=restrict_keyCommand-line ToolsPG18--restrict-key=restrict_key Use the provided string as the psql \restrict key in the dump output. If no restrict key is specified, pg_dumpall will generate a random one as needed. Keys may c…pg_dumpall › Options pg_dumpall --role=rolenameCommand-line ToolsPG18--role=rolename Specifies a role name to be used to create the dump. This option causes pg_dumpall to issue a SET ROLE rolename command after connecting to the database. It is useful when th…pg_dumpall › Options pg_dumpall --roles-onlyCommand-line ToolsPG18-r--roles-only Dump only roles, no databases or tablespaces.pg_dumpall › Options pg_dumpall --rows-per-insert=nrowsCommand-line ToolsPG18--rows-per-insert=nrows Dump data as INSERT commands (rather than COPY). Controls the maximum number of rows per INSERT command. The value specified must be a number greater than zero. Any e…pg_dumpall › Options pg_dumpall --schema-onlyCommand-line ToolsPG18-s--schema-only Dump only the object definitions (schema), not data.pg_dumpall › Options pg_dumpall --sequence-dataCommand-line ToolsPG18--sequence-data Include sequence data in the dump. This is the default behavior except when --no-data, --schema-only, or --statistics-only is specified.pg_dumpall › Options pg_dumpall --statisticsCommand-line ToolsPG18--statistics Dump optimizer statistics.pg_dumpall › Options pg_dumpall --statistics-onlyCommand-line ToolsPG18--statistics-only Dump only the statistics, not the schema (data definitions) or data. Optimizer statistics for tables, materialized views, foreign tables, and indexes are dumped.pg_dumpall › Options pg_dumpall --superuser=usernameCommand-line ToolsPG18-S username--superuser=username Specify the superuser user name to use when disabling triggers. This is relevant only if --disable-triggers is used. (Usually, it's better to leave this out, …pg_dumpall › Options pg_dumpall --tablespaces-onlyCommand-line ToolsPG18-t--tablespaces-only Dump only tablespaces, no databases or roles.pg_dumpall › Options pg_dumpall --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_dumpall › Options pg_dumpall --username=usernameCommand-line ToolsPG18-U username--username=username User name to connect as.pg_dumpall › Options pg_dumpall --verboseCommand-line ToolsPG18-v--verbose Specifies verbose mode. This will cause pg_dumpall to output start/stop times to the dump file, and progress messages to standard error. Repeating the option causes additional de…pg_dumpall › Options