We’re happy to announce the availability of PostgreSQL 9.6 as a choice of service in Platform.sh. You can learn how to enable it in our documentation. Although we don’t yet support the
pg_upgrade command, existing users of PostgreSQL 9.3 can still upgrade using
pg_restore, as discussed in the Upgrading section.
And you now have full support for running Postgres Extensions on Platform.sh. In your
services.yaml file you can simply add a configuration subkey with the following strucure:
postgresql: type: "postgresql:9.6" disk: 1025 configuration: extensions: - pg_trgm - hstore
In this example you will have pg_trgm installed giving functions to determine the similarity of text based on trigram matching and hstore, giving you a key-value store.
The complete docs are here: PostgreSQL Extensions