Specifies a job identify for use to produce the dump. This option results in pg_dump to challenge a SET function rolename
In the situation of a parallel dump, the snapshot name described by this option is used as opposed to having a brand new snapshot.
CREATE databases foo WITH TEMPLATE template0; every time a details-only dump is decided on and the option --disable-triggers is used, pg_dump emits commands to disable triggers on person tables right before inserting the info, and afterwards instructions to re-enable them following the data has actually been inserted. If your restore is stopped in the middle, the process catalogs may very well be still left in the wrong state.
Specifies the host title of your device on which the server is operating. If the worth commences having a slash, it can be employed because the directory for your Unix area socket. The default is taken from your PGHOST natural environment variable, if established, else a Unix domain socket relationship is attempted.
this feature is for use by in-position improve utilities. Its use for other applications is not really proposed or supported. The conduct of the option may possibly improve in long run releases without warning.
Specifies verbose manner. This will lead to pg_dump to output in-depth object responses and begin/end instances to your dump file, and progress messages to standard error. Repeating the option brings about supplemental debug-stage messages to seem on regular error.
this feature is beneficial when needing to synchronize the dump having a sensible replication slot (see Chapter forty nine) or having a concurrent session.
. The sample is interpreted according to the exact policies as for -t. --exclude-desk-data may be specified over at the time to exclude tables matching any of numerous patterns. This option is helpful whenever you need the definition of a particular desk While you don't need to have the information in it.
If the thing is something from the documentation that's not suitable, doesn't match your practical experience with The actual element or calls for further clarification, be sure to use this form to report a documentation difficulty.
build the สล็อตออนไลน์ dump in the required character set encoding. By default, the dump is developed inside the database encoding. (yet another way to obtain the very same result's to established the PGCLIENTENCODING atmosphere variable to the specified dump encoding.) The supported encodings are described in area 24.3.one.
Requesting special locks on databases objects when operating a parallel dump could cause the dump to fail. The main reason is that the pg_dump leader approach requests shared locks (ACCESS SHARE) around the objects the employee processes will dump later on so as to make sure that no person deletes them and makes them disappear when the dump is jogging. If A further customer then requests an exceptional lock over a desk, that lock won't be granted but will probably be queued watching for the shared lock of your leader approach to generally be released.
This really is the same as the -t/--desk option, apart from that What's more, it contains any partitions or inheritance little one tables on the table(s) matching the sample
+ 1 connections on the databases, so ensure that your max_connections setting is high plenty of to support all connections.
Do not output instructions to select tablespaces. With this selection, all objects will be developed in whichever tablespace could be the default throughout restore.
For the customized and Listing archive formats, this specifies compression of individual table-knowledge segments, and also the default should be to compress applying gzip at a reasonable degree. For plain text output, location a nonzero compression degree triggers the complete output file to be compressed, as though it were fed by way of gzip, lz4, or zstd; even so the default is not to compress.
pg_dump -j takes advantage of multiple database connections; it connects into the database as soon as Together with the chief procedure and Once more for each worker work. with no synchronized snapshot characteristic, the several employee Careers wouldn't be certain to see precisely the same facts in Each individual connection, which could lead to an inconsistent backup.