<META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=iso-8859-1">
<html xmlns:v="urn:schemas-microsoft-com:vml" xmlns:o="urn:schemas-microsoft-com:office:office" xmlns:w="urn:schemas-microsoft-com:office:word" xmlns:m="http://schemas.microsoft.com/office/2004/12/omml" xmlns="http://www.w3.org/TR/REC-html40"><head><meta name=Generator content="Microsoft Word 15 (filtered medium)"><!--[if !mso]><style>v\:* {behavior:url(#default#VML);}
o\:* {behavior:url(#default#VML);}
w\:* {behavior:url(#default#VML);}
.shape {behavior:url(#default#VML);}
</style><![endif]--><style><!--
/* Font Definitions */
@font-face
{font-family:"Cambria Math";
panose-1:2 4 5 3 5 4 6 3 2 4;}
@font-face
{font-family:Calibri;
panose-1:2 15 5 2 2 2 4 3 2 4;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0in;
margin-bottom:.0001pt;
font-size:11.0pt;
font-family:"Calibri",sans-serif;}
a:link, span.MsoHyperlink
{mso-style-priority:99;
color:#0563C1;
text-decoration:underline;}
a:visited, span.MsoHyperlinkFollowed
{mso-style-priority:99;
color:#954F72;
text-decoration:underline;}
p.msonormal0, li.msonormal0, div.msonormal0
{mso-style-name:msonormal;
mso-margin-top-alt:auto;
margin-right:0in;
mso-margin-bottom-alt:auto;
margin-left:0in;
font-size:12.0pt;
font-family:"Times New Roman",serif;}
span.EmailStyle18
{mso-style-type:personal;
font-family:"Calibri",sans-serif;
color:windowtext;}
span.EmailStyle19
{mso-style-type:personal;
font-family:"Calibri",sans-serif;
color:#1F497D;}
span.EmailStyle20
{mso-style-type:personal-reply;
font-family:"Calibri",sans-serif;
color:#1F497D;}
.MsoChpDefault
{mso-style-type:export-only;
font-size:10.0pt;}
@page WordSection1
{size:8.5in 11.0in;
margin:70.85pt 70.85pt 70.85pt 70.85pt;}
div.WordSection1
{page:WordSection1;}
--></style><!--[if gte mso 9]><xml>
<o:shapedefaults v:ext="edit" spidmax="1026" />
</xml><![endif]--><!--[if gte mso 9]><xml>
<o:shapelayout v:ext="edit">
<o:idmap v:ext="edit" data="1" />
</o:shapelayout></xml><![endif]--></head><body lang=EN-US link="#0563C1" vlink="#954F72"><div class=WordSection1><p class=MsoNormal><span style='color:#1F497D'>I would say you probably don’t need it unless restoring from really old system.<o:p></o:p></span></p><p class=MsoNormal><span style='color:#1F497D'><o:p> </o:p></span></p><p class=MsoNormal><span style='color:#1F497D'>Are you restoring from a PostGIS 1.5 or PostGIS 2.0?<o:p></o:p></span></p><p class=MsoNormal><span style='color:#1F497D'><o:p> </o:p></span></p><p class=MsoNormal><span style='color:#1F497D'>Even with those, it should be sufficient if your database was created with scripts instead of extension to first<o:p></o:p></span></p><p class=MsoNormal><span style='color:#1F497D'><o:p> </o:p></span></p><p class=MsoNormal><span style='color:#1F497D'>1) CREATE EXTENSION postgis; <o:p></o:p></span></p><p class=MsoNormal><span style='color:#1F497D'><o:p> </o:p></span></p><p class=MsoNormal><span style='color:#1F497D'>--if your old backup is not in public, you may need to specify the schema like so replace SCHEMA postgis with SCHEMA name_of_schema_you_installed_postgis_in<o:p></o:p></span></p><p class=MsoNormal><span style='color:#1F497D'>CREATE EXTENSION postgis SCHEMA postgis;<o:p></o:p></span></p><p class=MsoNormal><span style='color:#1F497D'><o:p> </o:p></span></p><p class=MsoNormal><span style='color:#1F497D'><o:p> </o:p></span></p><p class=MsoNormal><span style='color:#1F497D'>CREATE EXTENSION postgis_topology;<o:p></o:p></span></p><p class=MsoNormal><span style='color:#1F497D'><o:p> </o:p></span></p><p class=MsoNormal><span style='color:#1F497D'>2) Use pg_restore to restore your backup (or psql if it’s a plain text backup)<o:p></o:p></span></p><p class=MsoNormal><span style='color:#1F497D'><o:p> </o:p></span></p><p class=MsoNormal><span style='color:#1F497D'><o:p> </o:p></span></p><div style='border:none;border-left:solid blue 1.5pt;padding:0in 0in 0in 4.0pt'><div><div style='border:none;border-top:solid #E1E1E1 1.0pt;padding:3.0pt 0in 0in 0in'><p class=MsoNormal><b>From:</b> postgis-users [mailto:postgis-users-bounces@lists.osgeo.org] <b>On Behalf Of </b>Alain Benard<br><b>Sent:</b> Friday, June 25, 2021 2:20 AM<br><b>To:</b> postgis-users@lists.osgeo.org<br><b>Subject:</b> [postgis-users] TR: postgis_restore.pl<o:p></o:p></p></div></div><p class=MsoNormal><o:p> </o:p></p><p class=MsoNormal><span lang=FR>Hi ,<span style='color:#1F497D'><o:p></o:p></span></span></p><p class=MsoNormal><span lang=FR>Because of problem with Postgres 12 / Postgis 2.5.5 on Centos 8 we test to install Postgres 12 / Postgis 3.0.<o:p></o:p></span></p><p class=MsoNormal><span lang=FR>In the pats i have used your script postgis_restore.pl and this script is again present in the directory /usr/pgsql-12/share/contrib/postgis-3.0/. In this script i find :<o:p></o:p></span></p><p class=MsoNormal style='margin-left:35.4pt'><span lang=FR># # Copyright (C) 2009 Paul Ramsey <<a href="mailto:pramsey@cleverelephant.ca">pramsey@cleverelephant.ca</a>><o:p></o:p></span></p><p class=MsoNormal style='margin-left:35.4pt'><span lang=FR># Tested on:<o:p></o:p></span></p><p class=MsoNormal style='margin-left:35.4pt'><span lang=FR>#<o:p></o:p></span></p><p class=MsoNormal style='margin-left:35.4pt'><span lang=FR># pg-8.4.9/pgis-1.4.3 => pg-8.4.9/pgis-2.0.0SVN<o:p></o:p></span></p><p class=MsoNormal style='margin-left:35.4pt'><span lang=FR># pg-8.4.9/pgis-2.0.0SVN => pg-8.4.9/pgis-2.0.0SVN<o:p></o:p></span></p><p class=MsoNormal style='margin-left:35.4pt'><span lang=FR># pg-8.4.9/pgis-2.0.0SVN => pg-9.1.2/pgis-2.0.0SVN<o:p></o:p></span></p><p class=MsoNormal style='margin-left:35.4pt'><span lang=FR># pg-9.1b3/pgis-1.5.3 => pg-9.1.1/pgis-2.0.0SVN<o:p></o:p></span></p><p class=MsoNormal><span lang=FR>On the server postgis 2.5.5 i dump with –Fc and on the new (Postgis3) i use the script with some mistakes :<o:p></o:p></span></p><p class=MsoNormal style='margin-left:35.4pt'><span lang=FR>ERREUR: la relation « geometry_columns » n'existe pas<o:p></o:p></span></p><p class=MsoNormal style='margin-left:35.4pt'><span lang=FR>LIGNE 1 : UPDATE topology.topology t set srid = g.srid FROM geometry_c...<o:p></o:p></span></p><p class=MsoNormal style='margin-left:35.4pt'><span lang=FR> ^<o:p></o:p></span></p><p class=MsoNormal style='margin-left:35.4pt'><span lang=FR>ERREUR: la relation « spatial_ref_sys » n'existe pas<o:p></o:p></span></p><p class=MsoNormal style='margin-left:35.4pt'><span lang=FR>LIGNE 1 : UPDATE spatial_ref_sys o set auth_name = n.auth_name, auth_s...<o:p></o:p></span></p><p class=MsoNormal style='margin-left:35.4pt'><span lang=FR> ^<o:p></o:p></span></p><p class=MsoNormal style='margin-left:35.4pt'><span lang=FR>ERREUR: la relation « spatial_ref_sys » n'existe pas<o:p></o:p></span></p><p class=MsoNormal style='margin-left:35.4pt'><span lang=FR>LIGNE 1 : INSERT INTO spatial_ref_sys SELECT * FROM _pgis_restore_spat...<o:p></o:p></span></p><p class=MsoNormal style='margin-left:35.4pt'><span lang=FR> ^<o:p></o:p></span></p><p class=MsoNormal style='margin-left:35.4pt'><span lang=FR>ERREUR: la relation « spatial_ref_sys » n'existe pas<o:p></o:p></span></p><p class=MsoNormal style='margin-left:35.4pt'><span lang=FR>ERREUR: la relation « spatial_ref_sys » n'existe pas<o:p></o:p></span></p><p class=MsoNormal style='margin-left:35.4pt'><span lang=FR>ERREUR: la relation « spatial_ref_sys » n'existe pas <o:p></o:p></span></p><p class=MsoNormal><span lang=FR>It seems that the restore is ok but what is your opinion about using th<span style='color:#1F497D'>i</span>s perl script today ??<o:p></o:p></span></p><p class=MsoNormal><span lang=FR>Thank you for advance.<o:p></o:p></span></p><p class=MsoNormal><span lang=FR>Alain.<o:p></o:p></span></p><table class=MsoNormalTable border=0 cellspacing=0 cellpadding=0><tr><td style='padding:0in 0in 0in 0in'><p class=MsoNormal><img border=0 width=147 height=60 id="AutoShape_x0020_1" src="cid:image001.png@01D76B5B.3425AFC0" alt=INRA><span style='font-size:13.5pt;font-family:"Times New Roman",serif;color:black;mso-fareast-language:FR'><o:p></o:p></span></p></td></tr><tr><td style='padding:0in 0in 0in 57.75pt'><table class=MsoNormalTable border=1 cellspacing=0 cellpadding=0 style='border-top:solid #999999 1.0pt;border-left:none;border-bottom:solid #999999 1.0pt;border-right:none'><tr style='height:6.0pt'><td width=195 style='width:2.0in;border:none;padding:0in 0in 0in 0in;height:6.0pt'><p class=MsoNormal><span style='font-size:12.0pt;font-family:"Times New Roman",serif;mso-fareast-language:FR'> <o:p></o:p></span></p></td></tr><tr><td valign=top style='border:none;padding:0in 0in 0in 0in'><p class=MsoNormal><b><span style='font-size:10.0pt;font-family:"Arial",sans-serif;color:#00A3A6;mso-fareast-language:FR'>Alain BENARD</span></b><span style='font-size:12.0pt;font-family:"Times New Roman",serif;mso-fareast-language:FR'><o:p></o:p></span></p></td></tr><tr><td valign=top style='border:none;padding:0in 0in 0in 0in'><p class=MsoNormal><b><span style='font-size:7.5pt;font-family:"Arial",sans-serif;mso-fareast-language:FR'>Administrateur Systèmes d’Information</span></b><span style='font-size:12.0pt;font-family:"Times New Roman",serif;mso-fareast-language:FR'><o:p></o:p></span></p></td></tr><tr style='height:.25in'><td style='border:none;padding:0in 0in 0in 0in;height:.25in'><p class=MsoNormal><u><span style='font-size:10.0pt;font-family:"Arial",sans-serif;color:#00A3A6;mso-fareast-language:FR'><a href="mailto:alain.benard@inra.fr"><span style='color:blue'>alain.benard@inra.fr</span></a></span></u><span style='font-size:12.0pt;font-family:"Times New Roman",serif;mso-fareast-language:FR'><o:p></o:p></span></p></td></tr><tr style='height:12.0pt'><td valign=top style='border:none;padding:0in 0in 0in 0in;height:12.0pt'><p class=MsoNormal><b><span style='font-size:7.5pt;font-family:"Arial",sans-serif;color:#00A3A6;mso-fareast-language:FR'>Unité SILVA</span></b><span style='font-size:12.0pt;font-family:"Times New Roman",serif;mso-fareast-language:FR'><o:p></o:p></span></p></td></tr><tr style='height:15.0pt'><td valign=top style='border:none;padding:0in 0in 0in 0in;height:15.0pt'><p class=MsoNormal><span style='font-size:7.5pt;font-family:"Arial",sans-serif;color:black;mso-fareast-language:FR'>Tél. : +33 3 83 39 40 84</span><span style='font-size:12.0pt;font-family:"Times New Roman",serif;mso-fareast-language:FR'><o:p></o:p></span></p></td></tr><tr><td style='border:none;padding:0in 0in 0in 0in'></td></tr></table></td></tr><tr><td style='padding:0in 0in 0in 57.75pt'><table class=MsoNormalTable border=0 cellspacing=0 cellpadding=0><tr style='height:12.0pt'><td valign=bottom style='padding:0in 0in 0in 0in;height:12.0pt'><p class=MsoNormal><span style='font-size:7.5pt;font-family:"Arial",sans-serif;color:black;mso-fareast-language:FR'>Route d’amance </span><span style='font-size:12.0pt;font-family:"Times New Roman",serif;mso-fareast-language:FR'><o:p></o:p></span></p></td></tr><tr><td valign=bottom style='padding:0in 0in 0in 0in'><p class=MsoNormal><span style='font-size:7.5pt;font-family:"Arial",sans-serif;color:black;mso-fareast-language:FR'>54 280 Champenoux</span><span style='font-size:12.0pt;font-family:"Times New Roman",serif;mso-fareast-language:FR'><o:p></o:p></span></p></td></tr><tr style='height:12.0pt'><td valign=top style='padding:0in 0in 0in 0in;height:12.0pt'><p class=MsoNormal><span style='font-size:7.5pt;font-family:"Arial",sans-serif;color:#00A3A6;mso-fareast-language:FR'><a href="http://www.inra.fr"><span style='color:#00A3A6'>inra.fr</span></a></span><span style='font-size:12.0pt;font-family:"Times New Roman",serif;mso-fareast-language:FR'><o:p></o:p></span></p></td></tr></table></td></tr></table><p class=MsoNormal><span lang=FR style='font-size:12.0pt;font-family:"Times New Roman",serif;display:none;mso-fareast-language:FR'><o:p> </o:p></span></p><table class=MsoNormalTable border=0 cellspacing=0 cellpadding=0><tr><td style='padding:0in 0in 0in 0in'><p class=MsoNormal><img border=0 width=32 height=32 id="AutoShape_x0020_2" src="cid:image002.png@01D76B5B.3425AFC0" alt=INRA><span style='font-size:13.5pt;font-family:"Times New Roman",serif;color:black;mso-fareast-language:FR'><o:p></o:p></span></p></td></tr><tr><td style='padding:0in 0in 0in 0in'></td></tr></table><p class=MsoNormal><span lang=FR style='mso-fareast-language:FR'><o:p> </o:p></span></p><p class=MsoNormal><span lang=FR><o:p> </o:p></span></p></div></div></body></html>