From: | "Zeng, David (GE Healthcare)" <david(dot)zeng(at)ge(dot)com> |
---|---|
To: | "pgsql-admin(at)lists(dot)postgresql(dot)org" <pgsql-admin(at)lists(dot)postgresql(dot)org> |
Subject: | Trouble creating extensions: postgis and postgis_topology |
Date: | 2018-03-08 19:41:29 |
Message-ID: | BL6P101MB018002D183E039DCC96299CCF1DF0@BL6P101MB0180.NAMP101.PROD.OUTLOOK.COM |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-admin |
Hello, my friends, I am configuring PostGIS for the database restore. I ran the following sequence successfully on a brand new database yesterday afternoon:
CREATE SCHEMA postgis;
ALTER DATABASE dz5 SET search_path="$user", public, postgis,topology;
GRANT ALL ON SCHEMA postgis TO public;
CREATE EXTENSION postgis WITH SCHEMA postgis;
CREATE EXTENSION postgis_topology;
However, I got the following error when it get to “CREATE EXTENSION postgis_topology;” step today:
ERROR: type "geometry" does not exist
Any thoughts? Has any one of you experienced this before?
______________________________
David Zeng | System Database Administrator
From | Date | Subject | |
---|---|---|---|
Next Message | David G. Johnston | 2018-03-08 19:45:23 | Re: Trouble creating extensions: postgis and postgis_topology |
Previous Message | David G. Johnston | 2018-03-08 19:01:54 | Re: How to identify users with super privilegies in postgress ? |