Opened 9 years ago

Closed 7 years ago

#3498 closed defect (wontfix)

postgis restore failed

Reported by: atur Owned by: strk
Priority: medium Milestone: PostGIS 2.4.0
Component: build Version: 2.1.x
Keywords: Cc:

Description

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

Change History (3)

comment:1 by robe, 8 years ago

Component: postgisbuild/upgrade/install
Milestone: PostGIS 2.3.0
Owner: changed from pramsey to strk

comment:2 by robe, 8 years ago

Milestone: PostGIS 2.3.0PostGIS 2.4.0

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.

comment:3 by robe, 7 years ago

Resolution: wontfix
Status: newclosed

no response closing this out.

Note: See TracTickets for help on using tickets.