[postgis-tickets] [PostGIS] #3498: postgis restore failed

[PostGIS]

#3498: postgis restore failed
---------------------+---------------------
 Reporter:  atur     |      Owner:  pramsey
     Type:  defect   |     Status:  new
 Priority:  medium   |  Milestone:
Component:  postgis  |    Version:  2.1.x
 Keywords:           |
---------------------+---------------------
 Restore failed on ubuntu but worked on windows 7.

 Here what i have done:

 Backup was done on ubuntu 12.04.5 with postgresql 9.1.20 and postgis 1.5
 as:
 pg_dump -h localhost -p 5432 -U postgres -Fc -b -v -f
 "/somepath/olddb.backup" olddb

 Restore on ubuntu 14.04.4 with postgresql 9.3 and postgis 2.1 failed:
 perl utils/postgis_restore.pl "/somepath/olddb.backup" | psql -h localhost
 -p 5432 -U postgres newdb 2> errors.txt

 I used "create extension postgis" on the restore server.
 Resulting errors:

  ERROR:  syntax error at or near "Where"
 LINE 5: ...COLUMN determinations.taxa_taxon_list_id_list IS 'Where this...
                                                              ^
 ERROR:  syntax error at or near "public"
 LINE 1: public>
         ^
 ERROR:  syntax error at or near "'::character varying ELSE
 COALESCE(w.title, '"
 LINE 1: '::character varying ELSE COALESCE(w.title, '<
         ^
 ERROR:  syntax error at or near "none"
 LINE 1: none>
         ^
 invalid command \N
 invalid command \N
 ......

--
Ticket URL: <https://trac.osgeo.org/postgis/ticket/3498>
PostGIS <http://trac.osgeo.org/postgis/>
The PostGIS Trac is used for bug, enhancement & task tracking, a user and developer wiki, and a view into the subversion code repository of PostGIS project.