Considerations To Know About สล็อต pg
Considerations To Know About สล็อต pg
Blog Article
Specifies a role identify for use to produce the dump. This option causes pg_dump to challenge a established function rolename
parameter is interpreted to be a pattern in accordance with the very same principles utilized by psql's \d instructions (see designs), so multiple overseas servers can even be chosen by composing wildcard figures while in the sample.
build DATABASE foo WITH TEMPLATE template0; whenever a info-only dump is decided on and the option --disable-triggers is utilised, pg_dump emits instructions to disable triggers on person tables right before inserting the information, then commands to re-permit them once the facts has long been inserted. If your restore is stopped in the center, the method catalogs may be left in the incorrect state.
Specifies the host title with the equipment on which the server is operating. If the value commences by using a slash, it's utilised given that the Listing for the Unix area socket. The default is taken through the PGHOST atmosphere variable, if established, else a Unix area socket link is attempted.
This option disables using greenback quoting for purpose bodies, and forces them for being quoted utilizing SQL typical string syntax.
Dump facts as INSERT instructions (rather than COPY). Controls the most range of rows for each INSERT command. the worth specified need to be a selection bigger than zero. Any error in the course of restoring will bring about only rows which have been part of the problematic INSERT for being misplaced, in lieu of all the desk contents.
This option is beneficial when needing to synchronize the dump by using a logical replication slot (see Chapter forty nine) or with a concurrent session.
To carry out a parallel dump, the databases server must help synchronized snapshots, a characteristic which was introduced in PostgreSQL nine.two for Main servers and ten for standbys. With this attribute, database clients can make certain they see precisely the same info set Despite the fact that they use distinct connections.
. The sample is interpreted based on the exact same procedures as for -t. -T might be supplied a lot more than at the time to exclude tables matching any of quite a few designs.
power quoting of all identifiers. This option is suggested when dumping a database from the server whose PostgreSQL significant version is different from pg_dump's, or in the event the output is meant to be loaded right into a server of a special key Variation.
This can be valuable when restoring information over a server where rows will not generally fall into the exact same partitions as they did on the initial server. which could happen, such as, if the partitioning column is of sort text and The 2 systems have diverse definitions from the collation accustomed to form the partitioning column.
This is similar to the -t/--table choice, other than that In addition it contains any partitions or inheritance child tables with the table(s) matching the sample
When making use of wildcards, be cautious to quote the sample if desired to avoid the shell from expanding the wildcards; see illustrations down below.
Specify the compression technique and/or perhaps the compression degree to make use of. The compression technique is usually established to gzip, lz4, zstd, or none for no compression. A compression element string can optionally be specified.
For the customized and directory archive formats, this specifies compression of person desk-data segments, plus the default should be to compress using gzip in a moderate level. For basic text output, setting a nonzero compression stage leads to สล็อตเว็บตรง the entire output file to generally be compressed, as though it were fed by way of gzip, lz4, or zstd; although the default is to not compress.
this selection is rarely important, since pg_dump will quickly prompt for the password Should the server demands password authentication.
Report this page