สล็อต pg Options
สล็อต pg Options
Blog Article
Output a Listing-structure archive suited to input into pg_restore. this will likely make a Listing with 1 file for every desk and huge item getting dumped, in addition a so-referred to as desk of Contents file describing the dumped objects inside a equipment-readable format that pg_restore can go through.
In the situation of a parallel dump, the snapshot name outlined by this option is made use of rather then using a fresh snapshot.
parameter is interpreted as being a sample in accordance with the exact regulations used by psql's \d instructions (see Patterns), so a number of schemas can even be picked by creating wildcard people inside the sample.
Specifies the host name of your equipment on which the server is managing. If the worth begins by using a slash, it really is used as the directory for the Unix area socket. The default is taken in the PGHOST surroundings variable, if set, else a Unix domain socket relationship is tried.
Take note that if you utilize this option presently, you most likely also want the dump be in INSERT structure, since the duplicate FROM throughout restore will not help row เว็บตรง safety.
Output SQL-typical established SESSION AUTHORIZATION commands as an alternative to ALTER OWNER instructions to ascertain item possession. This tends to make the dump extra specifications-compatible, but according to the historical past in the objects within the dump, won't restore effectively.
. The pattern is interpreted according to the very same regulations as for -n. -N may be specified a lot more than when to exclude schemas matching any of quite a few styles.
Output instructions to DROP every one of the dumped databases objects prior to outputting the instructions for building them. This option is beneficial once the restore is to overwrite an current databases.
. The pattern is interpreted based on the exact guidelines as for -t. -T may be presented much more than when to exclude tables matching any of various patterns.
hardly ever challenge a password prompt. When the server calls for password authentication in addition to a password just isn't offered by other signifies such as a .pgpass file, the connection endeavor will are unsuccessful. this selection is usually handy in batch Employment and scripts the place no user is existing to enter a password.
, ...) VALUES ...). This could make restoration very gradual; it is mainly valuable for creating dumps which can be loaded into non-PostgreSQL databases. Any error through restoring will cause only rows that happen to be Element of the problematic INSERT for being shed, as opposed to your complete desk contents.
This can be similar to the -t/--table alternative, besides that In addition, it incorporates any partitions or inheritance boy or girl tables on the table(s) matching the pattern
usually do not output instructions to established TOAST compression solutions. With this feature, all columns might be restored Together with the default compression environment.
Use this When you've got referential integrity checks or other triggers around the tables that you do not wish to invoke through facts restore.
this selection will not be beneficial for your dump which is meant only for catastrophe Restoration. it may be helpful for just a dump accustomed to load a duplicate in the databases for reporting or other examine-only load sharing while the initial database continues for being updated.
Use a serializable transaction for that dump, making sure that the snapshot employed is consistent with later on databases states; but try this by watching for a degree within the transaction stream at which no anomalies might be existing, to make sure that there isn't a chance in the dump failing or resulting in other transactions to roll back having a serialization_failure. See Chapter 13 To learn more about transaction isolation and concurrency Management.
Report this page