Specifies the TCP port or area Unix domain socket file extension on which the server is listening for connections. Defaults into the PGPORT ecosystem variable, if established, or simply a compiled-in default.
parameter is interpreted like a sample in accordance with the similar guidelines used by psql's \d commands (see styles), so several international servers can also be picked by creating wildcard people in the sample.
the choice archive file formats needs to be utilized with pg_restore to rebuild the databases. they permit pg_restore to get selective about what on earth is restored, or perhaps to reorder the items before becoming restored. The archive file formats are meant to be portable throughout architectures.
With zstd compression, extended mode may possibly Increase the compression ratio, at the cost of greater memory use.
Be aware that if you use this selection at the moment, you almost certainly also want the dump be in INSERT structure, because the COPY FROM through restore doesn't assist row safety.
Dump data as INSERT commands (in lieu of duplicate). This is likely to make restoration really slow; it is especially handy for producing dumps which can be loaded into non-PostgreSQL databases. Any error in the course of restoring will lead to only rows which might be A part of the problematic INSERT to be misplaced, rather than the whole table contents.
usually do not wait around forever to amass shared desk locks firstly of your dump. rather are unsuccessful if unable to lock a desk inside of the desired timeout
To accomplish a parallel dump, the database server ought to assistance synchronized snapshots, a aspect that was launched in PostgreSQL nine.two for Principal servers and 10 for standbys. using this attribute, database shoppers can make certain they see precisely the same knowledge established even though they use different connections.
If you see something within the documentation that is not proper, would not match your practical experience with the particular function or calls for further more clarification, be sure to use this form to report a documentation difficulty.
in no way challenge a password prompt. In the event the server calls for password authentication along with a password is just not accessible by other suggests for instance a .pgpass file, the link try will are unsuccessful. this feature can be helpful in batch Positions and scripts in which no person is current to enter a password.
Requesting exceptional locks on database objects when jogging a parallel dump could lead to the dump to fail. The explanation is that the pg_dump chief process requests shared locks (entry SHARE) around the objects which the worker procedures are going to dump afterwards as a way to be sure that nobody deletes them and makes them go away when the dump is operating. If A different client then requests an exceptional lock over a desk, that lock will not be granted but are going to be queued waiting for the shared lock of the chief approach being launched.
tend not to output commands to pick out desk obtain approaches. With this selection, all objects might be produced with whichever desk access strategy will be the default for the duration of restore.
don't output commands to established TOAST compression procedures. With this feature, all columns is going to be restored Along with the default compression setting.
Specify the compression technique and/or the compression level to employ. The compression technique can be established to gzip, lz4, zstd, or none for no compression. A compression detail string can optionally be specified.
Some installations have a coverage against logging in immediately as a superuser, and utilization of this option makes it possible for dumps to become manufactured without having violating the coverage.
pg_dump -j employs multiple databases connections; it connects to the databases once While using the chief system and Again for each employee career. with no synchronized snapshot attribute, the various worker Careers would not be certain to see the บาคาร่า same details in Just about every connection, which could lead on to an inconsistent backup.