[postgis-users] Update to Postgis 2.0

[Dmitriy Tyugaev]

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/20121123/b8d0ed12/attachment.html>