Migrating a Postgres Database to remote RDS with psql instead of Postico2

I had an export of a Postgres database from Directus in SQL.

Tryign to import this to an RDS instance with Postico 2 failed because of a syntax error.

Discussion here https://github.com/jakob/Postico/issues/305

So I installed psql and use the following command to import to a remote database

$ psql -h hostname -d databasename -U username -f file.sql

simple.

Was this article helpful?
YesNo