ITMan Documents

This Weblog Just Created For Document Sysadmin Challenges

pg_dump

#---on postgres docker---
pg_dump -U <Database User> -w -d <Database Name> -h 127.0.0.1 -p 5432 > <Backup File Name>.sql

#---on postgres system---
sudo -u postgres psql -U postgres -w -d <Database Name> -h 127.0.0.1 -p 5432 > <Backup File Name>
Last updated on 26 Oct 2020
Published on 23 Nov 2018