>_ linuxcommand.dev

Startseite › pg_dump

Database

pg_dump

PostgreSQL Database Backup

Ubuntu CentOS Debian SUSE Fedora RHEL

Verified: 2026-03-04

Syntax

$pg_dump [options] [database]

Optionen

-U

-h

-p

-t

--format

Examples

$pg_dump -U postgres database > backup.sql

$pg_dump -U postgres --format=c database > backup.dump

$pg_dump -U postgres -t table_name database > table_backup.sql

See also

pg_restore psql pg_dumpall

Typical use cases

?

Standard usage

pg_dump --help

Note Creates backups of PostgreSQL databases.

Export