Hi folks! I’m getting notified by discourse’s system user about that my backup has failed. On the doc it says that Discourse accepts Postgres 9.3+ versions and i’m using 9.6.3. [2017-12-02 03:32:09] [STARTED] [2017-12-02 03:32:09] 'system' has started the backup! [2017-12-02 03:32:09] Marking back…

[image] michaeltcoelho: Will i have to downgrade my Postgres` versions? Yes, we currently support PostgreSQL 9.5.x.

Thanks @Falco , i’ll try it out!

If you find a way to install 9.5 on Ubuntu 17.10, I’d love to hear about it. I think that it should be possible with Docker, but I’ve not yet managed. My solution thus far has been using the docker development environment in discourse/bin/docker, which has a few quirks, but it works. I actually go…

[image] pfaffman: If you find a way to install 9.5 on Ubuntu 17.10, I’d love to hear about it. The official PostgreSQL apt repo currently has: PostgreSQL 9.2, 9.3, 9.4, 9.5, 9.6, 10, 11devel. Just follow the official instructions: PostgreSQL: Linux downloads (Ubuntu) TL;DR: sudo sh -c 'ech…

Thanks, @falco ! I figured there should be a way. I tried what I thought was that, but all of the binaries were named with the version names in them or something, and I couldn’t make that work. I’ve had on my list to come back to figuring this out for a couple weeks now (I generally work at my deskto…

Maybe you got bit by the fact that they support: 14.04, 16.04, 17.04 and 18.04 but skipped 17.10. In the above snipped I set do you get 17.04 packages, that in my experience work just fine.

I bet that was it! And I somehow didn’t think to use the 17.04 repo. I’ll feel a little less silly, so that’s a big help too. :slight_smile: @techAPJ , if I get ambitious, I’ll see if I can find an elegant way to add this to https://raw.githubusercontent.com/techAPJ/install-rails/master/linux. My g…

Backup has failed. pg_dump: server version: 9.6.3; pg_dump version: 9.5.10

Development

Falco (Falco) December 2, 2017, 1:55pm 2

Yes, we currently support PostgreSQL 9.5.x.

Topic		Replies	Views
Restoring backup fails due to Postgres version mismatch Self-hosting	5	3411	February 14, 2019
Supported postgresql versions Self-hosting	17	3647	March 2, 2025
Backup failed due to PG/SQL errors Self-hosting	9	2535	December 17, 2020
Restoring backup from 2.0.0.beta5 disables Discourse Bug	7	1237	April 12, 2018
Can't restore saved backup Self-hosting	3	1341	March 7, 2017

Backup has failed. pg_dump: server version: 9.6.3; pg_dump version: 9.5.10

Related topics