Skip site navigation (1) Skip section navigation (2)

Re: Can't connect Win XP client to Linux server

From: Geoff Lane <geoff(at)gjctech(dot)co(dot)uk>
To: PostgreSQL ODBC <pgsql-odbc(at)postgresql(dot)org>
Subject: Re: Can't connect Win XP client to Linux server
Date: 2009-05-20 13:30:29
Message-ID: (view raw, whole thread or download thread mbox)
Lists: pgsql-odbc
On Wednesday, May 20, 2009, Tom Lane wrote:

>> 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...

D'oh! I assumed that roles created via the "createuser" utility had
the password for the system user account. SELECT * FROM pg_roles;
showed passwords for all roles where I expected nulls or empty strings
where no password was set. Doing as you suggested did the trick.

My thanks both to Tom and to Raymond.

Geoff Lane

In response to

pgsql-odbc by date

Next:From: Moreno D.Date: 2009-05-26 16:48:52
Subject: Show max_identifier_length causes heavy query execution
Previous:From: Timothy MaddenDate: 2009-05-20 09:47:13
Subject: Re: How to transfer binary data into a BIT VARYING column ?

Privacy Policy | About PostgreSQL
Copyright © 1996-2017 The PostgreSQL Global Development Group