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

[Jian He]

5. Loading spatial data — Introduction to PostGIS
<http://postgis.net/workshops/postgis-intro/loading_data.html>
Introduction to PostGIS — Introduction to PostGIS
<http://postgis.net/workshops/postgis-intro/index.html> (data bundle)

I use the follow command to restore a database.

*pg_restore -h localhost -p 5432 -U jian -d postgis_in_action
nyc_data.backup*

I cannot load the backup file to database.
Too many errors like :

 ERROR:  type "public.geometry" does not exist
 ERROR:  relation "public.nyc_census_blocks" does not exist

There is only another .sql file. But the file only have one table:
*nyc_census_sociodata*

where can I get the table create script.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20220413/2a5e64af/attachment.html>