[postgis-users] Update to Postgis 2.0

[Dmitriy Tyugaev]

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
> "spatial_ref_sys" does not exist
> ERROR:  constraint "spatial_ref_sys_pkey" of relation "spatial_ref_sys"
> does not exist
> ERROR:  function "st_area" already exists with same argument types
> ERROR:  function "st_length" already exists with same argument types
> ERROR:  relation "abbr_RF" already exists
> ERROR:  relation "abbr_RF_fid_seq" already exists
> ERROR:  relation "admlin10" already exists
> ERROR:  relation "admlin100" already exists
> ERROR:  relation "admlin1000" already exists
> ERROR:  relation "admlin1000_fid_seq" already exists
> ERROR:  relation "admlin100_gid_seq" already exists
> ERROR:  relation "admlin10_fid_seq" already exists
> ...
> ERROR:  relation "vegpol1000_gid_seq" already exists
> ERROR:  relation "vegpol100_gid_seq" already exists
> ERROR:  relation "vegpol10_gid_seq" already exists
> ERROR:  relation "vegpol500" already exists
> ERROR:  relation "vegpol500_fid_seq" already exists
> ERROR:  relation "vegpol_dcw" already exists
> ERROR:  relation "vegpol_dcw_gid_seq" already exists
> ERROR:  duplicate key value violates unique constraint "abbr_RF_pkey"
> CONTEXT:  COPY abbr_RF, line 1: "1  21  КАМЧАТСКИЙ КРАЙ КАМ 0
> 0101000020E610000061545227209D64406F46CD57C98F4E40"
> ERROR:  duplicate key value violates unique constraint "admlin10_pkey"
> CONTEXT:  COPY admlin10, line 1: "1 1   31400000    Азов
>  0.010962700000000001
>  0102000020E610000014000000B6476FB88FB643407B884677108F474..."
> ERROR:  duplicate key value violates unique constraint "admlin100_pkey"
> CONTEXT:  COPY admlin100, line 1: "1    31400000    0.00091710100000000003
>  010200000006000000DB15FA60198F3C403ACB2C42B1434E405D8C81751C8F3C40..."
> ERROR:  duplicate key value violates unique constraint "admlin1000_pkey"
> CONTEXT:  COPY admlin1000, line 1: "1   31400000    3.4010199999999999
>  0102000020E61000006400000014AE47E17A144D40A301BC05126C5440A01A2FDD240E..."
> ERROR:  duplicate key value violates unique constraint "admlin110mln_pkey"
> CONTEXT:  COPY admlin110mln, line 1: "1 1   Country_Boundary    \N  \N
>  81500000    48.107700000000001
>  0102000020E61000003C000000EA5BE674596C4FC0E2A..."
> ERROR:  duplicate key value violates unique constraint "admlin2500_pkey"
> CONTEXT:  COPY admlin2500, line 1: "1   31400000    0.038430100000000002
>  0102000020E610000002000000029A081B9E7A414035EF384547205040E63FA4DFBE..."
> ERROR:  duplicate key value violates unique constraint "admlin500_pkey"
> CONTEXT:  COPY admlin500, line 1: "1    81400000    0.36718299999999998
> 0102000020E61000001100000007F0164850444240C0EC9E3C2C984640D49AE61DA74..."
> ERROR:  duplicate key value violates unique constraint "admlin50mln_pkey"
> CONTEXT:  COPY admlin50mln, line 1: "1  1   Disputed    \N  81500000
>  3.54954057665
> 0105000020E61000000100000001020000000E00000078ABAE4335FD47400..."
> ERROR:  duplicate key value violates unique constraint "admlin_dcw_pkey"
> ...
> CONTEXT:  COPY vegpol1000, line 1: "1   71111100    0.00000000  0.00000000
>  0.00316483000029    0.00000000000
> 0106000020E6100000010000000103000000..."
> ERROR:  duplicate key value violates unique constraint "vegpol500_pkey"
> CONTEXT:  COPY vegpol500, line 1: "1    71111100    \N
>  0.00012032999999999999  0
> 0103000020E6100000010000000D000000516B9A779CE24440545227A0890..."
> ERROR:  duplicate key value violates unique constraint "vegpol_dcw_pkey"
> CONTEXT:  COPY vegpol_dcw, line 1: "1   1   1   2.00000000  0.00000000
>  dcw dcw 0.00000000  0.00000000  0.00000000  0.0122406817793 0.00000000000
>   0..."
> ERROR:  multiple primary keys for table "abbr_RF" are not allowed
> ERROR:  multiple primary keys for table "admlin1000" are not allowed
> ERROR:  multiple primary keys for table "admlin100" are not allowed
> ERROR:  multiple primary keys for table "admlin10" are not allowed
> ERROR:  multiple primary keys for table "admlin110mln" are not allowed
> ERROR:  multiple primary keys for table "admlin2500" are not allowed
> ERROR:  multiple primary keys for table "admlin500" are not allowed
> ...
> ERROR:  multiple primary keys for table "vegpol100" are not allowed
> ERROR:  multiple primary keys for table "vegpol10" are not allowed
> ERROR:  multiple primary keys for table "vegpol500" are not allowed
> ERROR:  multiple primary keys for table "vegpol_dcw" are not allowed
> ERROR:  relation "hdrpol100_geom_1350023321432" already exists
> ERROR:  relation "rlhlin100_geom_135002394514" already exists
>
> After recovering the database is empty (( Please tell me what's wrong?
>
> --
> Cheers, Dmitriy
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20121126/fec87ae3/attachment.html>