Specifies the TCP port or regional Unix area socket file extension on which the server is listening for connections. Defaults on the PGPORT setting variable, if set, or a compiled-in default.
However, pg_dump will waste a link endeavor getting out which the server needs a password. occasionally it truly is truly worth typing -W to stay away from the extra connection try.
The alternative archive file formats needs to be used with pg_restore to rebuild the databases. They allow pg_restore to generally be selective about precisely what is restored, and even to reorder the things ahead of becoming restored. The archive file formats are created to be moveable throughout architectures.
It won't dump the contents of sights or materialized sights, plus the contents of overseas tables will only be dumped In case the corresponding foreign server is specified with --include things like-foreign-information.
This option is for use by in-put up grade utilities. Its use for other functions is just not proposed or supported. The conduct of the choice might adjust in long term releases unexpectedly.
Dump data as INSERT commands (in lieu of duplicate). This could make restoration very gradual; it is principally beneficial for producing dumps that can be loaded into non-PostgreSQL databases. Any mistake during restoring will induce only rows which can be A part of the problematic INSERT to generally be lost, as an alternative to your entire table contents.
If no compression amount is specified, the default compression stage might be utilized. If merely a degree is specified with out mentioning an algorithm, gzip compression will likely be applied if the level is larger than 0, and no compression are going to be utilised if the extent is 0.
Specifies the title from the databases to be dumped. If this is not specified, the environment variable PGDATABASE is utilized. If that's not established, the user title specified for your link สล็อตเว็บตรง is utilised.
. The pattern is interpreted according to the very same principles as for -t. -T can be given much more than the moment to exclude tables matching any of quite a few patterns.
by no means situation a password prompt. In case the server calls for password authentication as well as a password isn't obtainable by other usually means for instance a .pgpass file, the link endeavor will are unsuccessful. this feature could be beneficial in batch Positions and scripts the place no person is current to enter a password.
ship output to the specified file. This parameter might be omitted for file dependent output formats, through which situation the common output is used.
usually do not output commands to pick table entry solutions. With this selection, all objects will probably be designed with whichever desk accessibility method would be the default in the course of restore.
Do not output commands to set TOAST compression approaches. With this option, all columns might be restored With all the default compression placing.
; this selects each the schema alone, and all its contained objects. When this selection is not specified, all non-program schemas in the goal database might be dumped. a number of schemas might be picked by crafting multiple -n switches. The pattern
this feature is not really useful for the dump which is meant only for catastrophe recovery. It could be practical for the dump accustomed to load a duplicate of your database for reporting or other read-only load sharing even though the first database proceeds for being updated.
this selection is never necessary, due to the fact pg_dump will routinely prompt for a password In the event the server requires password authentication.