• Overview
    Frameworks
    • Drupal
    • WordPress
    • Symfony
    • Magento
    • See all frameworks
    Features
    • Observability
    • Auto-scaling
    Solutions
    • Marketing Teams
    • Retail
    • Higher Education
  • Pricing
  • Featured articles
    • Switching to Platform.sh can help IT/DevOps organizations drive 219% ROI
    • Organizations, the ultimate way to manage your users and projects
  • Support
  • Docs
  • Contact
  • Login
  • Free Trial
Blog
Thumbnail

PostgreSQL 9.6 and PostgreSQL Extensions!

November 21, 2016
Simon Ruggier
Simon Ruggier
Cloud Engineer

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

Get the latest Platform.sh news and resources
Subscribe

Related Content

The ultimate generation of our Dedicated offering is here!

The ultimate generation of our Dedicated offering is here!

Company

AboutSecurity and complianceTrust CenterBoard and investorsCareersPressContact us
System StatusPrivacyTerms of ServiceImpressumWCAG ComplianceManage your cookie preferencesReport a security issue
© 2022 Platform.sh. All rights reserved.
Supported by Horizon 2020's SME Instrument - European Commission 🇪🇺