tecmintdb
with the name of the database you want to backup). By default, the output format is a plain-text SQL script file.-F
option, where c
means custom format archive file, d
means directory format archive, and t
means tar format archive file: all formats are suitable for input into pg_restore.-f
flag (which is used to specify the output file) to specify the target directory instead of a file. The directory which will be created by pg_dump must not exist.-j
flag, as shown.-h
to specify the remote host and -p
specifies the remote port the database server is listening on. Besides, use the -U
flag to specify the database role name to connect as.