...
Then sudo to the postgres user and , add the extension to template0, create the empty database, and import the dump:
| Code Block |
|---|
postgres@productionhost:~$ 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 |