dump all local databases postgresql terminal code example Example: how to take database dump in postgresql pg_dump dbname > outfile