PostgreSQL 9.6 and PostgreSQL Extensions!
This post was originally published on the Platform.sh blog and reflects information from the time of publication.
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_dump and 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