Connect to database dbname and restore directly into the database. The dbname can be a connection string. If so, connection string parameters will override any conflicting command line options. -e Do not output commands to set TOAST compression methods. With this option, all columns will be restored with the default compression setting. --no-unlogged-table-data Restore only the schema (data definitions), not data, to the extent that schema entries are present in the archive. In versions prior to PostgreSQL 9.6, this flag matched only tables, not any other type of relation. -T trigger

In the case of a parallel dump, the snapshot name defined by this option is used rather than taking a new snapshot. --strict-names This is the same as the -t/ --table option, except that it also includes any partitions or inheritance child tables of the table(s) matching the pattern. --use-set-session-authorization The dump file produced by pg_dump does not contain the statistics used by the optimizer to make query planning decisions. Therefore, it is wise to run ANALYZE after restoring from a dump file to ensure optimal performance; see Section25.1.3 and Section25.1.6 for more information. Do not output commands to select tablespaces. With this option, all objects will be created in whichever tablespace is the default during restore.A dual-mesh, semi-transparent zipped overlay fastens over the laces to provide both supportive containment and ideal breathability. Specifies verbose mode. This will cause pg_restore to output detailed object comments and start/stop times to the output file, and progress messages to standard error. Repeating the option causes additional debug-level messages to appear on standard error. -V To insure the highest level of viability, thaw the vial and initiate the culture as soon as possible upon receipt. If upon arrival, continued storage of the frozen culture is necessary, it should be stored in liquid nitrogen vapor phase and not at -70°C. Storage at -70°C will result in loss of viability.

This option has no effect on -N/ --exclude-schema, -T/ --exclude-table, or --exclude-table-data. An exclude pattern failing to match any objects is not considered an error. --table-and-children= pattern Dump only tables with names matching pattern. Multiple tables can be selected by writing multiple -t switches. The pattern parameter is interpreted as a pattern according to the same rules used by psql's \d commands (see Patterns), so multiple tables can also be selected by writing wildcard characters in the pattern. When using wildcards, be careful to quote the pattern if needed to prevent the shell from expanding the wildcards; see Examples below. This product is intended for laboratory research use only. It is not intended for any animal or human therapeutic use, any human or animal consumption, or any diagnostic use. With --create, the output also includes the database's comment if any, and any configuration variable settings that are specific to this database, that is, any ALTER DATABASE ... SET ... and ALTER ROLE ... IN DATABASE ... SET ... commands that mention this database. Access privileges for the database itself are also dumped, unless --no-acl is specified.This option disables the use of dollar quoting for function bodies, and forces them to be quoted using SQL standard string syntax. --disable-triggers Do not dump data for any tables matching pattern. The pattern is interpreted according to the same rules as for -t. --exclude-table-data can be given more than once to exclude tables matching any of several patterns. This option is useful when you need the definition of a particular table even though you do not need the data in it. Do not output commands to select table access methods. With this option, all objects will be created with whichever access method is the default during restore. --no-tablespaces With --create, pg_restore also restores the database's comment if any, and any configuration variable settings that are specific to this database, that is, any ALTER DATABASE ... SET ... and ALTER ROLE ... IN DATABASE ... SET ... commands that mention this database. Access privileges for the database itself are also restored, unless --no-acl is specified.

Only the custom and directory archive formats are supported with this option. The input must be a regular file or directory (not, for example, a pipe or standard input). Also, multiple jobs cannot be used together with the option --single-transaction. -l Do not dump any schemas matching pattern. The pattern is interpreted according to the same rules as for -n. -N can be given more than once to exclude schemas matching any of several patterns. Do not output commands to set ownership of objects to match the original database. By default, pg_dump issues ALTER OWNER or SET SESSION AUTHORIZATION statements to set ownership of created database objects. These statements will fail when the script is run unless it is started by a superuser (or the same user that owns all of the objects in the script). To make a script that can be restored by any user, but will give that user ownership of all the objects, specify -O. This option is effective only when restoring directly into a database, not when producing SQL script output. --no-publications For the custom and directory archive formats, this specifies compression of individual table-data segments, and the default is to compress using gzip at a moderate level. For plain text output, setting a nonzero compression level causes the entire output file to be compressed, as though it had been fed through gzip, lz4, or zstd; but the default is not to compress. With zstd compression, long mode may improve the compression ratio, at the cost of increased memory use.Do not dump the contents of unlogged tables and sequences. This option has no effect on whether or not the table and sequence definitions (schema) are dumped; it only suppresses dumping the table and sequence data. Data in unlogged tables and sequences is always excluded when dumping from a standby server. --on-conflict-do-nothing Resuspend the cell pellet with the recommended complete medium and dispense into a 25 cm 2 culture flask. It is important to avoid excessive alkalinity of the medium during recovery of the cells. It is suggested that, prior to the addition of the vial contents, the culture vessel containing the complete growth medium be placed into the incubator for at least 15 minutes to allow the medium to reach its normal pH (7.0 to 7.6). Do not output commands to restore subscriptions, even if the archive contains them. --no-table-access-method

Run the most time-consuming steps of pg_restore — those that load data, create indexes, or create constraints — concurrently, using up to number-of-jobs concurrent sessions. This option can dramatically reduce the time to restore a large database to a server running on a multiprocessor machine. This option is ignored when emitting a script rather than connecting directly to a database server. Notice we don't use -C, and instead connect directly to the database to be restored into. Also note that we clone the new database from template0 not template1, to ensure it is initially empty.Include large objects in the dump. This is the default behavior except when --schema, --table, or --schema-only is specified. The -b switch is therefore only useful to add large objects to dumps where a specific schema or table has been requested. Note that large objects are considered data and therefore will be included when --data-only is used, but not when --schema-only is. -B Run the dump in parallel by dumping njobs tables simultaneously. This option may reduce the time needed to perform the dump but it also increases the load on the database server. You can only use this option with the directory output format because this is the only output format where multiple processes can write their data at the same time. Dumps can be output in script or archive file formats. Script dumps are plain-text files containing the SQL commands required to reconstruct the database to the state it was in at the time it was saved. To restore from such a script, feed it to psql. Script files can be used to reconstruct the database even on other machines and other architectures; with some modifications, even on other SQL database products. Specifies the name of the database to connect to. This is equivalent to specifying dbname as the first non-option argument on the command line. The dbname can be a connection string. If so, connection string parameters will override any conflicting command line options. -h host