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…

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

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…

[图片] 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 'echo "…

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

michaeltcoelho (Michael Coelho) 2017 年12 月 2 日 13:56 3

Thanks @Falco, i’ll try it out!

话题		回复	浏览量
Restoring backup fails due to Postgres version mismatch Self-hosting	5	3411	2019 年2 月 14 日
Supported postgresql versions Self-hosting	17	3646	2025 年3 月 2 日
Backup failed due to PG/SQL errors Self-hosting	9	2535	2020 年12 月 17 日
Restoring backup from 2.0.0.beta5 disables Discourse Bug	7	1237	2018 年4 月 12 日
Can't restore saved backup Self-hosting	3	1341	2017 年3 月 7 日

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

相关话题