parameter is interpreted for a sample according to the exact principles employed by psql's \d commands (see styles), so numerous tables can even be selected by writing wildcard characters from the pattern.
In the situation of a parallel dump, the snapshot identify described by this feature is utilized rather then getting a new snapshot.
Output a personalized-format archive ideal for input into pg_restore. along with the directory output structure, this is considered the most adaptable output structure in that it lets manual range and reordering of archived products in the course of restore. This structure is usually compressed by default.
probably the most adaptable output file formats are classified as the “personalized” structure (-Fc) and also the “directory” format (-Fd). they permit for variety and reordering of all archived things, guidance parallel restoration, and are compressed by default. The “directory” format is the sole structure that supports parallel dumps.
this feature disables using greenback quoting for function bodies, and forces them to become quoted utilizing SQL regular string syntax.
Begin the output that has a command to create the database itself and reconnect on the made database. (that has a script of this way, it doesn't issue which databases inside the spot installation you connect to right before functioning the script.
. The sample is interpreted based on the exact principles as for -n. -N is usually provided in excess of when to exclude schemas matching any of various styles.
Specifies the title from the database to generally be dumped. If this is simply not specified, the atmosphere variable PGDATABASE is applied. If that is not set, the person title specified for your link is utilised.
If the thing is just about anything in the documentation that is not appropriate, does not match your knowledge with The actual attribute or necessitates even further clarification, please use this kind to report a documentation difficulty.
in no way issue a password prompt. In the event the server demands password authentication and a password is not available by other implies such as a .pgpass file, the relationship try will are unsuccessful. this selection may be valuable in batch Employment and scripts the place no user is existing to enter a password.
tables concurrently. this feature may well lessen the time needed to complete the dump but What's more, it enhances the load about the databases server.
This can be the same as the -t/--table solution, other than that it also involves any partitions or inheritance child tables with the table(s) matching the pattern
+ one connections for the databases, so be sure your max_connections setting is large plenty of to support all connections.
Use this In case you have referential integrity checks or other triggers to the tables that you don't would like to invoke in the course of details restore.
This option is just not beneficial for any dump which is meant just for disaster Restoration. It could be beneficial for your dump used to load a duplicate in เว็บตรงไม่ผ่านเอเย่นต์ the databases for reporting or other read-only load sharing though the initial databases carries on to be current.
When applying wildcards, be careful to estimate the sample if necessary to avoid the shell from expanding the wildcards; see illustrations underneath.