Pg_dump
Pg_dump password
Questions in this topic
Does Pg_dump lock the database?
How do I export a table from PostgreSQL to excel?
What is an SQL dump?