[pdal] PointCloud: Transferring database to different server

[Jean-Francois Prieur]

Hello,

Was not sure whether to post this here or PostGIS list, apologies if this
is the wrong list!

We have a PostGIS database using pointcloud objects to store our lidar data.

I am trying to move the database to another server using

pg_dump -C -h localhost -U localuser dbname | psql -h remotehost -U
remoteuser dbname

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:


2016-06-15 16:33:59 EDT LOG Pointcloud (1.1.0) module loaded at character 53
2016-06-15 16:33:59 EDT STATEMENT CREATE TABLE crpt (
   id integer NOT NULL,
   pa pcpatch(1),
   tree_id character varying
);
2016-06-15 16:34:24 EDT ERROR no entry in "pointcloud_formats" for pcid = 1
2016-06-15 16:34:24 EDT CONTEXT COPY crpt, line 1, column pa:
"0101000000020000007403000002E8030000090000006588634786E6FDF6237D42E0B460602D36A0D8B9D80E9DCB5D580D83..."


I have the feeling something is not being done in the correct order, a
missing schema or something.

What is the proper procedure for copying a poincloud enabled database from
one server to another?

Thanks,
JF
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/pdal/attachments/20160615/d97ad491/attachment.html>