Search Postgresql Archives

Re: loading a psql input file on win xp

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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

-- 
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux