I am dumping my Postgres database using pg_dump (in plain-text format) and then restore it simply by using psql (with the -f
option).
Which begs the question: am I missing anything by not using pg_restore which seems like a specialized restore tool (compared to the generic psql
)?
I can control options like disabling of triggers and such by using pg_dump
parameters. What, then, is pg_restore
used for? non-plain-text dump formats ?