parameter is interpreted like a pattern according to the similar rules used by psql's \d commands (see styles), so numerous tables may also be chosen by creating wildcard people within the sample.
In the case of the parallel dump, the snapshot title outlined by this option is utilised rather then taking a completely new snapshot.
build databases foo WITH TEMPLATE template0; any time a details-only dump is preferred and the choice --disable-triggers is utilized, pg_dump emits commands to disable triggers on user tables just before inserting the info, then instructions to re-enable them after the information has become inserted. When the restore is stopped in the middle, the procedure catalogs could be still left in the wrong state.
Specifies the host name of the equipment on which the server is operating. If the worth commences that has a slash, it is actually utilised because the directory to the Unix domain socket. The default is taken from your PGHOST atmosphere variable, if established, else a Unix domain socket relationship is tried.
this feature is for use by in-area up grade utilities. Its use for other uses just isn't recommended or supported. The actions of the option might alter in long term releases all at once.
Dump information as INSERT instructions (instead of duplicate). This is likely to make restoration incredibly gradual; it is mainly practical for generating dumps which might be loaded into non-PostgreSQL databases. Any mistake through restoring will lead to only rows that happen to be Section of the problematic INSERT to be shed, instead of the complete desk contents.
this selection is helpful when needing to synchronize the dump by using a logical replication slot (see Chapter forty nine) or with a concurrent session.
Output instructions to fall many of the dumped databases objects before outputting the instructions for building them. this feature is useful when the restore should be to overwrite an present database.
If the thing is something inside the documentation that is not appropriate, isn't going to match your experience with the particular สล็อตออนไลน์ element or demands even further clarification, you should use this way to report a documentation difficulty.
develop the dump in the required character set encoding. By default, the dump is made within the databases encoding. (Another way to find the exact result is to established the PGCLIENTENCODING surroundings variable to the desired dump encoding.) The supported encodings are explained in area 24.3.one.
, ...) VALUES ...). This could make restoration extremely sluggish; it is principally practical for earning dumps that can be loaded into non-PostgreSQL databases. Any error for the duration of restoring will result in only rows which can be A part of the problematic INSERT to become misplaced, as opposed to the whole table contents.
This is similar to the -t/--table possibility, other than that it also features any partitions or inheritance baby tables on the table(s) matching the pattern
In case the user doesn't have enough privileges to bypass row stability, then an mistake is thrown. This parameter instructs pg_dump to established row_security to on in its place, allowing for the user to dump the portions of the contents of the desk that they may have entry to.
Specify the compression system and/or maybe the compression stage to employ. The compression system could be set to gzip, lz4, zstd, or none for no compression. A compression depth string can optionally be specified.
Use DROP ... IF EXISTS instructions to drop objects in --clear method. This suppresses “doesn't exist” mistakes That may or else be noted. this selection isn't legitimate Except --thoroughly clean is usually specified.
this selection is suitable only when dumping the contents of a desk which has row safety. By default, pg_dump will set row_security to off, in order that all facts is dumped in the table.