PolarDB：GanosBase外掛程式如何升級

阿里雲時空資料庫GanosBase外掛程式在描述中進行標識。您可以通過如下方法快速找到已安裝的GanosBase外掛程式並升級。

1. 使用PostgreSQL命令列工具串連資料庫。

2. 使用\dx命令查看外掛程式列表。

   結果樣本：

                                                                             List of installed extensions
                   Name                | Version |   Schema   |                                                     Description
   ------------------------------------+---------+------------+---------------------------------------------------------------------------------------------------------------------
    address_standardizer               | 2.5.4   | public     | Ganos PostGIS+ address standardizer
    address_standardizer_data_us       | 2.5.4   | public     | Ganos PostGIS+ address standardizer data us
    ganos_address_standardizer         | 4.1     | public     | Used to parse an address into constituent elements. Generally used to support geocoding address normalization step.
    ganos_address_standardizer_data_us | 4.1     | public     | Address Standardizer US dataset example
    ganos_geometry                     | 4.1     | public     | Ganos geometry extension for PostgreSQL
    ganos_geometry_sfcgal              | 4.1     | public     | Ganos geometry SFCGAL functions extension for PostgreSQL
    ganos_geometry_topology            | 4.1     | topology   | Ganos geometry topology spatial types and functions extension for PostgreSQL
    ganos_networking                   | 4.1     | public     | Ganos networking extension for PostgreSQL
    ganos_spatialref                   | 4.1     | public     | Ganos spatial reference extension for PostgreSQL
    ganos_tiger_geocoder               | 4.1     | tiger      | Ganos tiger geocoder and reverse geocoder
    plpgsql                            | 1.0     | pg_catalog | PL/pgSQL procedural language
    postgis                            | 2.5.4   | public     | Ganos PostGIS+
    postgis_sfcgal                     | 2.5.4   | public     | Ganos PostGIS+
    postgis_tiger_geocoder             | 2.5.4   | public     | Ganos PostGIS+ tiger geocoder
    postgis_topology                   | 2.5.4   | public     | Ganos PostGIS+ topology
                           

3. 通過Description列的描述資訊擷取已安裝的GanosBase外掛程式。

   說明

   如果描述中包含Ganos，則表示是GanosBase外掛程式。

4. 升級GanosBase外掛程式。

   • 如果您的GanosBase外掛程式版本大於等於3.1，請使用如下語句對全部GanosBase外掛程式進行升級。

     SELECT ganos_update();

   • 如果您的GanosBase外掛程式版本小於3.1，請參考如下命令，手動建立函數對全部GanosBase外掛程式進行升級。

     CREATE OR REPLACE FUNCTION ganos_update()
         RETURNS text AS
     $$
     DECLARE
         rec RECORD;
         sql text;
     BEGIN
         FOR rec IN
             SELECT extname
             FROM pg_extension
             WHERE extname like 'ganos_%'
             LOOP
                 sql = 'ALTER EXTENSION '
                     || rec.extname
                     || ' UPDATE ';
                 RAISE NOTICE '%', sql;
                 EXECUTE sql;
     
             END LOOP;
     
         return 'All Ganos extensions have updated to latest version';
     
     END
     $$ LANGUAGE 'plpgsql' volatile STRICT;

   說明

   GanosBase外掛程式與其他外掛程式的升級方式不同，其他外掛程式升級方式如下：

   ALTER EXTENSION <外掛程式名> UPDATE;