...
Then sudo to the postgres user, add the extension to template0, create the empty database, and import the dump:
| Code Block | ||||
|---|---|---|---|---|
| ||||
createuser -D -I -R -S -P specific_postgres_user createdb -e -O specific_postgres_user mydatabase cat mydatabase.sql | psql -U specific_postgres_user mydatabase |