Specifies the บาคาร่าเว็บตรง TCP port or regional Unix area socket file extension on which the server is listening for connections. Defaults into the PGPORT atmosphere variable, if set, or even a compiled-in default.
parameter is interpreted to be a sample based on the similar policies utilized by psql's \d instructions (see designs), so a number of international servers may also be chosen by writing wildcard figures within the sample.
develop DATABASE foo WITH TEMPLATE template0; When a knowledge-only dump is selected and the choice --disable-triggers is utilised, pg_dump emits commands to disable triggers on person tables in advance of inserting the data, and then commands to re-enable them after the details has become inserted. If the restore is stopped in the middle, the technique catalogs could possibly be left in the wrong state.
parameter is interpreted to be a pattern in accordance with the very same regulations utilized by psql's \d instructions (see Patterns), so multiple extensions can be selected by writing wildcard characters in the sample.
When dumping logical replication subscriptions, pg_dump will create CREATE SUBSCRIPTION instructions that utilize the join = Bogus alternative, in order that restoring the membership won't make distant connections for making a replication slot or for First desk duplicate. this way, the dump can be restored without having requiring community use of the remote servers. it truly is then up towards the person to reactivate the subscriptions in an appropriate way.
Output SQL-regular SET SESSION AUTHORIZATION commands as an alternative to change proprietor instructions to ascertain object ownership. This makes the dump much more expectations-appropriate, but dependant upon the historical past of your objects inside the dump, may not restore effectively.
This option is helpful when needing to synchronize the dump with a logical replication slot (see Chapter 49) or that has a concurrent session.
. The sample is interpreted based on the same principles as for -t. --exclude-table-info may be provided greater than once to exclude tables matching any of several styles. This option is beneficial any time you will need the definition of a selected table Although you do not need the info in it.
If the thing is something during the documentation that is not suitable, doesn't match your practical experience with the particular characteristic or calls for more clarification, please use this manner to report a documentation problem.
in no way problem a password prompt. In the event the server requires password authentication in addition to a password is not out there by other usually means for instance a .pgpass file, the link try will fail. this selection can be practical in batch Careers and scripts exactly where no person is current to enter a password.
ship output to the desired file. This parameter is often omitted for file centered output formats, where situation the normal output is used.
. The timeout may be specified in any with the formats approved by established statement_timeout. (authorized formats range dependant upon the server Variation you are dumping from, but an integer number of milliseconds is approved by all versions.)
It needs to be provided with the directory output format even so, wherever it specifies the focus on directory in lieu of a file. In cases like this the directory is produced by pg_dump and must not exist just before.
Use this In case you have referential integrity checks or other triggers over the tables that you don't want to invoke during knowledge restore.
Some installations have a policy from logging in specifically being a superuser, and usage of this option makes it possible for dumps for being built without violating the policy.
pg_dump -j takes advantage of various database connections; it connects into the databases when with the chief approach and Yet again for each worker job. with no synchronized snapshot attribute, the various worker Employment would not be sure to see the identical data in Every single relationship, which could lead to an inconsistent backup.