Output a directory-structure archive appropriate for enter into pg_restore. this can create a Listing with one particular file for each desk and enormous item becoming dumped, plus a so-referred to as Table of Contents file describing the dumped objects in a very machine-readable format that pg_restore can go through.
parameter is interpreted to be a pattern according to the very same procedures utilized by psql's \d instructions (see styles), so several international servers can also be selected by producing wildcard figures within the pattern.
These statements will fail in the event the script is run Unless of course it really is started by a superuser (or the same consumer that owns the entire objects during the script). for making a script that could be restored by any user, but will give that consumer ownership of every one of the objects, specify -O.
With zstd compression, very long manner may well improve the compression ratio, at the expense of increased memory use.
Note that if you utilize this option currently, you almost certainly also want the dump be in INSERT structure, as the COPY FROM in the course of restore would not guidance row safety.
Output SQL-standard established SESSION AUTHORIZATION commands as opposed to ALTER OWNER instructions to find out item possession. This makes the dump extra expectations-compatible, but with regards to the history with the objects while in the dump, might not restore adequately.
this selection is beneficial when needing to synchronize the dump using a reasonable replication slot (see Chapter forty nine) or which has a concurrent session.
Output commands to DROP all of the dumped database objects prior to outputting the commands for developing them. this feature is helpful when the restore is to overwrite an present database.
this feature is applicable only when developing a knowledge-only dump. It instructs pg_dump to incorporate instructions to temporarily disable triggers on the concentrate on tables even though the info is restored.
could be a relationship บาคาร่า string. If that's the case, link string parameters will override any conflicting command line possibilities.
deliver output to the specified file. This parameter might be omitted for file based mostly output formats, where case the typical output is applied.
. The timeout may be specified in any on the formats accepted by established statement_timeout. (authorized formats change with regards to the server Model you are dumping from, but an integer number of milliseconds is recognized by all variations.)
Also, It isn't confirmed that pg_dump's output may be loaded into a server of the more mature significant Variation — not regardless of whether the dump was taken from a server of that version. Loading a dump file into an more mature server may well require guide enhancing from the dump file to eliminate syntax not comprehended by the more mature server. Use from the --quotation-all-identifiers solution is usually recommended in cross-Variation cases, as it may prevent challenges arising from various reserved-word lists in various PostgreSQL versions.
In the event your databases cluster has any area additions to the template1 database, be careful to revive the output of pg_dump into A very empty databases; usually you might be prone to get errors on account of copy definitions of your additional objects.
with out it the dump may replicate a point out which isn't according to any serial execution on the transactions at some point committed. as an example, if batch processing approaches are employed, a batch may well show as shut while in the dump with out all of the items which are within the batch showing up.
this selection is suitable only when dumping the contents of a table that has row protection. By default, pg_dump will set row_security to off, making sure that all information is dumped from the desk.