# General Availability of PostgreSQL® Major Release 15.1 (preview) and Minor Versions 14.6 and 13.9

[Blog](/blog/)&gt;[Technology](/blog/category/technical/)&gt;General Availability of PostgreSQL® Major Release 15.1 (preview) and Minor Versions 14.6 and 13.9 

General Availability of PostgreSQL® Major Release 15.1 (preview) and Minor Versions 14.6 and 13.9
=================================================================================================

December 14, 2022 | By [ Chris Carter](https://www.instaclustr.com/blog/author/christopher-carter/)

 

 

 

 



   [ ](https://x.com/intent/tweet?text=General%20Availability%20of%20PostgreSQL%C2%AE%20Major%20Release%2015.1%20(preview)%20and%20Minor%20Versions%2014.6%20and%2013.9&url=https://www.instaclustr.com/blog/general-availability-of-postgresql-major-release-15-1-preview-and-minor-versions-14-6-and-13-9/) [ ](https://www.linkedin.com/shareArticle?mini=true&url=https://www.instaclustr.com/blog/general-availability-of-postgresql-major-release-15-1-preview-and-minor-versions-14-6-and-13-9/&title=&summary=General%20Availability%20of%20PostgreSQL%C2%AE%20Major%20Release%2015.1%20(preview)%20and%20Minor%20Versions%2014.6%20and%2013.9&source=) 

Instaclustr is pleased to announce the availability of the new PostgreSQL® major release 15.1 and minor releases 14.6 and 13.9 on the Instaclustr managed platform.

PostgreSQL is the world’s most advanced open source, object-relational database system. Instaclustr is a leading provider of open source data solutions, helping customers avoid the risks of vendor lock-in and unsupported software. Instaclustr’s PostgreSQL managed platform is open source that’s really open source!

Version 15 contains a number of changes that may affect compatibility with previous releases. Observe the following incompatibilities:

- Remove PUBLIC creation permission on the public schema
- The new default is one of the secure schema usage patterns that Section 5.9.6 has recommended since the security release for CVE-2018-1058. This change applies to new database clusters and to newly-created databases in existing clusters. Upgrading a cluster or restoring a database dump will preserve PUBLIC’s existing permissions.
- For existing databases, especially those having multiple users, consider revoking CREATE permission on the public schema to adopt this new default. For new databases having no need to defend against insider threats, granting CREATE permission will yield the behavior of prior releases.

- Change the owner of the public schema to be the new pg\_database\_owner role. This allows each database owner to have ownership privileges on the public schema within their database. Previously, it was owned by the bootstrap superuser and therefore non-superuser database owners could not do anything with it.
- This change applies to new database clusters and to newly-created databases in existing clusters. Upgrading a cluster or restoring a database dump will preserve PUBLIC’s existing ownership specification.

More information is available at the PostgreSQL 15 [release documentation](https://www.postgresql.org/docs/15/release-15.html)

Customers can treat the minor releases as a “drop-in” replacement, functionally compatible with the previous minor versions. In particular, the following fixes are especially important for our customers and PostgreSQL users in general:

1. Fix for updatable views for INSERT statements that include multi-row VALUES clauses with a DEFAULT set.
2. Disallow rules named \_RETURN that are not ON SELECT rules
3. Fix for construction of per-partition foreign key constraints while doing ALTER TABLE … ATTACH PARTITION, where previously incorrect or duplicate constraints could be built.
4. Updates time zone data files to use data release 2022. This includes DST law changes in Chile, Fiji, Iran, Jordan, Mexico, Palestine and Syria, plus historical corrections for Chile, Crimea, Iran and Mexico.

The release is also the last update for PostgreSQL 10 which will not be supported going forward. Instaclustr customers managing their own PostgreSQL 10 cluster who need help planning their PostgreSQL upgrade can contact [Instaclustr Support](https://www.instaclustr.com/support-solutions/).  As with all PostgreSQL releases, there is more information available in the official PostgreSQL [release notes](https://www.postgresql.org/about/news/postgresql-151-146-139-1213-1118-and-1023-released-2543/), as well as in the release notes for each version of the documentation.

For customers wanting to experience a PostgreSQL cluster on the Instaclustr managed platform, you can sign up and create a PostgreSQL cluster with these new versions on a [free trial](https://console2.instaclustr.com/login).

For customers who are running PostgreSQL on the managed platform, our Technical Operations team will reach out shortly to schedule a time to upgrade your clusters to the latest minor version. If you would like to upgrade to a new major version, or have any questions, please reach out to our [Support team](https://www.instaclustr.com/contact-us/).

Happy upgrading!

how to create a PostgreSQL cluster with Instaclustr

[Learn more](https://www.instaclustr.com/support/documentation/postgresql/getting-started-with-postgresql/getting-started-with-postgres-creating-a-postgres-cluster/)

 

 

 

### About the author

**[Chris Carter](https://www.instaclustr.com/blog/author/christopher-carter/)** | Principal Product Manager

With extensive expertise in open source technologies, Chris drives innovation and excellence in the NetApp Instaclustr Managed Platform with a focus on Apache Kafka and Cassandra. With his passion for classical statistics and process improvement, Chris leverages his skills to ensure the integration of business strategy and direction into NetApp solutions.

 



 

 ![mail icon]()#### Get the latest articles for open sourceIn your inbox

 <a class="btn btn-primary btn-popup text-dark" href="">Sign up now</a> 

 

 

 

  ### Related content

 [ Zero Downtime Migration to Instaclustr 

 

 Yes, we can migrate existing Cassandra clusters to Instaclustr without any downtime. Here's what to expect from the process... 

 

 

 

 

 

 

 ](https://www.instaclustr.com/blog/zero-downtime-migration-to-instaclustr/) 

 [ Workflow Comparison: Uber Cadence vs Netflix Conductor 

 

 When choosing what’s right for your company’s opensource workflow needs it is important to know the difference and similarities ... 

 

 

 

 

 

 

 ](https://www.instaclustr.com/blog/workflow-comparison-uber-cadence-vs-netflix-conductor/) 

 [ Will Your Cassandra Database Project Succeed?: The New Stack 

 

 Open source Apache Cassandra® continues to stand out as an enterprise-proven solution for organizations seeking high availability... 

 

 

 

 

 

 

 ](https://www.instaclustr.com/blog/will-your-cassandra-database-project-succeed-the-new-stack/) 

 

  <a class="close-modal" href="">×</a>Sign upto ourNewsletter
-----------------------
