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@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
