UPDATE ......From Tuesday 8 April 2025 we have changed the way that Single Sign-on works on this wiki. Please see here for more information:
Update
...
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 |