Re: loading a psql input file on win xp - Mailing list pgsql-general

From Reid Thompson
Subject Re: loading a psql input file on win xp
Date
Msg-id 1205149082.20691.79.camel@raker.ateb.com
Whole thread Raw
In response to Re: loading a psql input file on win xp  (Raymond O'Donnell <rod@iol.ie>)
Responses Re: loading a psql input file on win xp  (Raymond O'Donnell <rod@iol.ie>)
List pgsql-general
On Mon, 2008-03-10 at 06:55 +0000, Raymond O'Donnell wrote:
> On 09/03/2008 22:33, Reid Thompson wrote:
> > On Sun, 2008-03-09 at 19:41 +0000, Raymond O'Donnell wrote:
> >> On 09/03/2008 15:34, Reid Thompson wrote:
> >>
> >>> you'll also probably have to add the parameter -h 127.0.0.1
> >> psql defaults to connecting to the local machine unless you tell it
> >> otherwise, so this is redundant; though it certainly won't do any harm
> >> either.
> >>
> > Not redundent.  Unless something has changed, psql's default connection
> > method is via unix socket 5432 and this socket does not exist on
> > windows. The -h is required to have psql connect to the network socket
> > which is available on windows.
>
> Oh? Well, on my XP laptop, the following -
>
>     psql -U postgres
>
> - connects without problems to the "postgres" database. Of course, there
> *is* the following line in pg_hba.conf -
>
>    host    all         all        127.0.0.1/32          md5
>
> - which was there from installation time.
>
> Ray.
>
> ---------------------------------------------------------------
> Raymond O'Donnell, Director of Music, Galway Cathedral, Ireland
> rod@iol.ie
> ---------------------------------------------------------------
Cool.  I'll have to check the pg_hba.conf on my windows system and see
what it has in it.  My windows box is running either 8.0.x or 8.1.x.
Has this setting always been this way for the windows installer?

pgsql-general by date:

Previous
From: Craig Ringer
Date:
Subject: Re: Service account not showing
Next
From: Alvaro Herrera
Date:
Subject: Re: v8.3 + UTF8 errors when restoring DB