4 ms·

Just tried this out, and although it visually looks ok it doesn't seem to even support basic connectivity options like unix sockets. eg the hostname field for

Just tried this out, and although it visually looks ok it doesn't seem to even support basic connectivity options like unix sockets. eg the hostname field for new connections must be a hostname or IP address, and can't take things like `/var/run/postgresql`. That's super unfortunate. :( --- As a data point, the program seems to create config files (on Linux) under `~/.config/PgManage` and `~/.pgmanage`. If you delete the application after testing, you might as well nuke those two dirs as well.

mst 2y ago
libpq normally connects to a unix socket by being given 'localhost' as the hostname or no hostname at all. IIRC it'll also accept a path -as- a hostname but I'm guessing from your phrasing the field validation won't.
- uhoh-itsmaciek 2y ago
  Are you sure about localhost? I'm not familiar with other libpq clients, but psql definitely always resolves localhost to an IP address for me. You're right about it accepting a path (and defaulting to a compile-time selected UNIX socket path).
- justinclift 2y ago
  > libpq normally connects to a unix socket by being given 'localhost' as the hostname or no hostname at all. 'localhost' for a unix socket doesn't sound right. 'localhost' is a specific network address and has a default configuration in pg_hba.conf (127.0.0.1) for itself. It's different to the 'local' entry in pg_hba.conf that's specifically for unix sockets. And yeah, the field validation in the IDE required some kind of value in the hostname field, and wouldn't take a path (ie /var/...etc), so no kind of fallback behaviour seemed workable. :(
  - lmz 2y ago
    localhost as unix socket shortcut is actually MySQL behavior: https://dev.mysql.com/doc/c-api/8.4/en/mysql-real-connect.html https://dev.mysql.com/doc/c-api/8.4/en/mysql-real-connect.ht...
Asmod4n 2y ago
looks like you can just use a connection URL, https://www.postgresql.org/docs/current/libpq-connect.html#LIBPQ-CONNSTRING-URIS https://www.postgresql.org/docs/current/libpq-connect.html#L..., it's possible to use it to connect to a unix socket that way.
- justinclift 2y ago
  Ahhh cool, good thinking. I've already moved on, but might take another look at a future point. :)
Onavo 2y ago
The this one https://dbgate.org/ https://dbgate.org/

mst 2y ago

libpq normally connects to a unix socket by being given 'localhost' as the hostname or no hostname at all. IIRC it'll also accept a path -as- a hostname but I'm guessing from your phrasing the field validation won't.

uhoh-itsmaciek 2y ago
Are you sure about localhost? I'm not familiar with other libpq clients, but psql definitely always resolves localhost to an IP address for me. You're right about it accepting a path (and defaulting to a compile-time selected UNIX socket path).
justinclift 2y ago
> libpq normally connects to a unix socket by being given 'localhost' as the hostname or no hostname at all. 'localhost' for a unix socket doesn't sound right. 'localhost' is a specific network address and has a default configuration in pg_hba.conf (127.0.0.1) for itself. It's different to the 'local' entry in pg_hba.conf that's specifically for unix sockets. And yeah, the field validation in the IDE required some kind of value in the hostname field, and wouldn't take a path (ie /var/...etc), so no kind of fallback behaviour seemed workable. :(
- lmz 2y ago
  localhost as unix socket shortcut is actually MySQL behavior: https://dev.mysql.com/doc/c-api/8.4/en/mysql-real-connect.html https://dev.mysql.com/doc/c-api/8.4/en/mysql-real-connect.ht...

Asmod4n 2y ago

looks like you can just use a connection URL, https://www.postgresql.org/docs/current/libpq-connect.html#LIBPQ-CONNSTRING-URIS https://www.postgresql.org/docs/current/libpq-connect.html#L..., it's possible to use it to connect to a unix socket that way.

justinclift 2y ago
Ahhh cool, good thinking. I've already moved on, but might take another look at a future point. :)

Onavo 2y ago

The this one https://dbgate.org/ https://dbgate.org/