Yes, that was a typo on my part. I also found out that the MASK should
be 255.255.255.255 if I want only the single system to access my
database... But that did not fix the problem either.
Any more suggestions would be appriciated!
Tom Lane wrote:
> Doug Thistlethwaite <doug(dot)t(at)deltanet(dot)com> writes:
> > Password authentication failed for user 'doug'
> > Does anybody have an idea of what I can try to get this working?
> This tells you you are getting pretty far: you are making a TCP
> connection, and the postmaster is recognizing that the entry for
> your IP address in pg_hba demands password authentication. So,
> either you are supplying the wrong password from the client end,
> or something's wrong with the password file.
> There might be more info in the postmaster log file than is reported
> to the client --- did you look there?
> One potential typo stands out in your message:
> > The password file was created using the command pg_passwd
> > /var/postgresql/passwd
> > host doug IP.ADDRESS.OF PC 255.255.255.0 password
> > /var/postgres/passwd
> Prolly that's just a transcription error in your message, but if
> it's real...
> regards, tom lane
In response to
pgsql-interfaces by date
|Next:||From: Jerome FERRANDEZ||Date: 1999-07-21 00:04:47|
|Previous:||From: Neil Darlow||Date: 1999-07-20 20:49:09|
|Subject: PsqlODBC and Qualified Table Names|