• Overview
    Frameworks
    • Django
    • Next.js
    • 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

It’s time for version 19: All new upgrades for our API server

It’s time for version 19: All new upgrades for our API server

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