develop the dump in the required character established encoding. By default, the dump is made during the databases encoding. (Another way to find the exact same result's to set the PGCLIENTENCODING surroundings variable to the desired dump website encoding.) The supported encodings are explained in area 24.3.1.
In the case of a parallel dump, the snapshot identify defined by this feature is employed as an alternative to taking a different snapshot.
this feature is rarely necessary, because pg_dump will mechanically prompt for just a password if the server calls for password authentication.
on the other hand, pg_dump will waste a connection attempt obtaining out the server wants a password. sometimes it is truly worth typing -W to avoid the additional connection attempt.
Specifies the host title in the device on which the server is running. If the worth begins that has a slash, it truly is applied since the directory to the Unix area socket. The default is taken from the PGHOST setting variable, if set, else a Unix domain socket connection is attempted.
When dumping reasonable replication subscriptions, pg_dump will deliver build SUBSCRIPTION instructions that use the hook up = Fake selection, to ensure that restoring the subscription isn't going to make distant connections for making a replication slot or for First table duplicate. this way, the dump can be restored with out demanding network usage of the remote servers. it truly is then up towards the user to reactivate the subscriptions in an acceptable way.
It won't dump the contents of views or materialized views, as well as the contents of international tables will only be dumped if the corresponding overseas server is specified with --include-overseas-facts.
usually do not output commands to select desk obtain solutions. With this selection, all objects will likely be produced with whichever desk access process is the default for the duration of restore.
this selection is to be used by in-area enhance utilities. Its use for other uses just isn't encouraged or supported. The habits of the option may perhaps adjust in upcoming releases suddenly.
with the custom made and directory archive formats, this specifies compression of person table-info segments, as well as the default is always to compress applying gzip at a moderate level. For simple textual content output, setting a nonzero compression degree causes the whole output file to get compressed, as if it were fed through gzip, lz4, or zstd; even so the default is never to compress.
don't dump the contents of unlogged tables and sequences. this feature has no impact on whether or not the desk and sequence definitions (schema) are dumped; it only suppresses dumping the desk and sequence info. details in unlogged tables and sequences is often excluded when dumping from a standby server.
This can be useful when restoring facts on a server wherever rows don't often drop in to the identical partitions because they did on the first server. which could materialize, by way of example, if the partitioning column is of kind textual content and The 2 programs have diverse definitions in the collation accustomed to type the partitioning column.
Output a custom-structure archive ideal for enter into pg_restore. Together with the Listing output structure, this is easily the most versatile output format in that it permits manual collection and reordering of archived items all through restore. This format is likewise compressed by default.
this selection will make no distinction if there won't be any go through-compose transactions active when pg_dump is begun. If browse-create transactions are Lively, the start of the dump may very well be delayed for an indeterminate amount of time. Once working, effectiveness with or without the switch is the same.
Force quoting of all identifiers. this feature is recommended when dumping a database from a server whose PostgreSQL significant Edition differs from pg_dump's, or in the event the output is intended to become loaded into a server of another main Edition.
When using wildcards, watch out to quotation the sample if needed to prevent the shell from expanding the wildcards.