"Raymond O'Donnell" <rod@iol.ie> writes:
> On 19/05/2009 20:48, Geoff Lane wrote:
>> and after rebooting the server got the error:
>> FATAL: password authentication failed for user "geoff"
> Are you supplying the correct username/password combination in the ODBC
> connection? - It sounds like this sort of a problem.
Did you set a password for the "geoff" database user at all?
It isn't going to automatically use your system-level password...
see ALTER USER ... PASSWORD ...
regards, tom lane