<div dir="ltr"><div class="gmail_default" style="font-family:monospace,monospace">Hey,<br></div><div class="gmail_default" style="font-family:monospace,monospace">in this case the fix seems obvious :<br></div><div class="gmail_default" style="font-family:monospace,monospace">you should first copy the content of <span style="line-height:1.5">"pointcloud_formats" before copying the points.<br></span></div><div class="gmail_default" style="font-family:monospace,monospace"><span style="line-height:1.5">I don't remember if there are options in pgdump to prioritize the tables to be dumped and copied.<br></span></div><div class="gmail_default" style="font-family:monospace,monospace"><span style="line-height:1.5"><br></span></div><div class="gmail_default" style="font-family:monospace,monospace"><span style="line-height:1.5">Indeed, </span><br><span style="line-height:1.5">pointcloud_formats is like the spatial_ref_sys postgis table, that is it defines the referential, therefore you need it to create the type of points you want.<br><br></span></div><div class="gmail_default" style="font-family:monospace,monospace"><span style="line-height:1.5">Cheers,<br></span></div><div class="gmail_default" style="font-family:monospace,monospace"><span style="line-height:1.5">Rémi-C<br></span></div></div><div class="gmail_extra"><br><div class="gmail_quote">2016-06-15 22:57 GMT+02:00 Jean-Francois Prieur <span dir="ltr"><<a href="mailto:jfprieur@gmail.com" target="_blank">jfprieur@gmail.com</a>></span>:<br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"><div dir="ltr">Hello,<div><br></div><div>Was not sure whether to post this here or PostGIS list, apologies if this is the wrong list!</div><div><br></div><div>We have a PostGIS database using pointcloud objects to store our lidar data.</div><div><br></div><div>I am trying to move the database to another server using</div><div><br></div>pg_dump -C -h localhost -U localuser dbname | psql -h remotehost -U remoteuser dbname<div><br></div><div>The connections work fine remotely and it starts creating the database (including the extensions), when it starts to copy the actual pointcloud entries, we get an error:</div><div><div><br></div><div><br></div><div>2016-06-15 16:33:59 EDT<span style="white-space:pre-wrap"> </span>LOG<span style="white-space:pre-wrap"> </span>Pointcloud (1.1.0) module loaded at character 53<span style="white-space:pre-wrap"> </span></div><div><div>2016-06-15 16:33:59 EDT<span style="white-space:pre-wrap"> </span>STATEMENT<span style="white-space:pre-wrap"> </span>CREATE TABLE crpt (<span style="white-space:pre-wrap"> </span></div><div><div><span style="white-space:pre-wrap"> </span> id integer NOT NULL,<span style="white-space:pre-wrap"> </span></div><div><div><span style="white-space:pre-wrap"> </span> pa pcpatch(1),<span style="white-space:pre-wrap"> </span></div><div><div><span style="white-space:pre-wrap"> </span> tree_id character varying<span style="white-space:pre-wrap"> </span></div><div><div><span style="white-space:pre-wrap"> </span>);<span style="white-space:pre-wrap"> </span></div><div style="line-height:1.5"><span style="line-height:1.5">2016-06-15 16:34:24 EDT</span><span style="line-height:1.5;white-space:pre-wrap"> </span><span style="line-height:1.5">ERROR</span><span style="line-height:1.5;white-space:pre-wrap"> </span><span style="line-height:1.5">no entry in "pointcloud_formats" for pcid = 1</span><span style="line-height:1.5;white-space:pre-wrap"> </span><br></div></div></div></div></div></div></div><div><div>2016-06-15 16:34:24 EDT<span style="white-space:pre-wrap"> </span>CONTEXT<span style="white-space:pre-wrap"> </span>COPY crpt, line 1, column pa: "0101000000020000007403000002E8030000090000006588634786E6FDF6237D42E0B460602D36A0D8B9D80E9DCB5D580D83..."<span style="white-space:pre-wrap"> </span></div></div><div><br></div><div><br></div><div>I have the feeling something is not being done in the correct order, a missing schema or something.</div><div><br></div><div>What is the proper procedure for copying a poincloud enabled database from one server to another?</div><div><br></div><div>Thanks,</div><div>JF</div></div>
<br>_______________________________________________<br>
pdal mailing list<br>
<a href="mailto:pdal@lists.osgeo.org">pdal@lists.osgeo.org</a><br>
<a href="http://lists.osgeo.org/mailman/listinfo/pdal" rel="noreferrer" target="_blank">http://lists.osgeo.org/mailman/listinfo/pdal</a><br></blockquote></div><br></div>