How To Backup PostgreSQL Database With pg_dump And pg_dumpall From Serve...

pg_dump -h localhost -d dvdrental -U postgres -p 5432 -F tar >D:\DB_CMD_BKP\dvdrental.tar

pg_dump -h localhost -d dvdrental -U postgres -p 5432 -F custom >D:\DB_CMD_BKP\dvdrental.bak

pg_dump -h localhost -d dvdrental -U postgres -p 5432 -F plain >D:\DB_CMD_BKP\dvdrental.sql

pg_dump -h localhost -d dvdrental -U postgres -p 5432 -F directory -f D:\DB_CMD_BKP\Directory_BKP

pg_dumpall -h localhost -U postgres -p 5432 >D:\DB_CMD_BKP\Dump_All\DBs.sql