You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
{{ message }}
This repository has been archived by the owner on Jul 24, 2021. It is now read-only.
Author: species [Added to the original trac issue at 2.17pm, Monday, 19th September 2011]
Is hstore enable for the postgres user owning the database?
you can view enabled extensions with:
sudo -u postgres psql -U gis # where "gis" is the owner of the DB you want import into
SELECT * FROM pg_available_extensions ;
i had the same problem with osm2pgsql and psql9.1rc1, and after
CREATE EXTENSION hstore;
as the user owning the DB (hat to set him superuser before) the import worked.
Reporter: hadmut[at]danisch.de
[Submitted to the original trac issue database at 10.06pm, Sunday, 28th August 2011]
Hi,
I am trying to create a new database under postgresql 9.1rc1 with osmosis 0.39 and
psql -d osm -f pgsnapshot_schema_0.6.sql
getting the error message
psql:pgsnapshot_schema_0.6.sql:52: ERROR: type "hstore" does not exist
The text was updated successfully, but these errors were encountered: