Specifies a job name to be used to create the dump. this selection leads to pg_dump to challenge a established purpose rolename
However, pg_dump will waste a connection attempt locating out which the server needs a password. sometimes it really is worth typing -W to avoid the additional relationship endeavor.
The alternative archive file formats needs to be used with pg_restore to rebuild the database. they permit pg_restore to be selective about what exactly is restored, and even to reorder the merchandise just before becoming restored. The archive file formats are built to be portable throughout architectures.
It won't dump the contents of sights or materialized sights, and also the contents of foreign tables will only be dumped if the corresponding foreign server is specified with --consist of-foreign-information.
this feature is for use by in-position update utilities. Its use for other applications just isn't proposed or supported. The behavior of the choice may perhaps alter in long term releases all of sudden.
Output SQL-conventional SET SESSION AUTHORIZATION instructions instead of ALTER operator instructions to find out item ownership. This helps make the dump far more standards-suitable, but depending on the background from the objects during the dump, may not restore adequately.
. The sample is interpreted in accordance with the exact same principles as for -n. -N might be given a lot more than after to exclude schemas matching any of a number of patterns.
(five hundred) times of Summer can be a passionate comedy for individuals who don't usually like intimate comedies. Or, To place it another way, It truly is for people who enjoy the emotions but are unenthusiastic with regards to the clichés and formulas that add towards the cookie-...
If the thing is anything at all in the documentation that's not suitable, won't match your knowledge with the particular feature or involves even further clarification, you should use this manner to report a documentation problem.
build the dump in the specified character set encoding. By default, the dump is produced while in the databases encoding. (Another way to obtain the very same result's to set the PGCLIENTENCODING natural environment variable to the specified dump encoding.) The supported encodings are described in part 24.3.1.
tables simultaneously. This option could lessen the time necessary to carry out the dump but In addition it improves the load on the databases server.
When dumping data for the desk partition, make the duplicate or INSERT statements target the root in the partitioning hierarchy which contains it, rather than the partition itself. This leads to the right partition to แทงบอล be re-determined for every row when the data is loaded.
never output commands to set TOAST compression procedures. With this option, all columns will likely be restored While using the default compression location.
tend not to output instructions to choose tablespaces. With this feature, all objects will be made in whichever tablespace will be the default during restore.
Use fall ... IF EXISTS commands to fall objects in --cleanse method. This suppresses “will not exist” problems that might normally be claimed. This option isn't valid Until --clear is usually specified.
Use a serializable transaction for your dump, making sure that the snapshot utilized is in line with later database states; but do this by expecting some extent from the transaction stream at which no anomalies is usually current, so that There is not a danger from the dump failing or producing other transactions to roll again with a serialization_failure. See Chapter 13 To find out more about transaction isolation and concurrency control.