[postgis-users] pg point cloud backup problem

Regina Obe lr at pcorp.us
Tue Sep 20 20:33:36 PDT 2022


One more update.  To patch your systems, make sure to copy the files in the
respective package into same named folders of your postgresql install.

This will usually be in C:\Program Files\PostgreSQL\<pg version here>\

Once you've copied the files, make sure to do

ALTER EXTENSION pointcloud UPDATE; 
ALTER EXTENSION pointcloud_postgis UPDATE;

In each database you have it installed.

> -----Original Message-----
> From: Regina Obe [mailto:lr at pcorp.us]
> Sent: Tuesday, September 20, 2022 11:31 PM
> To: 'PostGIS Users Discussion' <postgis-users at lists.osgeo.org>
> Subject: RE: [postgis-users] pg point cloud backup problem
> 
> I wrote this on IRC too, but will repeat for completeness.
> 
> I have the extensions for pgpointcloud built for PostgreSQL 11 - 14.  You
will
> find them in the respective extras folders here
> 
> https://winnie.postgis.net/download/windows/
> 
> So for example, the package for PG14 is -
> https://winnie.postgis.net/download/windows/pg14/buildbot/extras/pointc
> loud-pg14-binaries-1.2.3w64gcc81.zip
> 
> PG15 I don't have yet because the fix for PG15 hasn't been tagged yet,
> though it is fixed in master branch.
> 
> 
> 
> 
> 
> > -----Original Message-----
> > From: Regina Obe [mailto:lr at pcorp.us]
> > Sent: Tuesday, September 20, 2022 1:41 PM
> > To: 'PostGIS Users Discussion' <postgis-users at lists.osgeo.org>
> > Subject: RE: [postgis-users] pg point cloud backup problem
> >
> > I'll have 1.2.3 in next release.  I'll try to push that out this coming
weekend.
> >
> > Thanks,
> > Regina
> >
> > > -----Original Message-----
> > > From: postgis-users [mailto:postgis-users-bounces at lists.osgeo.org]
> > > On Behalf Of ????? ????????
> > > Sent: Tuesday, September 20, 2022 1:02 PM
> > > To: postgis-users at lists.osgeo.org
> > > Subject: [postgis-users] pg point cloud backup problem
> > >
> > > There is an "old" problem with pg point cloud db dump/restore
> > > https://github.com/pgpointcloud/pointcloud/issues/197
> > >
> > > It looks like it was fixed but it is not included in postgis windows
> > > distribution yet What version of pg pc will be included in next
> > > postgis and
> > when?
> > >
> > > SELECT pc_version(), PostGIS_Version()
> > > >"1.2.1" "3.2 USE_GEOS=1 USE_PROJ=1 USE_STATS=1"
> > >
> > > Pavel
> > > _______________________________________________
> > > postgis-users mailing list
> > > postgis-users at lists.osgeo.org
> > > https://lists.osgeo.org/mailman/listinfo/postgis-users



More information about the postgis-users mailing list