search

FDA-MyStudies / install-script

A repository for shell scripts that aid in the installation of LabKey products and services.
Apache License 2.0
1 stars 1 forks source link

psql local password authentications does not work #34

Open labkey-stuartm opened 3 years ago

labkey-stuartm commented 3 years ago

When attempting to use the psql command line tools with labkey user (or the use defined by the ENV vars), the user is unable to authenticate due to a postgres configuration issue. The pg_hba.conf needs to be updated as follows:

Connection type   Database   User       IP addresses   Method
local               all        postgres                  peer
local               all        labkey                     md5

A future release will include this change.