[postgis-users] Update to Postgis 2.0
strk at keybit.net
Mon Nov 26 00:42:23 PST 2012
On Mon, Nov 26, 2012 at 11:50:07AM +0400, Dmitriy Tyugaev wrote:
> Please, help!
> On Fri, Nov 23, 2012 at 2:45 PM, Dmitriy Tyugaev <dtyugaev at gmail.com> wrote:
> > Hi list!
> > I want to update my spatial database from Postgis 1.5.5 (PG 8.4) to
> > Postgis 2.0.1 (PG 9.1)
> > I follow the instructions for hard update
> > http://www.postgis.org/documentation/manual-svn/postgis_installation.html#hard_upgrade
> > pg_dump -h localhost -p 5432 -U postgres -Fc -b -v -f ekopie.backup ekopie
> > Dump is created normally without errors, but I when I try to restore it I
> > get an errors in the log file (on the screen, everything looks ok).
> > perl postgis_restore.pl "/opt/postgresql-8.4.7/backup/ekopie.backup" |
> > psql -h localhost -p 5432 -U postgres ekopie 2> ekopie_errors
> > ERROR: constraint "spatial_ref_sys_srid_check" of relation
Did you install postgis on "ekopie" before restoring the backup on it ?
Also, I'd recommend to redirect postgis_restore.pl errors into a file too,
and to request verbose operations:
perl postgis_restore.pl -v "/opt/postgresql-8.4.7/backup/ekopie.backup" 2>
restore_errors.txt | psql -h localhost -p 5432 -U postgres ekopie 2>
http://www.cartodb.com - Map, analyze and build applications with your data
More information about the postgis-users