On Wed, Jun 19, 2024 at 1:14 PM Rich Shepard <rshepard@xxxxxxxxxxxxxxx> wrote:
On Wed, 19 Jun 2024, David G. Johnston wrote:
> 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).
