Specifies the TCP port or regional Unix domain socket file extension on which the server is listening for connections. Defaults towards the PGPORT ecosystem variable, if established, or possibly a compiled-in default.
even so, pg_dump will waste a connection attempt discovering out which the server wants a password. sometimes it really is worth typing -W to avoid the additional link try.
the choice archive file formats needs to be employed with pg_restore to rebuild the databases. they permit pg_restore to become selective about what's restored, as well as to reorder the goods previous to being restored. The archive file formats are intended to be moveable across architectures.
With zstd compression, long manner may perhaps Enhance the compression ratio, at the cost of greater memory use.
this selection is to be used by in-put update utilities. Its use for other applications will not be proposed or supported. The behavior of the choice might change in foreseeable future releases without notice.
get started the output by using a command to generate the databases itself and reconnect on the produced database. (using a script of this type, it does not matter which databases within the spot set up you hook up with ahead of running the script.
tend not to hold out forever to amass shared table locks at first with the dump. alternatively fail if not able to lock a table in the required timeout
To carry out a parallel dump, the databases server has to help synchronized snapshots, a characteristic that was launched in PostgreSQL 9.2 for Key servers and 10 for standbys. using this type of feature, databases purchasers can assure they see the same knowledge established Though they use distinctive connections.
. The pattern is interpreted based on the same principles as for -t. -T can be given greater than when to exclude tables matching any of numerous patterns.
Force quoting of all identifiers. this feature is usually recommended when dumping a databases from a server whose PostgreSQL main Variation differs from pg_dump's, or when the output is meant to get loaded into a server of a distinct significant version.
tables at the same time. this selection may perhaps decrease the time required to accomplish the dump but In addition it raises the load over the database server.
. The timeout might be specified in any of your formats accepted by established statement_timeout. (authorized formats differ dependant upon the server Variation you will be dumping from, but an integer variety of milliseconds is accepted by all versions.)
+ 1 connections for the databases, so be sure your max_connections setting is significant adequate to accommodate all connections.
To restore from such a script, feed it to psql. Script information can be utilized to reconstruct the databases even on other devices along with other architectures; with a few modifications, even on other SQL database merchandise.
This option is not really advantageous for any dump which is intended just for disaster Restoration. It could be valuable for any dump utilized to load a duplicate from the databases for reporting or other examine-only load sharing when the first database proceeds for being up to date.
make use of a serializable transaction for that dump, to make certain that the snapshot made use of is consistent with afterwards database states; but try this by awaiting a point in the transaction stream at which no anomalies could be current, to ensure that there isn't สล็อตทดลอง a possibility on the dump failing or causing other transactions to roll again which has a serialization_failure. See Chapter 13 for more information about transaction isolation and concurrency Regulate.