From: | "Mick McElarney" <Mick(dot)McElarney(at)maxsp(dot)com> |
---|---|
To: | <pgsql-novice(at)postgresql(dot)org> |
Subject: | pg_hba.conf, md5 and .pgpass |
Date: | 2007-02-01 03:36:55 |
Message-ID: | 95085C3D6653B4448258D919B449DAD13D1BE3@server4.maxsp.local |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-novice |
Hi,
Here is my pg_hba.conf file configuration:
What should I change so that it reads my /home/postgres/.pgpass file
when I execute a psql -Upostgres databasename?
# TYPE DATABASE USER CIDR-ADDRESS METHOD
# "local" is for Unix domain socket connections only
local all all md5
# IPv4 local connections:
host all all 127.0.0.1/32 md5
host all all 111.222.333.0/24 md5
# IPv6 local connections:
host all all ::1/128 md5
/home/postgres/.pgpass looks like this:
127.0.0.1:*:*:postgres:password
192.168.1.218:*:*:postgres:password
192.168.1.221:*:*:postgres:password
I have executed an alter user postgres with encrypted password
'password';
Thanks, Mick.
From | Date | Subject | |
---|---|---|---|
Next Message | Matthew Campbell | 2007-02-01 03:38:23 | Newbie Developer Question |
Previous Message | Jeff Stanley | 2007-01-31 03:37:42 | Postgre Connection question |