Just got a plain SQL dump of a database and in this case pg_restore does not work. This post shows how to use psql to load such a dump into a database in the context of a local development environment.

An example how to use plain SQL to migrate data in a database using Alembic.

Showing how to use pg_restore to load a dump into a developer's database server for local development.