Re: [postgis-users] postgis introduction data bundle can not restore a backup.

2022-04-13 Thread Jian He
Thanks. Problem solved. On Wed, Apr 13, 2022 at 5:51 PM Imre Samu wrote: > > 5. Loading spatial data — Introduction to PostGIS > > ERROR: type "public.geometry" does not exist > > as I see in the "4. Creating a Spatial Database" > https://postgis.net/workshops/postgis-intro/creating_db.html >

Re: [postgis-users] postgis introduction data bundle can not restore a backup.

2022-04-13 Thread Imre Samu
> 5. Loading spatial data — Introduction to PostGIS > ERROR: type "public.geometry" does not exist as I see in the "4. Creating a Spatial Database" https://postgis.net/workshops/postgis-intro/creating_db.html there are 2 important step - create Username as postgres. - "CREATE EXTENSION postgis;"

[postgis-users] postgis introduction data bundle can not restore a backup.

2022-04-13 Thread Jian He
5. Loading spatial data — Introduction to PostGIS Introduction to PostGIS — Introduction to PostGIS (data bundle) I use the follow command to restore a database. *pg_restore -h l