postgis restore failed

[atur]

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 ……

[robe]

I don't think we have enough to go on here, if you can provide a sample backup we can test restore, that would be a start and full error file.

That said I'm pushing this.

[robe]

no response closing this out.