Child pages
  • Migrating databases with 'hstore' datatype

Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

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