1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
|
.. _update:
******************************************************************************
Update
******************************************************************************
pgPointcloud extension
------------------------------------------------------------------------------
Once a new version of pgPointcloud installed, you may want to update your
databases where the extension is already in use. The first thing to compare is
the version currently used with versions actually available on your system:
.. code-block:: sql
SELECT pc_version();
--> 1.1.1
SELECT version FROM pg_available_extension_versions WHERE name ='pointcloud';
--> 1.1.1
--> 1.2.1
Then you can update to the latest version:
.. code-block:: sql
ALTER EXTENSION pointcloud;
ALTER EXTENSION pointcloud_postgis;
or target a specific version:
.. code-block:: sql
ALTER EXTENSION pointcloud UPDATE TO '1.2.1';
SELECT pc_version();
--> 1.2.1
.. warning::
The GHT compression has been removed in the 1.2.0 version. Unfortunately,
you have to remove the compression on your tables before updating the
extension from 1.1.x to a higher version. Some information are available in
the `Schema and compression`_ tutorial.
.. _`Schema and compression`: /https://pgpointcloud.github.io/pointcloud/tutorials/compression.html#schema-and-compression
|
