Need a documented way to connect via unix socket

dataegret / pgcompacttable

BSD 3-Clause "New" or "Revised" License

314 stars 48 forks source link

Need a documented way to connect via unix socket #29

Closed pyhalov closed 4 years ago

pyhalov commented 4 years ago

I haven't found any way to use peer auth with this script without modifying it to omit 'host=' parameter.

Melkij commented 4 years ago

Hello You can use standard libpq behavior and specify unix socket directory as hostname, -h /tmp (postgresql from scratch) or -h /var/run/postgresql (debian/ubuntu packages). (check your unix_socket_directories postgresql setting)

I will keep this issue open. Possible I need change default connect method to unixsock, like psql and other libpq software.

Melkij commented 4 years ago

Hi I changed default host and port to use libpq defaults. So by default tool will use unixsock