talk@lists.collectionspace.org

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

View all threads

Re: [Talk] Talk Digest, Vol 27, Issue 8

Glen Jackson

Thu, Nov 10, 2011 9:06 PM

John,

There does not appear to be an entry for postgres under the "local" type.

Add an entry that looks like:
local all postgres ident

I assume there is a "postgres" user.

Glen

On 11/10/2011 12:04 PM, talk-request@lists.collectionspace.org wrote:

Send Talk mailing list submissions to
talk@lists.collectionspace.org

To subscribe or unsubscribe via the World Wide Web, visit
http://lists.collectionspace.org/mailman/listinfo/talk_lists.collectionspace.org

or, via email, send a message with subject or body 'help' to
talk-request@lists.collectionspace.org

You can reach the person managing the list at
talk-owner@lists.collectionspace.org

When replying, please edit your Subject line so it is more specific
than "Re: Contents of Talk digest..."

Today's Topics:

 1. problem running psql on windows machine (John Keller)
 2. Fwd:  problem running psql on windows machine (Jesse Martinez)
 3. Re: Fwd:  problem running psql on windows machine (John Keller)

Message: 1
Date: Thu, 10 Nov 2011 10:07:39 -0800
From: John Kellerjkeller@berkeley.edu
To: talk@lists.collectionspace.org
Subject: [Talk] problem running psql on windows machine
Message-ID:4EBC12EB.8090309@berkeley.edu
Content-Type: text/plain; charset="iso-8859-1"; Format="flowed"

|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
||
|

--
Glen Jackson

IST-RCT

John, There does not appear to be an entry for postgres under the "local" type. Add an entry that looks like: local all postgres ident I assume there is a "postgres" user. Glen On 11/10/2011 12:04 PM, talk-request@lists.collectionspace.org wrote: > Send Talk mailing list submissions to > talk@lists.collectionspace.org > > To subscribe or unsubscribe via the World Wide Web, visit > http://lists.collectionspace.org/mailman/listinfo/talk_lists.collectionspace.org > > or, via email, send a message with subject or body 'help' to > talk-request@lists.collectionspace.org > > You can reach the person managing the list at > talk-owner@lists.collectionspace.org > > When replying, please edit your Subject line so it is more specific > than "Re: Contents of Talk digest..." > > > Today's Topics: > > 1. problem running psql on windows machine (John Keller) > 2. Fwd: problem running psql on windows machine (Jesse Martinez) > 3. Re: Fwd: problem running psql on windows machine (John Keller) > > > ---------------------------------------------------------------------- > > Message: 1 > Date: Thu, 10 Nov 2011 10:07:39 -0800 > From: John Keller<jkeller@berkeley.edu> > To: talk@lists.collectionspace.org > Subject: [Talk] problem running psql on windows machine > Message-ID:<4EBC12EB.8090309@berkeley.edu> > Content-Type: text/plain; charset="iso-8859-1"; Format="flowed" > > |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 > || > | > -- Glen Jackson ============ IST-RCT