Re: Postgres Pain Points: 1 pg_hba conf

[support-tiger <support@xxxxxxxxxxxxxxx>]

On 08/13/2016 01:37 PM, John R Pierce wrote:

On 8/13/2016 8:29 AM, support-tiger wrote:

experimented with this some more with no progress. only trust seems to work which is not what we want - will try some more versions with md5 but this is why I've called this out as such a pain point.

show us your pg_hba.conf (sans comments), and the connections that aren't working the way you want, along with whatever error messages they are generating.

sorry for delay (traveling and rural usa wifi is pathetic)
attached is the pg_hba file that is working on a fedora development machine - we've added a few comments to put case examples right in the file - hope the spacing did not get mangled

obviously "trust" is not good but need working alternative

also, if using web sockets (ie socket.io) would this change ? 

hope we can make this file more clear

-- 
Support Dept
Tiger Nassau, Inc.
www.tigernassau.com
406-624-9310

# Put your actual configuration here
# ----------------------------------
#
# If you want to allow non-local connections, you need to add more
# "host" records.  In that case you will also need to make PostgreSQL
# listen on a non-local interface via the listen_addresses
# configuration parameter, or via the -i or -h command line switches.

# Case I: Web Application 
# db: mydb  
# user: myuser
# pass: mypass
# host: localhost
#
# TYPE     DATABASE        USER      ADDRESS       METHOD
  local    all             all                     trust
  host     all             all       127.0.0.1/32  trust
# host     mydb            myuser    127.0.0.1/32  trust
# IPv6 local connections:
  host     all             all       ::1/128       ident
# Allow replication connections from localhost, by a user with the
# replication privilege.
#local     replication     postgres                peer
#host      replication     postgres  127.0.0.1/32  ident
#host      replication     postgres  ::1/128       ident
      

-- 
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general