# The restored database never appears in the Tryton login dropdown at all
**URL:** https://discuss.tryton.org/t/the-restored-database-never-appears-in-the-tryton-login-dropdown-at-all/9207
**Category:** System Administrator
**Created:** [April 19, 2026, 11:16am UTC](https://discuss.tryton.org/t/the-restored-database-never-appears-in-the-tryton-login-dropdown-at-all/9207 "2026-04-19T11:16:58Z")
**Posts on this page:** 12
**Page:** 1
### Author:  [@mimo\_Alva](https://discuss.tryton.org/u/mimo_Alva)
#### Post date: [April 19, 2026, 11:16am UTC](https://discuss.tryton.org/t/the-restored-database-never-appears-in-the-tryton-login-dropdown-at-all/9207/1 "2026-04-19T11:16:59Z")
Hi, I need help. After backing up my Tryton database on the server using:
```auto
pg_dump -U user1ad -d database_tryton > database_tryton.sql
```
I went to my localhost, created a virtual environment, and copied the server environment exactly. Then I created a new database:
```auto
CREATE DATABASE new_database;
```
After that, I restored the backup:
```auto
psql -U developer -d new_database < /home/developer/database_tryton.sql
```
The problem is that when I run:
```auto
trytond-admin -c trytond.conf -vv -d new_database --all
```
it executes without errors, but it does **not** ask me to enter the admin email or password (the usual initialization step). As a result, the database name `new_database` does not appear in the Tryton interface (SAO). Why is this happening, and what am I missing?
**in trytond.conf , here is how I put the database section**
```auto
[database]
uri = postgresql:///
```
Ps: I have already tried to create another virtualenv and install modules one by one and install sao same as in the server and then restore data before initialization but same thing happen i can not see the database in the trytond when I go to browser, the thing happen always when I restore data before initalization (`trytond-admin -c trytond.conf -vv -d new_database --all -vv`) as I say it doesn’t even ask me to enter password or email , it’s running silently
any help will be appreciated, Thank you
---
### Author:  [@cheche](https://discuss.tryton.org/u/cheche)
#### Post date: [April 19, 2026, 3:18pm UTC](https://discuss.tryton.org/t/the-restored-database-never-appears-in-the-tryton-login-dropdown-at-all/9207/2 "2026-04-19T15:18:59Z")
when you execute
`trytond -c trytond.conf -d new_database`
works for you?
---
### Author:  [@mimo\_Alva](https://discuss.tryton.org/u/mimo_Alva)
#### Post date: [April 19, 2026, 3:51pm UTC](https://discuss.tryton.org/t/the-restored-database-never-appears-in-the-tryton-login-dropdown-at-all/9207/3 "2026-04-19T15:51:09Z")
> [@cheche](#):
>
> trytond -c trytond.conf -d new\_database
>
> Hello, thank you for your reply, I tried it, but the same thing happens. It doesn’t prompt me to enter the admin email, password, and confirm password, and that’s why I still don’t see the database in Tryton SAO when I open it in the browser.
after load modules it just show
126077 140165519484608 [2026-04-19 15:45:39,150] INFO trytond.pool setup mixin for “new\_database”
126077 140165519484608 [2026-04-19 15:45:39,150] INFO trytond.modules all modules loaded
126077 140166021963840 [2026-04-19 15:45:39,268] INFO werkzeug \* Running on [http://0.0.0.0:8000/](http://0.0.0.0:8000/) (Press CTRL+C to quit) and I go to [http://0.0.0.0:8000/](http://0.0.0.0:8000/) and I can’t see the database
---
### Author:  [@cheche](https://discuss.tryton.org/u/cheche)
#### Post date: [April 19, 2026, 5:50pm UTC](https://discuss.tryton.org/t/the-restored-database-never-appears-in-the-tryton-login-dropdown-at-all/9207/4 "2026-04-19T17:50:08Z")
> [@mimo\_Alva](#):
>
> ```auto
> [database]
>
> uri = postgresql:///
>
> ```
make sure that you add username password and host:
> **[TRYTOND\_DATABASE\_URI - Configuration file — Tryton server](https://docs.tryton.org/latest/server/topics/configuration.html#database)**
>
> This section describes the different main sections that may appear in a Tryton configuration file, the purpose of each section, its possible keys, and their possible values. Some modules could request the usage of other sections for which the...
---
### Author:  [@mimo\_Alva](https://discuss.tryton.org/u/mimo_Alva)
#### Post date: [April 19, 2026, 6:30pm UTC](https://discuss.tryton.org/t/the-restored-database-never-appears-in-the-tryton-login-dropdown-at-all/9207/5 "2026-04-19T18:30:03Z")
I have updated database section in trytond.conf
```auto
[database]
uri = postgresql://admin:secretpassword@localhost/
```
—\>so then when I typed again `trytond-admin -c trytond.conf -vv -d new_database --all`
`trytond.backend.postgresql.database connection to “new_database” succeeded`
`135347 139933203255360 [2026-04-19 17:52:32,309] INFO trytond.admin init db`
`Traceback (most recent call last):`
`File “/home/dev/.virtualenvs/trytond6/bin/trytond-admin”, line 23, in `
`admin.run(options)`
`File “/home/dev/.virtualenvs/trytond6/lib/python3.11/site-packages/trytond/admin.py”, line 31, in run`
`database.init()`
`File “/home/dev/.virtualenvs/trytond6/lib/python3.11/site-packages/trytond/backend/postgresql/database.py”, line 364, in init`
`cursor.execute(line)`
`File “/home/dev/.virtualenvs/trytond6/lib/python3.11/site-packages/trytond/backend/postgresql/database.py”, line 72, in execute`
`cursor.execute(self, sql, args)`
`psycopg2.errors.DuplicateTable: relation “ir_configuration_id_seq” already exists`
**-----\>I fixed this error via sql queries**
`ALTER DATABASE “new_database” OWNER TO admin;`
`ALTER SCHEMA public OWNER TO admin;`
`DO $$`
`DECLARE r RECORD;`
`BEGIN`
`FOR r IN SELECT tablename FROM pg_tables WHERE schemaname = ‘public’ LOOP`
`EXECUTE ‘ALTER TABLE public.’ || quote_ident(r.tablename) || ’ OWNER TO admin’;`
`END LOOP;`
`FOR r IN SELECT sequencename FROM pg_sequences WHERE schemaname = ‘public’ LOOP`
`EXECUTE ‘ALTER SEQUENCE public.’ || quote_ident(r.sequencename) || ’ OWNER TO admin’;`
`END LOOP;`
`END;`
`$$;`
but then when I typed again `trytond-admin -c trytond.conf -vv -d new_database --all`( it doesn’t even ask me to enter email admin or password and confirm it again , the command running silently) and after go again to browser
I just see the database dropdown empty
---
### Author:  [@cheche](https://discuss.tryton.org/u/cheche)
#### Post date: [April 19, 2026, 6:49pm UTC](https://discuss.tryton.org/t/the-restored-database-never-appears-in-the-tryton-login-dropdown-at-all/9207/6 "2026-04-19T18:49:18Z")
I am guessing that you are trying to setup a local environment for some testing.
Just create the same username/password for PostgreSQL to simplify .
you are using username **user1ad** but in the localhost you are using **developer**.
those usernames are independent from trytond.
---
### Author:  [@mimo\_Alva](https://discuss.tryton.org/u/mimo_Alva)
#### Post date: [April 19, 2026, 8:38pm UTC](https://discuss.tryton.org/t/the-restored-database-never-appears-in-the-tryton-login-dropdown-at-all/9207/7 "2026-04-19T20:38:33Z")
username in server is **user1ad** where I have did the backup via `pg_dump -U user1ad -d database_tryton > database_tryton.sql`
```sql
Name | Owner | Access privileges
database_tryton | postgres |=Tc/postgres postgres=CTc/postgres ++++++++++++++++++++ user1=c/postgres
```
In my localhost I did the restore via `psql -U developer -d new_database -W < /home/developer/database_tryton.sql`
```auto
Name | Owner | Access privileges
new_database | developer |
```
in **trytond.conf**
[database]
uri = postgresql://developer:xxxxx@localhost:5432/
list = True
After `trytond-admin -c trytond.conf -vv -d new_database --all`
—\>there is no database list in the trytond Interface
**Ps:** even when I tried to again create database and linked to owner postgres like in the server via `CREATE DATABASE “new_database” OWNER postgres ENCODING ‘UTF8’ LC_COLLATE ‘en_US.UTF-8’ LC_CTYPE ‘en_US.UTF-8’ TEMPLATE template0;`
* * *
\>the same thing happen no database shown on the dropdown list login and when i run `trytond-admin -c trytond.conf -vv -d new_database --all `
* * *
\>it doesnt show me the option to enter manually email for the admin or type the password and when I go to browser i can not see this database
---
### Author:  [@cheche](https://discuss.tryton.org/u/cheche)
#### Post date: [April 19, 2026, 9:06pm UTC](https://discuss.tryton.org/t/the-restored-database-never-appears-in-the-tryton-login-dropdown-at-all/9207/8 "2026-04-19T21:06:25Z")
> [@mimo\_Alva](#):
>
> /home/developer/database\_tryton.sql
Ensure that is the same owner that you have on your dump:
```auto
grep OWNER /home/developer/database_tryton.sql
```
---
### Author:  [@ced](https://discuss.tryton.org/u/ced)
#### Post date: [April 19, 2026, 10:05pm UTC](https://discuss.tryton.org/t/the-restored-database-never-appears-in-the-tryton-login-dropdown-at-all/9207/9 "2026-04-19T22:05:57Z")
If you have setup an hostname in the `ir.configuration`, the database will only be visible for request to that same hostname.
If you do not want this filter anymore, you can just clear the value from the table.
---
### Author:  [@mimo\_Alva](https://discuss.tryton.org/u/mimo_Alva)
#### Post date: [April 19, 2026, 10:30pm UTC](https://discuss.tryton.org/t/the-restored-database-never-appears-in-the-tryton-login-dropdown-at-all/9207/10 "2026-04-19T22:30:19Z")
I tried to put the new\_database have same owner name , but same behaviour happen
---
### Author:  [@mimo\_Alva](https://discuss.tryton.org/u/mimo_Alva)
#### Post date: [April 19, 2026, 10:30pm UTC](https://discuss.tryton.org/t/the-restored-database-never-appears-in-the-tryton-login-dropdown-at-all/9207/11 "2026-04-19T22:30:42Z")
Thanks Mr.@ced , the solution was that I cleared hostname in ir.configuration via commad UPDATE ir\_configuration SET hostname = NULL;
---
### Author:  [@system](https://discuss.tryton.org/u/system)
#### Post date: [April 20, 2026, 10:31pm UTC](https://discuss.tryton.org/t/the-restored-database-never-appears-in-the-tryton-login-dropdown-at-all/9207/12 "2026-04-20T22:31:36Z")
This topic was automatically closed 24 hours after the last reply. New replies are no longer allowed.