<div dir="ltr"><div><div>Paul suggested offlist that I try dropping the pointcloud_formats table and re-creating it adding a DISTRIBUTE BY REPLICATION clause. I wasn't able to do this from the console but managed to kludge it into a working state by editing pgsql/sql/pointcloud.sql and rebuilding and reloading the pointcloud extension.<br><br>The thing is, that tables in Postgres-XL do (usually) get distributed by default,
by one mechanism or another, if no DISTRIBUTE BY clause is specified:<br><br>"If <tt class="">DISTRIBUTE BY</tt> is not specified, columns with
UNIQUE constraint will be chosen as the distribution key. If no
such column is specified, distribution column is the first
eligible column in the definition. If no such column is found,
then the table will be distributed by <tt class="">ROUNDROBIN</tt>."
<br><br><a href="http://files.postgres-xl.org/documentation/sql-createtable.html">http://files.postgres-xl.org/documentation/sql-createtable.html</a><br><br>So
i can create tables via ogr2ogr for example, and that works as expected
as with regular postgres and i see the records being distributed around
the data nodes. When I CREATE EXTENSION postgis on a coordinator node the tables and functions get propagated to the data nodes.<br><br></div><div>I am still getting to grips with Postgres-XL, my understanding is weak and I and still do not see why this particular table wasnt getting distributed, something to do with the order of the CHECK constraint and the function which it is calling? <br><br></div><div>Anyway, at least with this kludge I am now able to test out PDAL :) If I arrive at a better understanding or a solution I will certainly let you know.<br><br></div><div><br></div><div>cheers,<br></div><br><br></div>Jo<br><br></div><div class="gmail_extra"><br><div class="gmail_quote">On Mon, May 30, 2016 at 3:02 PM, Rémi Cura <span dir="ltr"><<a href="mailto:remi.cura@gmail.com" target="_blank">remi.cura@gmail.com</a>></span> wrote:<br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"><div dir="ltr"><div class="gmail_default" style="font-family:monospace,monospace">Hey,<br></div><div class="gmail_default" style="font-family:monospace,monospace">I often wondered if pgpointcloud would work with postgresXL.<br></div><div class="gmail_default" style="font-family:monospace,monospace"><br></div><div class="gmail_default" style="font-family:monospace,monospace">I don't have any knwoledge of postgresxl,<br></div><div class="gmail_default" style="font-family:monospace,monospace">but I would be very gratefull if you could keep us posted!<br><br></div><div class="gmail_default" style="font-family:monospace,monospace">Cheers,<br></div><div class="gmail_default" style="font-family:monospace,monospace">Rémi-C<br></div></div><div class="gmail_extra"><br><div class="gmail_quote"><div><div class="h5">2016-05-30 11:49 GMT+02:00 Jo Walsh <span dir="ltr"><<a href="mailto:metazool@gmail.com" target="_blank">metazool@gmail.com</a>></span>:<br></div></div><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"><div><div class="h5"><div dir="ltr"><pre style="margin-top:0px;margin-bottom:0px;padding:15px;border-width:0px 0px 0px 1px;border-left-style:solid;border-left-color:rgb(229,229,229);outline:0px;vertical-align:baseline;word-wrap:break-word;overflow:auto;background-image:initial;background-repeat:initial"><font face="monospace, sans-serif" color="#555555"><span style="font-size:13px;line-height:18px;white-space:pre-wrap">I wonder if anyone has tried out and had success with the PG Point Cloud
extension with Postgres-XL, the clustering version of Postgres? I am running through the basic
exercises and see it all almost, but not quite, working. I tried the Postgres-XL general list without any luck in response, so thought it worth re-posting here to see if it's something people have given thought to.</span></font></pre><pre style="margin-top:0px;margin-bottom:0px;padding:15px;border-width:0px 0px 0px 1px;border-left-style:solid;border-left-color:rgb(229,229,229);outline:0px;vertical-align:baseline;word-wrap:break-word;overflow:auto;background-image:initial;background-repeat:initial"><span style="font-size:13px;line-height:18px;white-space:pre-wrap;color:rgb(85,85,85);font-family:monospace,sans-serif"><a href="http://www.postgres-xl.org/overview/" target="_blank">http://www.postgres-xl.org/overview/</a></span></pre><pre style="margin-top:0px;margin-bottom:0px;padding:15px;border-width:0px 0px 0px 1px;border-left-style:solid;border-left-color:rgb(229,229,229);outline:0px;vertical-align:baseline;word-wrap:break-word;overflow:auto;background-image:initial;background-repeat:initial"><font face="monospace, sans-serif" color="#555555"><span style="font-size:13px;line-height:18px;white-space:pre-wrap">I am able to CREATE EXTENSION pointcloud on a Postgres-XL coordinator node
just as straightforwardly as with PostGIS, which works well. </span></font></pre><pre style="margin-top:0px;margin-bottom:0px;padding:15px;border-width:0px 0px 0px 1px;border-left-style:solid;border-left-color:rgb(229,229,229);outline:0px;vertical-align:baseline;word-wrap:break-word;overflow:auto;background-image:initial;background-repeat:initial"><font face="monospace, sans-serif" color="#555555"><span style="font-size:13px;line-height:18px;white-space:pre-wrap">However, the pgpointcloud creates a table pointcloud_formats which does not appear to be getting distributed.
The table looks like this:
testdb=# \d++ pointcloud_formats;
Table "public.pointcloud_formats"
Column | Type | Modifiers | Storage | Stats target | Description
--------+---------+-----------+----------+--------------+-------------
pcid | integer | not null | plain | |
srid | integer | | plain | |
schema | text | | extended | |
Indexes:
"pointcloud_formats_pkey" PRIMARY KEY, btree (pcid)
Check constraints:
"pointcloud_formats_pcid_check" CHECK (pcid > 0 AND pcid < 65536)
"pointcloud_formats_schema_check" CHECK (pc_schemaisvalid(schema))
When I INSERT into it, data does not end up stored in the datanodes, and
when I subsequently try to INSERT into the points table,
ERROR: no entry in "pointcloud_formats" for pcid = 1
Despite the fact that on the coordinator node I can SELECT from
pointcloud_formats and see a row with pcid=1. </span></font></pre><pre style="margin-top:0px;margin-bottom:0px;padding:15px;border-width:0px 0px 0px 1px;border-left-style:solid;border-left-color:rgb(229,229,229);outline:0px;vertical-align:baseline;word-wrap:break-word;overflow:auto;background-image:initial;background-repeat:initial"><font face="monospace, sans-serif" color="#555555"><span style="font-size:13px;line-height:18px;white-space:pre-wrap">There's more context including log entries in my original post to the Postgres-XL list here:</span></font></pre><pre style="margin-top:0px;margin-bottom:0px;padding:15px;border-width:0px 0px 0px 1px;border-left-style:solid;border-left-color:rgb(229,229,229);outline:0px;vertical-align:baseline;word-wrap:break-word;overflow:auto;background-image:initial;background-repeat:initial"><span style="font-size:13px;line-height:18px;white-space:pre-wrap;color:rgb(85,85,85);font-family:monospace,sans-serif"><a href="https://sourceforge.net/p/postgres-xl/mailman/message/35119267/" target="_blank">https://sourceforge.net/p/postgres-xl/mailman/message/35119267/</a></span></pre><pre style="margin-top:0px;margin-bottom:0px;padding:15px;border-width:0px 0px 0px 1px;border-left-style:solid;border-left-color:rgb(229,229,229);outline:0px;vertical-align:baseline;word-wrap:break-word;overflow:auto;background-image:initial;background-repeat:initial"><font face="monospace, sans-serif" color="#555555"><span style="font-size:13px;line-height:18px;white-space:pre-wrap">I know this is a long shot but any illumination would be appreciated,</span></font></pre><pre style="margin-top:0px;margin-bottom:0px;padding:15px;border-width:0px 0px 0px 1px;border-left-style:solid;border-left-color:rgb(229,229,229);outline:0px;vertical-align:baseline;word-wrap:break-word;overflow:auto;background-image:initial;background-repeat:initial"><font face="monospace, sans-serif" color="#555555"><span style="font-size:13px;line-height:18px;white-space:pre-wrap">
Jo</span></font></pre><pre style="margin-top:0px;margin-bottom:0px;padding:15px;border-width:0px 0px 0px 1px;border-left-style:solid;border-left-color:rgb(229,229,229);outline:0px;vertical-align:baseline;word-wrap:break-word;overflow:auto;background-image:initial;background-repeat:initial"><font face="monospace, sans-serif" color="#555555"><span style="font-size:13px;line-height:18px;white-space:pre-wrap"><br></span></font></pre></div>
<br></div></div><span class="">_______________________________________________<br>
pgpointcloud mailing list<br>
<a href="mailto:pgpointcloud@lists.osgeo.org" target="_blank">pgpointcloud@lists.osgeo.org</a><br>
<a href="http://lists.osgeo.org/mailman/listinfo/pgpointcloud" rel="noreferrer" target="_blank">http://lists.osgeo.org/mailman/listinfo/pgpointcloud</a><br></span></blockquote></div><br></div>
</blockquote></div><br></div>