I set up my forums using discourse-docker with the default self-contained config. I need to switch over to using a separate postgres server. I ran a backup, then modified app.yml, rebuilt and attempted to restore from the backup via the CLI. The restore fails, and it appears that the restore was using the correct host to access postgres, but it was using the default port (5432) rather than the one I configured (9432). Error: psql: error: connection to server at "[REDACTED HOST]" ([REDACTED IP]), port 5432 failed: Connection refused Is the server running on that host and accepting TCP/IP connections? EXCEPTION: psql failed: Is the server running on that host and accepting TCP/IP connections? /var/www/discourse/lib/backup_restore/database_restorer.rb:92:in `restore_dump' /var/www/discourse/lib/backup_restore/database_restorer.rb:26:in `restore' /var/www/discourse/lib/backup_restore/restorer.rb:51:in `run' script/discourse:149:in `restore' /var/www/discourse/vendor/bundle/ruby/3.2.0/gems/thor-1.3.0/lib/thor/command.rb:28:in `run' /var/www/discourse/vendor/bundle/ruby/3.2.0/gems/thor-1.3.0/lib/thor/invocation.rb:127:in `invoke_command' /var/www/discourse/vendor/bundle/ruby/3.2.0/gems/thor-1.3.0/lib/thor.rb:527:in `dispatch' /var/www/discourse/vendor/bundle/ruby/3.2.0/gems/thor-1.3.0/lib/thor/base.rb:584:in `start' script/discourse:290:in ` ' /usr/local/lib/ruby/gems/3.2.0/gems/bundler-2.5.3/lib/bundler/cli/exec.rb:58:in `load' /usr/local/lib/ruby/gems/3.2.0/gems/bundler-2.5.3/lib/bundler/cli/exec.rb:58:in `kernel_load' /usr/local/lib/ruby/gems/3.2.0/gems/bundler-2.5.3/lib/bundler/cli/exec.rb:23:in `run' /usr/local/lib/ruby/gems/3.2.0/gems/bundler-2.5.3/lib/bundler/cli.rb:451:in `exec' /usr/local/lib/ruby/gems/3.2.0/gems/bundler-2.5.3/lib/bundler/vendor/thor/lib/thor/command.rb:28:in `run' /usr/local/lib/ruby/gems/3.2.0/gems/bundler-2.5.3/lib/bundler/vendor/thor/lib/thor/invocation.rb:127:in `invoke_command' /usr/local/lib/ruby/gems/3.2.0/gems/bundler-2.5.3/lib/bundler/vendor/thor/lib/thor.rb:527:in `dispatch' /usr/local/lib/ruby/gems/3.2.0/gems/bundler-2.5.3/lib/bundler/cli.rb:34:in `dispatch' /usr/local/lib/ruby/gems/3.2.0/gems/bundler-2.5.3/lib/bundler/vendor/thor/lib/thor/base.rb:584:in `start' /usr/local/lib/ruby/gems/3.2.0/gems/bundler-2.5.3/lib/bundler/cli.rb:28:in `start' /usr/local/lib/ruby/gems/3.2.0/gems/bundler-2.5.3/exe/bundle:28:in `block in ' /usr/local/lib/ruby/gems/3.2.0/gems/bundler-2.5.3/lib/bundler/friendly_errors.rb:117:in `with_friendly_errors' /usr/local/lib/ruby/gems/3.2.0/gems/bundler-2.5.3/exe/bundle:20:in ` ' /usr/local/bin/bundle:25:in `load' /usr/local/bin/bundle:25:in ` ' Trying to rollback... Rolling back... Cleaning stuff up... Dropping functions from the discourse_functions schema... Removing tmp '/var/www/discourse/tmp/restores/default/2024-01-17-201724' directory... Unpausing sidekiq... Marking restore as finished... Notifying 'system' of the end of the restore... Finished! [FAILED] Config: In app.yml, under templates:, I commented out - "templates/postgres.template.yml" I also added the following under env: DISCOURSE_DB_USERNAME: [REDACTED] DISCOURSE_DB_PASSWORD: [REDACTED] DISCOURSE_DB_HOST: [REDACTED] DISCOURSE_DB_PORT: 9432 DISCOURSE_DB_NAME: [REDACTED]

Ah! You’ll also need to set DISCOURSE_DB_BACKUP_PORT: 9432 and then things should work. EDIT: this default has been in place for a while but seems to have caused more difficulty than good. FIX: clear db_backup_port default value by Supermathie · Pull Request #25316 · discourse/discourse · GitHub also should resolve this and avoid this confusion for future travellers

[image] Morpheus636: I ran a backup, then modified app.yml, rebuilt When you rebuilt did it generate a new blank site? If not, then you’ve got some problem there. Can you access the database from inside the container with psql ) Inside the container, if you do a set|grep DB do you see your ENV variables?

Yes to all three. It generates a new, blank site, connected to the correct database. The environment variables are set when I grep for them, and I can manually connect to the db from within the container.

[image] Morpheus636: but it was using the default port (5432) rather than the one I configured (9432). There is a remote chance that somehow the restore script does not respect the ENV variables (but everything else does?). The ways to check that are to look at the code and to try do do a restore from the UX. If you can restore from the UX then I think you could move this to #bug.

Then I guess what I’d do next is look at the code. It’s especially strange that it’s working for everything else.

Can you get into a rails console and then show us the following values: BackupRestore.database_configuration BackupRestore::DatabaseRestorer.psql_command e.g.: → rails c Loading development environment (Rails 7.0.8) [1] pry(main)> BackupRestore.database_configuration => # [2] pry(main)> BackupRestore::DatabaseRestorer.psql_command => "psql --dbname='discourse_development' --single-transaction --variable=ON_ERROR_STOP=1 --username=michael"

Here you go! Everything I redacted is correct. The port is the only thing that is wrong. [1] pry(main)> BackupRestore.database_configuration => # [2] pry(main)> BackupRestore::DatabaseRestorer.psql_command => "PGPASSWORD='[REDACTED]' psql --dbname='[REDACTED]' --single-transaction --variable=ON_ERROR_STOP=1 --host=[REDCATED] --port=5432 --username=[REDACTED]" I’ll also reiterate that the blank instance is able to connect to the database for everything except restoring from the backup.

What is ActiveRecord::Base.connection_pool.db_config.configuration_hash

[3] pry(main)> ActiveRecord::Base.connection_pool.db_config.configuration_hash => {:adapter=>"postgresql", :pool=>8, :connect_timeout=>5, :socket=>"/var/run/postgresql", :host=>"[REDACTED]", :port=>9432, :backup_port=>5432, :username=>"[REDACTED]", :password=>"[REDACTED]", :host_names=>["[REDACTED]"], :database=>"[REDACTED]", :prepared_statements=>false, :idle_timeout=>30, :reaping_frequency=>30, :advisory_locks=>true}

Error when migrating to an external postgres instance

Product Support Self-hosting

Morpheus636 January 18, 2024, 6:46pm 5

I’ve attempted a restore via the UX as well, and got the same error.

Topic		Replies	Views
DB backup config error Self-hosting	7	1190	October 31, 2018
Timeout when restoring a backup Self-hosting	1	947	November 16, 2020
Can't restore saved backup Self-hosting	3	1367	March 7, 2017
Failing backups Product Support	3	607	April 3, 2018
Backup fails on localhost with docker Development	9	1532	October 13, 2021

Error when migrating to an external postgres instance

Related topics