Specifies the TCP port or community Unix area socket file extension on which the server is listening for connections. Defaults towards the PGPORT setting variable, if established, or possibly a compiled-in default.
nevertheless, pg_dump will squander a connection attempt discovering out which the server wishes a password. in some instances it is actually worthy of typing -W to stay away from the further relationship attempt.
this feature could make no distinction if there isn't any read through-compose transactions Lively when pg_dump is commenced. If examine-create transactions are Lively, the start on the dump can be delayed for an indeterminate length of time. at the time managing, effectiveness with or with no switch is identical.
Specifies the host title from the machine on which the server is managing. If the worth starts by using a slash, it can be used as the directory for the Unix domain socket. The default is taken from the PGHOST surroundings variable, if established, else a Unix domain socket link is tried.
This option disables the usage of greenback quoting for operate bodies, and forces them being quoted using SQL standard string syntax.
Dump knowledge as INSERT instructions (as an alternative to COPY). This will make restoration really slow; it is principally handy for building dumps which might be loaded into non-PostgreSQL databases. Any error for the duration of restoring will lead to only rows that are part of the problematic INSERT to become misplaced, as an alternative to the complete table contents.
When making use of wildcards, be mindful to estimate the pattern if wanted to forestall the shell from growing the wildcards; see Examples down below. The only exception is usually that an empty sample is disallowed.
Specifies the name of the database for บาคาร่าเว็บตรง being dumped. If it's not specified, the environment variable PGDATABASE is utilised. If that is not set, the consumer identify specified to the link is utilised.
If the thing is just about anything in the documentation that is not suitable, doesn't match your working experience with The actual function or requires even more clarification, please use this kind to report a documentation challenge.
never ever challenge a password prompt. If your server calls for password authentication and also a password just isn't obtainable by other signifies such as a .pgpass file, the relationship try will fail. This option can be practical in batch Work opportunities and scripts in which no person is existing to enter a password.
mail output to the specified file. This parameter could be omitted for file based mostly output formats, in which scenario the normal output is made use of.
tend not to output instructions to choose table access procedures. With this selection, all objects are going to be produced with whichever table entry strategy is definitely the default for the duration of restore.
Also, It's not at all guaranteed that pg_dump's output might be loaded into a server of an older key Edition — not although the dump was taken from the server of that Edition. Loading a dump file into an more mature server may require manual editing with the dump file to remove syntax not comprehended because of the more mature server. Use with the --quote-all-identifiers solution is recommended in cross-Variation conditions, as it could prevent challenges arising from different reserved-phrase lists in different PostgreSQL variations.
To restore from this kind of script, feed it to psql. Script information can be employed to reconstruct the databases even on other devices and also other architectures; with some modifications, even on other SQL database solutions.
Use DROP ... IF EXISTS commands to fall objects in --cleanse manner. This suppresses “does not exist” mistakes that might usually be noted. this selection isn't legitimate unless --clear is usually specified.
When using wildcards, be mindful to quotation the pattern if necessary to prevent the shell from increasing the wildcards.