PSQL: When connecting impossible to chose databases.
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 条评论