Error Dumping Postgres Database

21 Mar 2021, 9:24 p.m.

7 Jun 2021, 9:14 a.m.

00:31 minutes

When dumping database

sudo -u postgres pg_dump database-name  > dump.sql

You get an error that looks like

The fix

dpkg-reconfigure locales

For completeness, we should also talk about importing a database

su postgres
psql -U postgres  database-name  > dump.sql

References