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