pg_dumpall
Extract a PostgreSQL database cluster into a script file or other archive file. More information: <https://www.postgresql.org/docs/current/app-pg-dumpall.html>.
Install
- All systems
-
curl cmd.cat/pg_dumpall.sh
- Debian
-
apt-get install postgresql-client-9.1
- Ubuntu
-
apt-get install postgresql-client-9.3
- Alpine
-
apk add postgresql
- Arch Linux
-
pacman -S postgresql-old-upgrade
- Kali Linux
-
apt-get install postgresql-client-11
- CentOS
-
yum install postgresql
- Fedora
-
dnf install postgresql
- Windows (WSL2)
-
sudo apt-get update
sudo apt-get install postgresql-client-9.3
- OS X
-
brew install postgresql
- Raspbian
-
apt-get install postgresql-client-9.5
- Dockerfile
- dockerfile.run/pg_dumpall
- Docker
-
docker run cmd.cat/pg_dumpall pg_dumpall
powered by Commando
Extract a PostgreSQL database cluster into a script file or other archive file. More information: <https://www.postgresql.org/docs/current/app-pg-dumpall.html>.
-
Dump all databases:
pg_dumpall > path/to/file.sql
-
Dump all databases using a specific username:
pg_dumpall --username=username > path/to/file.sql
-
Same as above, customize host and port:
pg_dumpall -h host -p port > output_file.sql
-
Dump all databases into a custom-format archive file with moderate compression:
pg_dumpall -Fc > output_file.dump
-
Dump only database data into an SQL-script file:
pg_dumpall --data-only > path/to/file.sql
-
Dump only schema (data definitions) into an SQL-script file:
pg_dumpall -s > output_file.sql
© tl;dr; authors and contributors