On 01/14/2019 11:21 AM, Rich Shepard wrote:
On Mon, 14 Jan 2019, Galen Seitz wrote:
Here are the relevant lines in /var/lib/pgsql/data/pg_hba.conf
# TYPE DATABASE USER ADDRESS METHOD
# "local" is for Unix domain socket connections only
local all all peer
# IPv4 local connections:
host all all 127.0.0.1/32 ident
# IPv6 local connections:
host all all ::1/128 ident
galen,
Are you the only user able to access your postgres databases? On my
hosts
all methods are set to trust and I've no issues. But, I use psql (or my own
psycopg/SQLAlchemy applications). I never did get LO to connect.
My user id is the only non-system user with database access permissions.
Trust authentication is basically wide open, but since you are the
only user on your system, it's not that important that your security be
tightened.
If you want to get LO to connect to postgresql, now's the time to ask me
questions before I forget everything I've learned.
galen
--
Galen Seitz
[email protected]
_______________________________________________
PLUG mailing list
[email protected]
http://lists.pdxlinux.org/mailman/listinfo/plug
