|I'm configuring PostgreSQL 9.1 on a Windows 7 machine. Following the
instructions at
http://wiki.collectionspace.org/display/DOC/PostgreSQL+Installation+-+Windows%2C+Mac+OS+X%2C+Generic+Linux,
when I try to run psql with the command "psql -d template1 -U postgres",
I receive this error:

||psql: FATAL:  no pg_hba.conf entry for host "::1", user "postgres",
database "template1", SSL off

Here are the contents of my pg_hba.conf file:

TYPE  DATABASE        USER            ADDRESS                METHOD

IPv4 local connections:

host    all            postgres        samehost                md5
host    jbossdb        jboss          samehost                md5
host    nuxeo          nuxeo          samehost                md5
host    cspace          cspace          samehost                md5

IPv6 local connections:

#host    all            all            ::1/128                md5

Allow replication connections from localhost, by a user with the

replication privilege.

#host    replication    postgres        127.0.0.1/32            md5
#host    replication    postgres        ::1/128                md5
||
||
Note that no "local" connection was present after install, and trying to
add one like "local all all md5" makes it impossible to restart the
database service.

Help?

thanks,
john
||
|

--
John W. Keller
Web/Db Applications Programmer
EECS and IST, UC Berkeley
jkeller@berkeley.edu

The relevant section of my config (in Win7) is below. Note the allowance of
the reader account to connect from the local subnet. I have no trouble with
the postgres account. So, something else odd is going on, I think. I cannot
remember if I used the one-click installer or installed postgres myself. I
know I wanted to move the data to another drive, so I may have done it
myself. Perhaps you should attach your other psql config for comparison to
ours.

IPv4 local connections:

host    all            postgres        samehost                md5
host    jbossdb        jboss          samehost                md5
host    nuxeo          nuxeo          samehost                md5
host    cspace          cspace          samehost                md5
host    nuxeo          reader          samehost                md5

#Allow remote connections for reader, from our UCB network
host    nuxeo          reader          169.229.0.0/16          md5

Patrick

From: talk-bounces@lists.collectionspace.org
[mailto:talk-bounces@lists.collectionspace.org] On Behalf Of John Keller
Sent: Thursday, November 10, 2011 10:08 AM
To: talk@lists.collectionspace.org
Subject: [Talk] problem running psql on windows machine

I'm configuring PostgreSQL 9.1 on a Windows 7 machine. Following the
instructions at
http://wiki.collectionspace.org/display/DOC/PostgreSQL+Installation+-+Window
s%2C+Mac+OS+X%2C+Generic+Linux, when I try to run psql with the command
"psql -d template1 -U postgres", I receive this error:

psql: FATAL:  no pg_hba.conf entry for host "::1", user "postgres", database
"template1", SSL off

Here are the contents of my pg_hba.conf file:

TYPE  DATABASE        USER            ADDRESS                METHOD

IPv4 local connections:

host    all            postgres        samehost                md5
host    jbossdb        jboss          samehost                md5
host    nuxeo          nuxeo          samehost                md5
host    cspace          cspace          samehost                md5

IPv6 local connections:

#host    all            all            ::1/128                md5

Allow replication connections from localhost, by a user with the

replication privilege.

#host    replication    postgres        127.0.0.1/32            md5
#host    replication    postgres        ::1/128                md5

Note that no "local" connection was present after install, and trying to add
one like "local all all md5" makes it impossible to restart the database
service.

Help?

thanks,
john

--

John W. Keller

Web/Db Applications Programmer

EECS and IST, UC Berkeley

jkeller@berkeley.edu