tb Support arbitrary PostgreSQL connection strings

Is there a reason PG connections are restricted to host/port? I'd like to connect with a Unix domain socket, but in general it seems arbitrary connection strings could be supported.

Aug 19 '20 01:08 3noch

Is this a MaterializeInc/materialize, or do you mean that you would like to connect tb to a running PG on a unix socket? It should be easy to add that functionality, we only haven't because it hasn't been requested yet.

Aug 19 '20 19:08 quodlibetor

I mean tb could connect with arbitrary PG connection string.

Aug 19 '20 20:08 3noch

I've looked into this a bit, and unfortunately debezium doesn't support unix sockets out of the box (complete list of properties is here). We can add support to debezium but they seem to have their own jdbc implemtnation instead of just using pgJDBC so it's not as trivial as just adding the correct flags to their connection.

This seems like a nice to have, but I can't promise that it will happen on any short-ish timescale unless it's blocking someone.

Aug 20 '20 13:08 quodlibetor