postgresql backup pg_dump example
Example 1: postgresql pg_dump
pg_dump -U user -d db_name -h 127.0.0.1 > dump.sql
Example 2: how to backup postgresql database using pg_dump
pg_dump dbname > outfile
pg_dump -U user -d db_name -h 127.0.0.1 > dump.sql
pg_dump dbname > outfile