PostgreSQL pg_dump — Basic UsageIT technician command center
● ITSign inMembers
Database · SQL and Database Administration

PostgreSQL pg_dump — Basic Usage

Use PostgreSQL pg_dump for a standard administrative task.

Copy-ready commandPostgreSQL pg_dump — Basic Usage
pg_dump -Fc database_name > backup.dump

Requirements and permissions

Requirements
Appropriate database client and connection
Permissions
Database privileges vary
Last reviewed
2026-07-31

Examples

Basic Usage

Use PostgreSQL pg_dump for a standard administrative task.

pg_dump -Fc database_name > backup.dump

Original command

Create a PostgreSQL custom-format backup.

pg_dump -Fc database_name > backup.dump

Common errors

Command not found

Confirm Appropriate database client and connection is installed and available in your current shell.