Re: loading a psql input file on win xp

On Mon, Mar 10, 2008 at 06:55:48AM +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 -

Yes, on platforms that don't support Unix sockets (such as Win32), it will
default to localhost.

> host all all 127.0.0.1/32 md5
>
> - which was there from installation time.

Yes, it's set by the win32 installer by default.

//Magnus