### Author:  [@pfaffman](https://meta.discourse.org/u/pfaffman)
#### Post date: [January 18, 2024, 4:46pm UTC](https://meta.discourse.org/t/error-when-migrating-to-an-external-postgres-instance/291992/2 "2024-01-18T16:46:09Z")
> [@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?
---
### Author:  [@Morpheus636](https://meta.discourse.org/u/Morpheus636)
#### Post date: [January 18, 2024, 4:51pm UTC](https://meta.discourse.org/t/error-when-migrating-to-an-external-postgres-instance/291992/3 "2024-01-18T16:51:45Z")
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.
---
### Author:  [@pfaffman](https://meta.discourse.org/u/pfaffman)
#### Post date: [January 18, 2024, 6:45pm UTC](https://meta.discourse.org/t/error-when-migrating-to-an-external-postgres-instance/291992/4 "2024-01-18T18:45:29Z")
> [@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 #Contribute > Bug.
---
### Author:  [@Morpheus636](https://meta.discourse.org/u/Morpheus636)
#### Post date: [January 18, 2024, 6:46pm UTC](https://meta.discourse.org/t/error-when-migrating-to-an-external-postgres-instance/291992/5 "2024-01-18T18:46:48Z")
I’ve attempted a restore via the UX as well, and got the same error.
---
### Author:  [@pfaffman](https://meta.discourse.org/u/pfaffman)
#### Post date: [January 18, 2024, 6:48pm UTC](https://meta.discourse.org/t/error-when-migrating-to-an-external-postgres-instance/291992/6 "2024-01-18T18:48:20Z")
Then I guess what I’d do next is look at the code.
It’s especially strange that it’s working for everything else.
---
### Author:  [@supermathie](https://meta.discourse.org/u/supermathie)
#### Post date: [January 18, 2024, 6:57pm UTC](https://meta.discourse.org/t/error-when-migrating-to-an-external-postgres-instance/291992/7 "2024-01-18T18:57:58Z")
Can you get into a rails console and then show us the following values:
```rub
BackupRestore.database_configuration
BackupRestore::DatabaseRestorer.psql_command
```
e.g.:
```plaintext
→ 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"
```
---
### Author:  [@Morpheus636](https://meta.discourse.org/u/Morpheus636)
#### Post date: [January 18, 2024, 7:09pm UTC](https://meta.discourse.org/t/error-when-migrating-to-an-external-postgres-instance/291992/8 "2024-01-18T19:09:35Z")
Here you go! Everything I redacted is correct. The port is the only thing that is wrong.
```plaintext
[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.
---
### Author:  [@supermathie](https://meta.discourse.org/u/supermathie)
#### Post date: [January 18, 2024, 7:14pm UTC](https://meta.discourse.org/t/error-when-migrating-to-an-external-postgres-instance/291992/9 "2024-01-18T19:14:48Z")
What is
```plaintext
ActiveRecord::Base.connection_pool.db_config.configuration_hash
```
---
### Author:  [@Morpheus636](https://meta.discourse.org/u/Morpheus636)
#### Post date: [January 18, 2024, 7:17pm UTC](https://meta.discourse.org/t/error-when-migrating-to-an-external-postgres-instance/291992/10 "2024-01-18T19:17:05Z")
```plaintext
[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}
```
---
### Author:  [@supermathie](https://meta.discourse.org/u/supermathie)
#### Post date: [January 18, 2024, 7:18pm UTC](https://meta.discourse.org/t/error-when-migrating-to-an-external-postgres-instance/291992/11 "2024-01-18T19:18:09Z")
Ah! You’ll also need to set
```plaintext
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](https://github.com/discourse/discourse/pull/25316) also should resolve this and avoid this confusion for future travellers
---
### Author:  [@Morpheus636](https://meta.discourse.org/u/Morpheus636)
#### Post date: [January 18, 2024, 11:40pm UTC](https://meta.discourse.org/t/error-when-migrating-to-an-external-postgres-instance/291992/12 "2024-01-18T23:40:14Z")
Much appreciated! Thanks!
---
### Author:  [@system](https://meta.discourse.org/u/system)
#### Post date: [February 17, 2024, 11:41pm UTC](https://meta.discourse.org/t/error-when-migrating-to-an-external-postgres-instance/291992/13 "2024-02-17T23:41:09Z")
This topic was automatically closed 30 days after the last reply. New replies are no longer allowed.