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@xxxxxx
---------------------------------------------------------------
--
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
