使用以下命令在本地进行数据库备份

Use below command to take Database backup locally

pg_dump -U postgres -h 127.0.0.1 -p 5432 -Fc -f FileName.backup -w DBName

如果要远程备份数据库，则可以使用远程IPAddress代替127.0.0.1。

If you want to take database backup remotely Than use Remote IPAddress in place of 127.0.0.1.