talk@lists.collectionspace.org

WE HAVE SUNSET THIS LISTSERV - Join us at collectionspace@lyrasislists.org

Fwd: problem running psql on windows machine

Jesse Martinez

Thu, Nov 10, 2011 7:42 PM

Forgot to CC the talk list.

---------- Forwarded message ----------
From: Jesse Martinez jmartinez@movingimage.us
Date: Thu, Nov 10, 2011 at 1:41 PM
Subject: Re: [Talk] problem running psql on windows machine
To: John Keller jkeller@berkeley.edu

Hi John,

Try using 127.0.0.1/32 as the address value instead of 'samehost'. I think
the samehost term is platform dependent and Postgres for Win7 doesn't use
it well. I haven't tried but possibly also 'localhost' may work too. I
believe they're semantically the same.

Additional info for 9.1:
http://www.postgresql.org/docs/9.1/static/auth-pg-hba-conf.html

Jesse

On Thu, Nov 10, 2011 at 1:07 PM, John Keller jkeller@berkeley.edu wrote:

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 Berkeleyjkeller@berkeley.edu

Talk mailing list
Talk@lists.collectionspace.org

http://lists.collectionspace.org/mailman/listinfo/talk_lists.collectionspace.org

Forgot to CC the talk list. ---------- Forwarded message ---------- From: Jesse Martinez <jmartinez@movingimage.us> Date: Thu, Nov 10, 2011 at 1:41 PM Subject: Re: [Talk] problem running psql on windows machine To: John Keller <jkeller@berkeley.edu> Hi John, Try using 127.0.0.1/32 as the address value instead of 'samehost'. I think the samehost term is platform dependent and Postgres for Win7 doesn't use it well. I haven't tried but possibly also 'localhost' may work too. I believe they're semantically the same. Additional info for 9.1: http://www.postgresql.org/docs/9.1/static/auth-pg-hba-conf.html - Jesse On Thu, Nov 10, 2011 at 1:07 PM, John Keller <jkeller@berkeley.edu> wrote: > 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 Berkeleyjkeller@berkeley.edu > > > _______________________________________________ > Talk mailing list > Talk@lists.collectionspace.org > > http://lists.collectionspace.org/mailman/listinfo/talk_lists.collectionspace.org > >

John Keller

Thu, Nov 10, 2011 8:04 PM

Thanks for the suggestion, but it doesn't help.
(I had already tried that, per the note in the docs, but forgot to
mention it in my original post).

john

On 11/10/2011 11:42 AM, Jesse Martinez wrote:

Forgot to CC the talk list.

---------- Forwarded message ----------
From: Jesse Martinez <jmartinez@movingimage.us
mailto:jmartinez@movingimage.us>
Date: Thu, Nov 10, 2011 at 1:41 PM
Subject: Re: [Talk] problem running psql on windows machine
To: John Keller <jkeller@berkeley.edu mailto:jkeller@berkeley.edu>

Hi John,

Try using 127.0.0.1/32 http://127.0.0.1/32 as the address value
instead of 'samehost'. I think the samehost term is platform dependent
and Postgres for Win7 doesn't use it well. I haven't tried but
possibly also 'localhost' may work too. I believe they're semantically
the same.

Additional info for 9.1:
http://www.postgresql.org/docs/9.1/static/auth-pg-hba-conf.html

Jesse

On Thu, Nov 10, 2011 at 1:07 PM, John Keller <jkeller@berkeley.edu
mailto:jkeller@berkeley.edu> wrote:

 |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
 <http://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  <mailto:jkeller@berkeley.edu>


 _______________________________________________
 Talk mailing list
 Talk@lists.collectionspace.org <mailto:Talk@lists.collectionspace.org>
 http://lists.collectionspace.org/mailman/listinfo/talk_lists.collectionspace.org

Talk mailing list
Talk@lists.collectionspace.org
http://lists.collectionspace.org/mailman/listinfo/talk_lists.collectionspace.org

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

Thanks for the suggestion, but it doesn't help. (I had already tried that, per the note in the docs, but forgot to mention it in my original post). - john On 11/10/2011 11:42 AM, Jesse Martinez wrote: > Forgot to CC the talk list. > > ---------- Forwarded message ---------- > From: *Jesse Martinez* <jmartinez@movingimage.us > <mailto:jmartinez@movingimage.us>> > Date: Thu, Nov 10, 2011 at 1:41 PM > Subject: Re: [Talk] problem running psql on windows machine > To: John Keller <jkeller@berkeley.edu <mailto:jkeller@berkeley.edu>> > > > Hi John, > > Try using 127.0.0.1/32 <http://127.0.0.1/32> as the address value > instead of 'samehost'. I think the samehost term is platform dependent > and Postgres for Win7 doesn't use it well. I haven't tried but > possibly also 'localhost' may work too. I believe they're semantically > the same. > > Additional info for 9.1: > http://www.postgresql.org/docs/9.1/static/auth-pg-hba-conf.html > > - Jesse > > On Thu, Nov 10, 2011 at 1:07 PM, John Keller <jkeller@berkeley.edu > <mailto:jkeller@berkeley.edu>> wrote: > > |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 > <http://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 <mailto:jkeller@berkeley.edu> > > > _______________________________________________ > Talk mailing list > Talk@lists.collectionspace.org <mailto:Talk@lists.collectionspace.org> > http://lists.collectionspace.org/mailman/listinfo/talk_lists.collectionspace.org > > > > > > _______________________________________________ > Talk mailing list > Talk@lists.collectionspace.org > http://lists.collectionspace.org/mailman/listinfo/talk_lists.collectionspace.org -- John W. Keller Web/Db Applications Programmer EECS and IST, UC Berkeley jkeller@berkeley.edu