Search PostgreSQL documentation

pg_dumpall --globals-onlyCommand-line ToolsPG18pg_dumpall › Optionsg--globals-only Dump only global objects (roles and tablespaces), no databases. pg_dumpall --helpCommand-line ToolsPG18pg_dumpall › Options?--help Show help about pg_dumpall command line arguments, and exit. pg_dumpall --host=hostCommand-line ToolsPG18pg_dumpall › Optionsh 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. Th… pg_dumpall --if-existsCommand-line ToolsPG18pg_dumpall › 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_dumpall --insertsCommand-line ToolsPG18pg_dumpall › Optionsinserts 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 tha… pg_dumpall --load-via-partition-rootCommand-line ToolsPG18pg_dumpall › Optionsload-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 partition … pg_dumpall --lock-wait-timeout=timeoutCommand-line ToolsPG18pg_dumpall › Optionslock-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 ma… pg_dumpall --no-aclCommand-line ToolsPG18pg_dumpall › Optionsx--no-privileges--no-acl Prevent dumping of access privileges (grant/revoke commands). pg_dumpall --no-commentsCommand-line ToolsPG18pg_dumpall › Optionsno-comments Do not dump COMMENT commands. pg_dumpall --no-dataCommand-line ToolsPG18pg_dumpall › Optionsno-data Do not dump data. pg_dumpall --no-ownerCommand-line ToolsPG18pg_dumpall › OptionsO--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 owners… pg_dumpall --no-passwordCommand-line ToolsPG18pg_dumpall › 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_dumpall --no-policiesCommand-line ToolsPG18pg_dumpall › Optionsno-policies Do not dump row security policies. pg_dumpall --no-publicationsCommand-line ToolsPG18pg_dumpall › Optionsno-publications Do not dump publications. pg_dumpall --no-role-passwordsCommand-line ToolsPG18pg_dumpall › Optionsno-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 valu… pg_dumpall --no-schemaCommand-line ToolsPG18pg_dumpall › Optionsno-schema Do not dump schema (data definitions). pg_dumpall --no-security-labelsCommand-line ToolsPG18pg_dumpall › Optionsno-security-labels Do not dump security labels. pg_dumpall --no-statisticsCommand-line ToolsPG18pg_dumpall › Optionsno-statistics Do not dump statistics. This is the default. pg_dumpall --no-subscriptionsCommand-line ToolsPG18pg_dumpall › Optionsno-subscriptions Do not dump subscriptions. pg_dumpall --no-syncCommand-line ToolsPG18pg_dumpall › Optionsno-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 ope… pg_dumpall --no-table-access-methodCommand-line ToolsPG18pg_dumpall › 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_dumpall --no-tablespacesCommand-line ToolsPG18pg_dumpall › Optionsno-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 re… pg_dumpall --no-toast-compressionCommand-line ToolsPG18pg_dumpall › Optionsno-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 --no-unlogged-table-dataCommand-line ToolsPG18pg_dumpall › Optionsno-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 tabl… pg_dumpall --on-conflict-do-nothingCommand-line ToolsPG18pg_dumpall › Optionson-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 --passwordCommand-line ToolsPG18pg_dumpall › OptionsW--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 server… pg_dumpall --port=portCommand-line ToolsPG18pg_dumpall › 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_dumpall --quote-all-identifiersCommand-line ToolsPG18pg_dumpall › Optionsquote-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 whe… pg_dumpall --restrict-key=restrict_keyCommand-line ToolsPG18pg_dumpall › Optionsrestrict-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 con… pg_dumpall --role=rolenameCommand-line ToolsPG18pg_dumpall › Optionsrole=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 the … pg_dumpall --roles-onlyCommand-line ToolsPG18pg_dumpall › Optionsr--roles-only Dump only roles, no databases or tablespaces. pg_dumpall --rows-per-insert=nrowsCommand-line ToolsPG18pg_dumpall › Optionsrows-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 err… pg_dumpall --schema-onlyCommand-line ToolsPG18pg_dumpall › Optionss--schema-only Dump only the object definitions (schema), not data. pg_dumpall --sequence-dataCommand-line ToolsPG18pg_dumpall › Optionssequence-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 --statisticsCommand-line ToolsPG18pg_dumpall › Optionsstatistics Dump optimizer statistics. pg_dumpall --statistics-onlyCommand-line ToolsPG18pg_dumpall › Optionsstatistics-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 --superuser=usernameCommand-line ToolsPG18pg_dumpall › OptionsS 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, a… pg_dumpall --tablespaces-onlyCommand-line ToolsPG18pg_dumpall › Optionst--tablespaces-only Dump only tablespaces, no databases or roles. pg_dumpall --use-set-session-authorizationCommand-line ToolsPG18pg_dumpall › 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_dumpall --username=usernameCommand-line ToolsPG18pg_dumpall › OptionsU username--username=username User name to connect as.