Skip to content

Pgdump

Global

Dump postgresql database

sh
PGPASSWORD=<db_password> pg_dump -Fc -U <db_user> -p <db_port> -h <db_host> <db_name> > <output_file>

OR

sh
pg_dump -Fc -d "postgresql://<db_user>:<db_password>@<db_host>:<db_port>/<db_name>" > <output_file>