RDS PG10 - PG11 Upgrade Fails, Missing libraries, How do I read loadable_libraries.txt, How do I install libraries.

Question

Error from the log.

From PG_upgrade_Internal.log

Checking for presence of required libraries                 fatal
Your installation references loadable libraries that are missing from the
new installation.  You can add these libraries to the new installation,
or remove the functions using them from the old installation.  A list of
problem libraries is in the file:
    loadable_libraries.txt

From PG_upgrade_Server.log

2023-07-08 04:00:22.642 GMT [21983] WARNING:  'postgis.gdal_datapath' is already set and cannot be changed until you reconnect
2023-07-08 04:00:22.642 GMT [21983] WARNING:  'postgis.gdal_enabled_drivers' is already set and cannot be changed until you reconnect
2023-07-08 04:00:22.642 GMT [21983] WARNING:  'postgis.enable_outdb_rasters' is already set and cannot be changed until you reconnect
ERROR 6: Seek not supported on writable /vsis3 files

I have already ran:

```
alter extension postgis update to '3.1.5';

SELECT postgis_extensions_upgrade();
```

On every database, and **I have also manually rebooted the RDS**.

I found  **[ THIS ](https://stackoverflow.com/questions/70241319/postgres-upgrade-from-10-to-12-pg-upgrade-fail-for-presence-of-required-library)** on stack overflow, and the solution worked but requires terminal access.

`SELECT * FROM pg_extension;`

Returns:

plpgsql 1.0

postgis 3.1.5

postgis_raster 3.1.5

`SELECT postgis_extensions_upgrade();`

Returns:

Extension postgis_topology is not available or not packagable for some reason

Extension postgis_tiger_geocoder is not available or not packagable for some reason

I received this output on my test RDS, (which is an exact copy of the current RDS I'm working with), and it upgraded without any issues

Jose Guay · Answer

Hi Pontem.

Please check the following commands to upgrade your extensions:

```
ALTER EXTENSION extension_name UPDATE TO 'new_version';
```

For the list of supported versions of PostgreSQL extensions, see [Supported PostgreSQL extension versions](https://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/CHAP_PostgreSQL.html#PostgreSQL.Concepts.General.FeatureSupport.Extensions).

**To list your currently installed extensions**, use the PostgreSQL [pg_extension](https://www.postgresql.org/docs/current/catalog-pg-extension.html) catalog in the following command.

```
SELECT * FROM pg_extension;
```

To view a list of the specific extension versions that are available for your installation, use the PostgreSQL [pg_available_extension_versions](https://www.postgresql.org/docs/current/view-pg-available-extension-versions.html) view in the following command.

```
SELECT * FROM pg_available_extension_versions;
```

After setting the desired version of your extensions, run again:

```
SELECT postgis_extensions_upgrade();
```

And manually reboot your instance. For more information here is the [upgrade](https://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/USER_UpgradeDBInstance.PostgreSQL.html#USER_UpgradeDBInstance.PostgreSQL.ExtensionUpgrades) page in the documentation.

I hope this helps.

RDS PG10 - PG11 Upgrade Fails, Missing libraries, How do I read loadable_libraries.txt, How do I install libraries.

Add your answer

Relevant content