postgresql create new database from dump code example Example: how to take database dump in postgresql pg_dump dbname > outfile