> If you are doing a custom format dump using .sql as the extension is > objectively wrong. it is correct if you are doing an sql dump, but those > are generally best avoided.
David,
I use the default text format so restoration is by psql.
Perfectly valid for small databases, and copying tables from one instance to another (though in that case, consider postgres_fdw).