[pdal] PointCloud: Transferring database to different server

[Rémi Cura]

Hey,
in this case the fix seems obvious :
you should first copy the content of "pointcloud_formats" before copying
the points.
I don't remember if there are options in pgdump to prioritize the tables to
be dumped and copied.

Indeed,
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.

Cheers,
Rémi-C

2016-06-15 22:57 GMT+02:00 Jean-Francois Prieur <jfprieur at gmail.com>:

> 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
>
> _______________________________________________
> pdal mailing list
> pdal at lists.osgeo.org
> http://lists.osgeo.org/mailman/listinfo/pdal
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/pdal/attachments/20160616/e25eca66/attachment.html>