deliver output to the specified file. This parameter can be omitted for file based output formats, through which situation the normal click here output is utilised.
to generate an vacant database without any area additions, duplicate from template0 not template1, such as:
pg_dump is usually a utility for backing up a PostgreSQL database. It helps make regular backups regardless of whether the databases is getting used concurrently. pg_dump will not block other end users accessing the database (viewers or writers).
never output commands to pick out tablespaces. With this option, all objects are going to be made in whichever tablespace may be the default all through restore.
Specifies a job name to be used to develop the dump. This option causes pg_dump to challenge a established job rolename
When dumping logical replication subscriptions, pg_dump will deliver CREATE membership commands that make use of the join = Wrong solution, to ensure restoring the subscription would not make distant connections for making a replication slot or for initial table copy. That way, the dump can be restored without requiring network usage of the remote servers. it truly is then up into the person to reactivate the subscriptions in an appropriate way.
parameter is interpreted to be a pattern according to the very same guidelines utilized by psql's \d commands (see styles), so various extensions will also be chosen by writing wildcard characters inside the sample.
. The pattern is interpreted based on the exact guidelines as for -n. -N can be presented greater than the moment to exclude schemas matching any of several patterns.
; this selects each the schema by itself, and all its contained objects. When this option will not be specified, all non-system schemas during the goal database will probably be dumped. a number of schemas might be chosen by writing multiple -n switches. The sample
With zstd compression, extended manner may possibly improve the compression ratio, at the expense of greater memory use.
is usually a connection string. If so, link string parameters will override any conflicting command line choices.
commonly, this feature is helpful for testing but really should not be employed when dumping information from creation set up.
Dumps can be output in script or archive file formats. Script dumps are basic-text data files made up of the SQL instructions necessary to reconstruct the database into the state it absolutely was in at time it absolutely was saved.
parameter is interpreted to be a pattern according to the same principles utilized by psql's \d instructions (see Patterns), so several tables will also be chosen by writing wildcard people during the sample.
Specify the compression system and/or the compression stage to utilize. The compression system may be established to gzip, lz4, zstd, or none for no compression. A compression element string can optionally be specified.
When working with wildcards, be cautious to estimate the sample if needed to forestall the shell from expanding the wildcards; see Examples under.