I upgraded Discourse to latest stable version with complete rebuild yesterday. I’ve got this strange error this morning: [2018-10-27 04:21:44] 'netpositive' has started the backup! [2018-10-27 04:21:44] Marking backup as running... [2018-10-27 04:21:44] Making sure '/var/www/discourse/tmp/backups…

Oh, I totally missed the different ports in your first post. :sweat_smile: It looks like backups use the default PostgreSQL port unless specified otherwise. I think you might be able to override it by configuring DISCOURSE_DB_BACKUP_PORT: 5433 in your container config.

[图片] netpositive: postgresql 9.6 server I have a feeling this may be your problem discourse/docs/INSTALL.md at main · discourse/discourse · GitHub Software Requirements Postgres 10+

No, Discourse works still fine with 9.6 and it definitely should not get a connection refused because of the Pg version.

Thanks, somehow I’ve overlooked that. Now on postgresql 10 but the problem still persists :roll_eyes:

[图片] netpositive: If I manually run the pg_dump command inside the container then it works flawlessly You could try running the same command Discourse uses for dumps. You can get it by executing the following inside the container: rails c BackupRestore::Backuper.new(Discourse.system_user.id,…

It doesn’t work because the port 5432 is used instead of 5433 :frowning: [1] pry(main)> BackupRestore::Backuper.new(Discourse.system_user.id, {}).send(:pg_dump_command) => "PGPASSWORD='redacted' pg_dump --schema=public --file='/var/www/discourse/tmp/backups/default/2018-10-29-184350/dump.sql.gz' --…

Thank you, that setting did the trick :relaxed:

DB 备份配置错误

支持安装

netpositive 2018 年10 月 31 日 05:41 8

Thank you, that setting did the trick

话题		回复	浏览量
Failing backups Support	3	599	2018 年4 月 3 日
Error when migrating to an external postgres instance Self-hosting	11	615	2024 年1 月 18 日
Pg_dump backup failure for remote pgsql - port & version differentials; what options exist? Self-hosting	6	3533	2022 年8 月 20 日
Backup has failed. pg_dump: server version: 9.6.3; pg_dump version: 9.5.10 Development	7	9202	2017 年12 月 2 日
Backup failed due to PG/SQL errors Self-hosting	9	2532	2020 年12 月 17 日

DB 备份配置错误

相关话题