pkgsrc-Users archive

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index][Old Index]

postgresql connection defaults



pgsql from pkgsrc defaults to listening on a unix domain socket and
localhost, with auth method "trust".  This isn't a good configuration
but this message isn't about trying to change the default.

I adjusted authentication config to use "peer" on the unix domain socket
and reject on localhost, and also set up a map in pg_ident.conf for some
daemons that had a pg username that is not the same as the unix
username.  This mostly worked well.

I found that i had "host=localhost" in pg connection strings in a few
places (scripts, qgis) and wanted to adjsut to use the unix domain
socket.

Sometimes, this was as easy as dropping host=, defaulting to the socket.
Sometimes, in ogr2ogr from gdal, that didn't seem to work and I need to
tell it to use the socket.  But

  PG:host=/tmp/.s.PGSQL.5432

failed with an error about

  /tmp/.s.PGSQL.5432/.s.PGSQL.5432

and just setting host=/tmp worked.


So, is it a pgsql issue that

  not setting host in gdal fails to default to unix domain socket?

  setting the socket path fails, and you need bare/tmp instead?

and/or am I missing something else?



Home | Main Index | Thread Index | Old Index