dbeaver doesn't show my docker postgres databases and its content

Question

When I connect via psql with this command docker exec -it 4e18793cb23c psql -U postgres mytestdb, I can see my database and work with it. But when I connect with dbeaver to my postgres docker container, it doesn't show me my data. But when I want to create the same database it says that it exists. Also, doing a select on the tables, it says that the table doesn't exist. Few things that I checked are:

• the directory (zorin os/ubuntu) /var/lib/postgres doesn't exist
• Inspect docker volume shows me this:

docker volume inspect pgdata                                                                                                                                           
    [
    {

        "CreatedAt": "2024-04-13T09:03:53+02:00",
        "Driver": "local",
        "Labels": null,
        "Mountpoint": "/var/lib/docker/volumes/pgdata/_data",
        "Name": "pgdata",
        "Options": null,
        "Scope": "local"
    }]

I don't have Postgres directly on my machine installed.

How do I make my databases and tables and everything appear in dbeaver?

Answer 1

SOLUTION: this is crazy, but checking the "show all databases" in the connection settings solved this issue.