<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 HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=us-ascii"><meta name=Generator content="Microsoft Word 15 (filtered medium)"><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;}
@font-face
{font-family:Consolas;
panose-1:2 11 6 9 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.MsoPlainText, li.MsoPlainText, div.MsoPlainText
{mso-style-priority:99;
mso-style-link:"Plain Text Char";
margin:0in;
margin-bottom:.0001pt;
font-size:11.0pt;
font-family:"Calibri",sans-serif;}
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:11.0pt;
font-family:"Calibri",sans-serif;}
span.PlainTextChar
{mso-style-name:"Plain Text Char";
mso-style-priority:99;
mso-style-link:"Plain Text";
font-family:"Calibri",sans-serif;}
span.EmailStyle20
{mso-style-type:personal;
font-family:"Calibri",sans-serif;
color:windowtext;}
span.EmailStyle21
{mso-style-type:personal-reply;
font-family:"Calibri",sans-serif;
color:windowtext;}
.MsoChpDefault
{mso-style-type:export-only;
font-size:10.0pt;}
@page WordSection1
{size:8.5in 11.0in;
margin:1.0in 1.0in 1.0in 1.0in;}
div.WordSection1
{page:WordSection1;}
/* List Definitions */
@list l0
{mso-list-id:1072387599;
mso-list-type:hybrid;
mso-list-template-ids:-2118490610 67698705 67698713 67698715 67698703 67698713 67698715 67698703 67698713 67698715;}
@list l0:level1
{mso-level-text:"%1\)";
mso-level-tab-stop:none;
mso-level-number-position:left;
text-indent:-.25in;}
@list l0:level2
{mso-level-number-format:alpha-lower;
mso-level-tab-stop:none;
mso-level-number-position:left;
text-indent:-.25in;}
@list l0:level3
{mso-level-number-format:roman-lower;
mso-level-tab-stop:none;
mso-level-number-position:right;
text-indent:-9.0pt;}
@list l0:level4
{mso-level-tab-stop:none;
mso-level-number-position:left;
text-indent:-.25in;}
@list l0:level5
{mso-level-number-format:alpha-lower;
mso-level-tab-stop:none;
mso-level-number-position:left;
text-indent:-.25in;}
@list l0:level6
{mso-level-number-format:roman-lower;
mso-level-tab-stop:none;
mso-level-number-position:right;
text-indent:-9.0pt;}
@list l0:level7
{mso-level-tab-stop:none;
mso-level-number-position:left;
text-indent:-.25in;}
@list l0:level8
{mso-level-number-format:alpha-lower;
mso-level-tab-stop:none;
mso-level-number-position:left;
text-indent:-.25in;}
@list l0:level9
{mso-level-number-format:roman-lower;
mso-level-tab-stop:none;
mso-level-number-position:right;
text-indent:-9.0pt;}
@list l1
{mso-list-id:1834879101;
mso-list-template-ids:-1865644278;}
ol
{margin-bottom:0in;}
ul
{margin-bottom:0in;}
--></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>Dear All,<o:p></o:p></p><p class=MsoNormal><o:p> </o:p></p><p class=MsoPlainText>Can you please help me, While restoring the backup file few layers are missing on PostgreSQL database.<o:p></o:p></p><p class=MsoPlainText>I have followed the below steps and let us know how to overcome this issue.<o:p></o:p></p><p class=MsoPlainText><o:p> </o:p></p><p class=MsoNormal><b><u>Followed Process:<o:p></o:p></u></b></p><p class=MsoNormal><b><u><o:p><span style='text-decoration:none'> </span></o:p></u></b></p><ol style='margin-top:0in' start=1 type=1><li class=MsoNormal style='mso-list:l0 level1 lfo3'>Create a backup with individual schema and also tried with full database backup<o:p></o:p></li><li class=MsoNormal style='mso-list:l0 level1 lfo3'>Created a new database with same name like source database and executed <span style='font-size:9.0pt;font-family:Consolas;color:black;background:white'>alter database sde set search_path = E'\$user',public,sde; </span>on target database.<o:p></o:p></li><li class=MsoNormal style='mso-list:l0 level1 lfo3'>Give the same permission on Target database same as source database.<o:p></o:p></li><li class=MsoNormal style='mso-list:l0 level1 lfo3'>Copied the Library files into Target database.<o:p></o:p></li><li class=MsoNormal style='mso-list:l0 level1 lfo3'>Restore the contents of the public after that sde schema.<o:p></o:p></li><li class=MsoNormal style='mso-list:l0 level1 lfo3'>Restore the entire database for all schemas(Except public & sde schema)<o:p></o:p></li><li class=MsoNormal style='mso-list:l0 level1 lfo3'>While restoring the backup file, we are getting the below yellow highlighted error messages.<o:p></o:p></li></ol><p class=MsoPlainText style='margin-left:.5in'><o:p> </o:p></p><p class=MsoPlainText style='margin-left:.5in'><span style='background:yellow;mso-highlight:yellow'>pg_restore: [archiver (db)] COPY failed for table "******": ERROR: Invalid geometry<o:p></o:p></span></p><p class=MsoPlainText style='margin-left:.5in'><span style='background:yellow;mso-highlight:yellow'>HINT: "000200005000000004000C00E6100000A807000001000000B3969A98FA1B84C4F7EADE17E0AF02C08650EA36EDB40ECFC60EF1A09A02EA960AFDB77CD49D01E1830FE6DC05FBC83FDEE304C2E49801BE04DC309A4BCDE005BB8C03C6A31E88B010E4F09F01A88F14CFB5D20196B204CDA8258DFC0CFDC46AA8A002F0E215A9A002EFE21582EA02D38D1983B640EF929201AF921EE6D729BE9A1BC0D025858848DE9058A5B022FA984093B01BE7EA5296BC03DAC00AA9B309C8CC21B5A410CD983A9F8E05EAFF12A2E814F7AB4DAEF70CE987308F8704D1890FA2B110C7AB43B1A103EBB40DB3881DDDFE6493E70BDA8229A39901DC9504BDC60DCDB034A58D0DE5D232ABC22BE0C7BA0186FB0CFCC023A1F102E1810AA0B316F3D84DB6AC14FAC53181F001F2C90489C113DFFE2DA38F08C49A1388B117E1B9298CE02EEBDF458DC407C2DB0A82B82AC5AC3C8DE40FD8941A9EBE13CCC52596F402D2CD0587A111E89B2AABE10AF6F920BEFF06E8E121A68407FAF721A58407FAF72185B805FD833185B904FA8A28AF9F07C4D1DA01A29707D6DBA501AED813DDFA74BAEB1EDBEB629C9008D9E90C93B920C99833868948D1AA5EBFD307E9820A899320EA831984D25DC8C73EAD8B3CCBDF22B1864AE1F81F96EC30CDDD1F95D113E1E00C85D415F59211ACD319F9A7148D8E01E5708D8E01E670BFFA12E6810FAFBE5AE68251" <-- error in parsing the source string<o:p></o:p></span></p><p class=MsoPlainText style='margin-left:.5in'><span style='background:yellow;mso-highlight:yellow'>CONTEXT: COPY *****, line 683, column shape: "000200005000000004000C00E6100000A807000001000000B3969A98FA1B84C4F7EADE17E0AF02C08650EA36EDB40ECFC60E..."</span><o:p></o:p></p><p class=MsoPlainText style='margin-left:.5in'><o:p> </o:p></p><p class=MsoNormal><b><u>Note: </u></b>While copying the feature classes through ArcCatalog from source to target database, we have not seen any errors.<b><u><o:p></o:p></u></b></p><p class=MsoNormal><b><u>Software’s:</u></b> ArcGIS 10.5 <o:p></o:p></p><p class=MsoNormal><b><u>Database : </u></b>PostgreSQL 9.5.3 with PostGIS 2.3.0<o:p></o:p></p><p class=MsoNormal><o:p> </o:p></p><p class=MsoNormal><span style='color:black'>Regards<o:p></o:p></span></p><p class=MsoNormal><span style='color:black'>Pradeep <o:p></o:p></span></p><p class=MsoNormal><o:p> </o:p></p></div><BR />
<BR />
<div align="left"><b>Disclaimer </b>| The information contained in this electronic message (including any attachments) is intended for the exclusive use of the addressee(s) and may contain confidential or privileged information.If you have received this in error, please notify the sender immediately and delete the material from your machine. Any action including review, retransmission, dissemination of this email or the attachments present along with the email by persons or entities other than the intended recipient is prohibited.<br></div><br><br><BR />
</body></html>