Please, help!<br><br><div class="gmail_quote">On Fri, Nov 23, 2012 at 2:45 PM, Dmitriy Tyugaev <span dir="ltr"><<a href="mailto:dtyugaev@gmail.com" target="_blank">dtyugaev@gmail.com</a>></span> wrote:<br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">
Hi list!<div><br></div><div>I want to update my spatial database from Postgis 1.5.5 (PG 8.4) to Postgis 2.0.1 (PG 9.1)</div><div><br></div><div>I follow the instructions for hard update <a href="http://www.postgis.org/documentation/manual-svn/postgis_installation.html#hard_upgrade" target="_blank">http://www.postgis.org/documentation/manual-svn/postgis_installation.html#hard_upgrade</a> </div>
<div><br></div><div>pg_dump -h localhost -p 5432 -U postgres -Fc -b -v -f ekopie.backup ekopie</div><div><br></div><div>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).</div>
<div><br></div><div>perl <a href="http://postgis_restore.pl" target="_blank">postgis_restore.pl</a> "/opt/postgresql-8.4.7/backup/ekopie.backup" | psql -h localhost -p 5432 -U postgres ekopie 2> ekopie_errors</div>
<div><br></div>
<div><div>ERROR: constraint "spatial_ref_sys_srid_check" of relation "spatial_ref_sys" does not exist</div><div>ERROR: constraint "spatial_ref_sys_pkey" of relation "spatial_ref_sys" does not exist</div>
<div>ERROR: function "st_area" already exists with same argument types</div><div>ERROR: function "st_length" already exists with same argument types</div><div>ERROR: relation "abbr_RF" already exists</div>
<div>ERROR: relation "abbr_RF_fid_seq" already exists</div><div>ERROR: relation "admlin10" already exists</div><div>ERROR: relation "admlin100" already exists</div><div>ERROR: relation "admlin1000" already exists</div>
<div>ERROR: relation "admlin1000_fid_seq" already exists</div><div>ERROR: relation "admlin100_gid_seq" already exists</div><div>ERROR: relation "admlin10_fid_seq" already exists</div></div>
<div>...</div><div><div>ERROR: relation "vegpol1000_gid_seq" already exists</div><div>ERROR: relation "vegpol100_gid_seq" already exists</div><div>ERROR: relation "vegpol10_gid_seq" already exists</div>
<div>ERROR: relation "vegpol500" already exists</div><div>ERROR: relation "vegpol500_fid_seq" already exists</div><div>ERROR: relation "vegpol_dcw" already exists</div><div>ERROR: relation "vegpol_dcw_gid_seq" already exists</div>
<div>ERROR: duplicate key value violates unique constraint "abbr_RF_pkey"</div><div>CONTEXT: COPY abbr_RF, line 1: "1 21 КАМЧАТСКИЙ КРАЙ КАМ 0 0101000020E610000061545227209D64406F46CD57C98F4E40"</div>
<div>ERROR: duplicate key value violates unique constraint "admlin10_pkey"</div><div>CONTEXT: COPY admlin10, line 1: "1 1 31400000 Азов 0.010962700000000001 0102000020E610000014000000B6476FB88FB643407B884677108F474..."</div>
<div>ERROR: duplicate key value violates unique constraint "admlin100_pkey"</div><div>CONTEXT: COPY admlin100, line 1: "1 31400000 0.00091710100000000003 010200000006000000DB15FA60198F3C403ACB2C42B1434E405D8C81751C8F3C40..."</div>
<div>ERROR: duplicate key value violates unique constraint "admlin1000_pkey"</div><div>CONTEXT: COPY admlin1000, line 1: "1 31400000 3.4010199999999999 0102000020E61000006400000014AE47E17A144D40A301BC05126C5440A01A2FDD240E..."</div>
<div>ERROR: duplicate key value violates unique constraint "admlin110mln_pkey"</div><div>CONTEXT: COPY admlin110mln, line 1: "1 1 Country_Boundary \N \N 81500000 48.107700000000001 0102000020E61000003C000000EA5BE674596C4FC0E2A..."</div>
<div>ERROR: duplicate key value violates unique constraint "admlin2500_pkey"</div><div>CONTEXT: COPY admlin2500, line 1: "1 31400000 0.038430100000000002 0102000020E610000002000000029A081B9E7A414035EF384547205040E63FA4DFBE..."</div>
<div>ERROR: duplicate key value violates unique constraint "admlin500_pkey"</div><div>CONTEXT: COPY admlin500, line 1: "1 81400000 0.36718299999999998 0102000020E61000001100000007F0164850444240C0EC9E3C2C984640D49AE61DA74..."</div>
<div>ERROR: duplicate key value violates unique constraint "admlin50mln_pkey"</div><div>CONTEXT: COPY admlin50mln, line 1: "1 1 Disputed \N 81500000 3.54954057665 0105000020E61000000100000001020000000E00000078ABAE4335FD47400..."</div>
<div>ERROR: duplicate key value violates unique constraint "admlin_dcw_pkey"</div></div><div>...</div><div><div>CONTEXT: COPY vegpol1000, line 1: "1 71111100 0.00000000 0.00000000 0.00316483000029 0.00000000000 0106000020E6100000010000000103000000..."</div>
<div>ERROR: duplicate key value violates unique constraint "vegpol500_pkey"</div><div>CONTEXT: COPY vegpol500, line 1: "1 71111100 \N 0.00012032999999999999 0 0103000020E6100000010000000D000000516B9A779CE24440545227A0890..."</div>
<div>ERROR: duplicate key value violates unique constraint "vegpol_dcw_pkey"</div><div>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..."</div>
<div>ERROR: multiple primary keys for table "abbr_RF" are not allowed</div><div>ERROR: multiple primary keys for table "admlin1000" are not allowed</div><div>ERROR: multiple primary keys for table "admlin100" are not allowed</div>
<div>ERROR: multiple primary keys for table "admlin10" are not allowed</div><div>ERROR: multiple primary keys for table "admlin110mln" are not allowed</div><div>ERROR: multiple primary keys for table "admlin2500" are not allowed</div>
<div>ERROR: multiple primary keys for table "admlin500" are not allowed</div></div><div>...</div><div><div>ERROR: multiple primary keys for table "vegpol100" are not allowed</div><div>ERROR: multiple primary keys for table "vegpol10" are not allowed</div>
<div>ERROR: multiple primary keys for table "vegpol500" are not allowed</div><div>ERROR: multiple primary keys for table "vegpol_dcw" are not allowed</div><div>ERROR: relation "hdrpol100_geom_1350023321432" already exists</div>
<div>ERROR: relation "rlhlin100_geom_135002394514" already exists</div></div><div><br></div><div>After recovering the database is empty (( Please tell me what's wrong?</div><div><br></div><div>--</div><div>
Cheers, Dmitriy</div>
</blockquote></div><br>