Specifies a job name to be used to make the dump. this feature causes pg_dump to situation a SET function rolename
In the situation of the parallel dump, the snapshot title described by this selection is utilized instead of taking a different snapshot.
parameter is interpreted as a pattern according to the same policies utilized by psql's \d commands (see Patterns), so multiple schemas may also be picked by composing wildcard characters while in the sample.
quite possibly the most adaptable output file formats are definitely the “custom made” structure (-Fc) as well as “directory” structure (-Fd). they permit for collection and reordering of all archived goods, aid parallel restoration, and therefore are compressed by default. The “Listing” structure is the one structure that supports parallel dumps.
Notice that if you utilize this option at this time, you almost certainly also want the dump be in INSERT format, since the COPY FROM during restore would not assistance row stability.
Dump knowledge as INSERT instructions (rather than COPY). This can make restoration pretty slow; it is especially valuable for building dumps that can be loaded into non-PostgreSQL databases. Any mistake all through restoring will bring about only rows which can be Portion of the problematic INSERT to generally be dropped, as an alternative to the whole desk contents.
usually, this selection is beneficial for testing but shouldn't be applied when dumping knowledge from output installation.
(500) times of Summer is really a intimate comedy for individuals who Really don't often like intimate comedies. Or, to put it yet another way, It is for individuals who enjoy the feelings but are unenthusiastic with regard to the clichés and formulation that contribute on the cookie-...
this feature is relevant only when developing a info-only dump. It instructs pg_dump to incorporate commands to briefly disable triggers to the focus on tables although the information is restored.
You can only use this feature Together with the Listing output structure mainly because Here is the only output format where by many processes can compose their facts at the same time.
mail output to the specified file. This parameter is usually omitted for file primarily based output formats, where circumstance the conventional output is utilised.
. The timeout could possibly be specified บาคาร่า in any from the formats recognized by established statement_timeout. (permitted formats change with regards to the server Edition you are dumping from, but an integer variety of milliseconds is accepted by all variations.)
don't output commands to set TOAST compression approaches. With this option, all columns are going to be restored With all the default compression placing.
usually do not output commands to select tablespaces. With this option, all objects will probably be developed in whichever tablespace would be the default in the course of restore.
Use fall ... IF EXISTS instructions to drop objects in --clear manner. This suppresses “won't exist” mistakes That may normally be reported. this selection is not legitimate Until --clear can be specified.
pg_dump -j takes advantage of many databases connections; it connects to your databases as soon as While using the leader method and Yet again for every employee position. Without the synchronized snapshot function, the several worker Work would not be guaranteed to see the identical details in each connection, which could lead to an inconsistent backup.