>_ linuxcommand.dev

Startseite › pg_restore

pg_restore

Restores PostgreSQL backups from pg_dump archives

Ubuntu CentOS Debian SUSE Fedora RHEL

Syntax

$pg_restore [options] backup_file

Optionen

-U

-d

-C

-l

Examples

Examples

$pg_restore -U postgres -d mydb backup.dump

Examples

$pg_restore -l backup.dump

Examples

$pg_restore -C -d postgres backup.dump

See also

pg_dump psql createdb

Warnings

Restore operations can overwrite existing data

Alternatives

psql

Typical use cases

Restore databases

Inspect backup contents

Replay migrations

Note Typically used with custom or directory-format backups.

Export