Does anyone know how I can access TWENTY's PostgreSQL in Docker compose?
Does anyone know how I can access TWENTY's PostgreSQL in Docker compose? I uploaded a docker compose to easypanel, but I can't access the database to make a backup or extract the database.
2 Replies
I used direct way to access this which is:
-
docker exec -it twenty_postgres bash to open bash shell inside container
- psql -U postgres (password: postgres, that's default) to open database
- \l to list all databases
- \c default to connect to specific database
- select * from (click Tab key to show all available tables, if you use \d then only 1 table will be shown as on top of postgres there's graphql which works in different way)
Maybe there's a better way but I didn't find it, someone from core team may know itI recently started using DBeaver, better visualization.