[postgis-users] Update to Postgis 2.0

[Sandro Santilli]

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>
 psql_errors.txt

--strk;

 http://www.cartodb.com - Map, analyze and build applications with your data

                                       ~~ http://strk.keybit.net