[postgis-users] While restoring the backup file few layers are missing on PostgreSQL database

[Pradeep Kanth G]

Dear All,

 

Can you please help me, While restoring the backup file few layers are
missing on PostgreSQL database.

I have followed the below steps and let us know how to overcome this issue.

 

Followed Process:

 

1.	Create a backup with individual schema and also tried with full
database backup
2.	Created a new database with same name like source database and
executed alter database sde set search_path = E'\$user',public,sde; on
target database.
3.	Give the same permission on Target database same as source database.
4.	Copied the Library files into Target database.
5.	Restore the contents of the public after that sde schema.
6.	Restore the entire database for all schemas(Except public & sde
schema)
7.	While restoring the backup file, we are getting the below yellow
highlighted error messages.

 

pg_restore: [archiver (db)] COPY failed for table "******": ERROR:  Invalid
geometry

HINT:
"000200005000000004000C00E6100000A807000001000000B3969A98FA1B84C4F7EADE17E0A
F02C08650EA36EDB40ECFC60EF1A09A02EA960AFDB77CD49D01E1830FE6DC05FBC83FDEE304C
2E49801BE04DC309A4BCDE005BB8C03C6A31E88B010E4F09F01A88F14CFB5D20196B204CDA82
58DFC0CFDC46AA8A002F0E215A9A002EFE21582EA02D38D1983B640EF929201AF921EE6D729B
E9A1BC0D025858848DE9058A5B022FA984093B01BE7EA5296BC03DAC00AA9B309C8CC21B5A41
0CD983A9F8E05EAFF12A2E814F7AB4DAEF70CE987308F8704D1890FA2B110C7AB43B1A103EBB
40DB3881DDDFE6493E70BDA8229A39901DC9504BDC60DCDB034A58D0DE5D232ABC22BE0C7BA0
186FB0CFCC023A1F102E1810AA0B316F3D84DB6AC14FAC53181F001F2C90489C113DFFE2DA38
F08C49A1388B117E1B9298CE02EEBDF458DC407C2DB0A82B82AC5AC3C8DE40FD8941A9EBE13C
CC52596F402D2CD0587A111E89B2AABE10AF6F920BEFF06E8E121A68407FAF721A58407FAF72
185B805FD833185B904FA8A28AF9F07C4D1DA01A29707D6DBA501AED813DDFA74BAEB1EDBEB6
29C9008D9E90C93B920C99833868948D1AA5EBFD307E9820A899320EA831984D25DC8C73EAD8
B3CCBDF22B1864AE1F81F96EC30CDDD1F95D113E1E00C85D415F59211ACD319F9A7148D8E01E
5708D8E01E670BFFA12E6810FAFBE5AE68251" <-- error in parsing the source
string

CONTEXT:  COPY *****, line 683, column shape:
"000200005000000004000C00E6100000A807000001000000B3969A98FA1B84C4F7EADE17E0A
F02C08650EA36EDB40ECFC60E..."

 

Note: While copying the feature classes through ArcCatalog from source to
target database, we have not seen any errors.

Software's: ArcGIS 10.5  

Database : PostgreSQL 9.5.3 with PostGIS 2.3.0

 

Regards

Pradeep 

 



Disclaimer | 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.



-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20180706/23abb0b7/attachment.html>