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