From: | Raymond O'Donnell <rod(at)iol(dot)ie> |
---|---|
To: | Reid(dot)Thompson(at)ateb(dot)com |
Cc: | akshay bhat <akshayubhat(at)gmail(dot)com>, pgsql-general(at)postgresql(dot)org |
Subject: | Re: loading a psql input file on win xp |
Date: | 2008-03-10 06:55:48 |
Message-ID: | 47D4DB74.4020508@iol.ie |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
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(at)iol(dot)ie
---------------------------------------------------------------
From | Date | Subject | |
---|---|---|---|
Next Message | Leif Jensen | 2008-03-10 07:09:14 | Multithread problem: Error in transaction processing |
Previous Message | Christian Teguh | 2008-03-10 06:43:03 | PostreSQL Single File ( Like M$ Access) |