ITADN

PSQL: When connecting impossible to chose databases.

#301OpenVagahbond 创建于 2026-05-07
V
Vagahbondcommented
Running this command `sudo -u postgres psql -d anydatabase -c "SELECT * FROM atabalethatexists"` Works, as postgres is a system user that has full access via psql socket. Now, When I use LazySQL to connect to my databases the same way here is what happens : 1. `sudo -u postgres lazysql` 2. Create a new connection with URL : `postgresql:///var/run/postgresql` 3. Connection successful 4. Left panel displays a list of my database Here is where expectations and reality fork : Expectation: From the left panel I expect to be able to connect to any DB I want by pressing space or enter. Reality: Nothing happens, no error message appears, and I cannot use my DBs. Fix I found : adding the database name to my URL and using different config for every database. Feel free to tell me if I am doing things wrong, knowing that this is a personal lab config, not a production that any business relies on.
0 条评论