สล็อต pg Options
สล็อต pg Options
Blog Article
Specifies the TCP port or community Unix area socket file extension on which the server is listening for connections. Defaults on the PGPORT setting variable, if established, or simply a compiled-in default.
In the situation of the parallel dump, the snapshot name defined by this option is utilized rather than getting a brand new snapshot.
These statements will fail when the script is run Until it's commenced by a superuser (or a similar user that owns each of the objects while in the script). for making a script that could be restored by any user, but will give that user possession of all of the objects, specify -O.
With zstd compression, extended method could improve the compression ratio, at the expense of enhanced memory use.
this feature disables the use of dollar quoting for purpose bodies, and forces them to become quoted utilizing SQL normal string syntax.
commence the output with a command to develop the databases itself and reconnect for the developed database. (With a script of this kind, it would not make any difference which database inside the destination set up you connect to ahead of functioning the script.
this selection is helpful when needing to synchronize the dump having a reasonable replication slot (see Chapter forty nine) or with a concurrent session.
Specifies the title of the databases สล็อตทดลอง for being dumped. If this is not specified, the ecosystem variable PGDATABASE is applied. If that's not established, the person name specified for your link is made use of.
If you see everything during the documentation that's not appropriate, doesn't match your encounter with the particular function or needs even more clarification, make sure you use this form to report a documentation difficulty.
you may only use this feature Using the directory output structure since This can be the only output structure exactly where several processes can generate their facts simultaneously.
even so, the tar format won't aid compression. Also, when making use of tar format the relative buy of table facts items can not be altered throughout restore.
tend not to output instructions to pick out desk obtain techniques. With this option, all objects will likely be designed with whichever table accessibility system is definitely the default all through restore.
When using wildcards, be mindful to quote the sample if necessary to forestall the shell from growing the wildcards; see illustrations below.
Specify the compression method and/or even the compression level to make use of. The compression method may be set to gzip, lz4, zstd, or none for no compression. A compression detail string can optionally be specified.
for that customized and directory archive formats, this specifies compression of individual table-facts segments, plus the default would be to compress applying gzip at a average amount. For plain textual content output, setting a nonzero compression degree leads to your complete output file for being compressed, as if it were fed by way of gzip, lz4, or zstd; however the default is never to compress.
When utilizing wildcards, be careful to estimate the pattern if essential to stop the shell from growing the wildcards; see Examples under.
Report this page