# PostgreSQL minimum version

**URL:** https://meta.discourse.org/t/postgresql-minimum-version/29168
**Category:** Bug
**Created:** [May 23, 2015, 10:39am UTC](https://meta.discourse.org/t/postgresql-minimum-version/29168 "2015-05-23T10:39:48Z")
**Posts on this page:** 5
**Page:** 1

<div class="post-metadata">

### Author: ![jamielinux](https://sea3.discourse-cdn.com/meta/user_avatar/meta.discourse.org/jamielinux/32/116093_2.png) [@jamielinux](https://meta.discourse.org/u/jamielinux)
#### Post date: [May 23, 2015, 10:39am UTC](https://meta.discourse.org/t/postgresql-minimum-version/29168/1 "2015-05-23T10:39:48Z")

</div>

The Discourse [README](https://github.com/discourse/discourse/blob/271d6f896ed8e85b977266ab04d9f06087953f27/README.md#development) states that the minimum version of PostgreSQL is 9.1+. Judging from the rest of the documentation, the minimum should now be 9.2+. I’d submit a PR to fix this, but…

Backups created by Discourse include the statement `CREATE SCHEMA IF NOT EXISTS backup`. Restores fail on PostgreSQL 9.2 because the [`IF NOT EXISTS` parameter for `CREATE SCHEMA` was introduced in 9.3](http://www.postgresql.org/docs/9.3/static/sql-createschema.html). Perhaps the minimum version should be documented as 9.3+ instead?

---

<div class="post-metadata">

### Author: ![sam](https://sea3.discourse-cdn.com/meta/user_avatar/meta.discourse.org/sam/32/102149_2.png) [@sam](https://meta.discourse.org/u/sam)
#### Post date: [May 23, 2015, 10:47am UTC](https://meta.discourse.org/t/postgresql-minimum-version/29168/2 "2015-05-23T10:47:27Z")

</div>

Need to fix readme 9.3 is minimum

---

<div class="post-metadata">

### Author: ![codinghorror](https://sea3.discourse-cdn.com/meta/user_avatar/meta.discourse.org/codinghorror/32/110067_2.png) [@codinghorror](https://meta.discourse.org/u/codinghorror)
#### Post date: [May 23, 2015, 10:49am UTC](https://meta.discourse.org/t/postgresql-minimum-version/29168/3 "2015-05-23T10:49:48Z")

</div>

I just updated some of the docs to say 9.2 a bunch of places, so this needs to be changed again.

---

<div class="post-metadata">

### Author: ![sam](https://sea3.discourse-cdn.com/meta/user_avatar/meta.discourse.org/sam/32/102149_2.png) [@sam](https://meta.discourse.org/u/sam)
#### Post date: [June 1, 2015, 5:28am UTC](https://meta.discourse.org/t/postgresql-minimum-version/29168/4 "2015-06-01T05:28:17Z")

</div>

Version refs are updated 9.3 is indeed the minimum, closing

---

<div class="post-metadata">

### Author: ![sam](https://sea3.discourse-cdn.com/meta/user_avatar/meta.discourse.org/sam/32/102149_2.png) [@sam](https://meta.discourse.org/u/sam)
#### Post date: [June 1, 2015, 5:28am UTC](https://meta.discourse.org/t/postgresql-minimum-version/29168/5 "2015-06-01T05:28:18Z")

</div>