Received: from sss.sss.pgh.pa.us (sss.pgh.pa.us [206.210.65.6]) by hub.org (8.8.8/8.8.8) with ESMTP id RAA27556 for ; Tue, 20 Oct 1998 17:16:54 -0400 (EDT) (envelope-from tgl@sss.pgh.pa.us) Received: from sss.sss.pgh.pa.us (localhost [127.0.0.1]) by sss.sss.pgh.pa.us (8.9.1/8.9.1) with ESMTP id RAA03310; Tue, 20 Oct 1998 17:16:07 -0400 (EDT) To: Olivier TURPIN cc: PostgreSQL Interfaces Subject: Re: [INTERFACES] Connection via remote client In-reply-to: Your message of Mon, 19 Oct 1998 22:49:40 +0200 <362BA5E2.6230B950@bigfoot.com> Date: Tue, 20 Oct 1998 17:16:07 -0400 Message-ID: <3308.908918167@sss.pgh.pa.us> From: Tom Lane Olivier TURPIN writes: > But the problem still remains. I launched the postmaster with the following > command line: > postmaster -i -S -D/var/lib/pgsql > I wonder if there is a special user to be defined prior to any connection (?) Well, that's a good point. The postmaster will only accept connections from clients that give one of the usernames authorized to access the database --- this is above and beyond the client IP address check. initdb will create the database with only one authorized user, namely whoever is running initdb. You may need to add another user corresponding to whatever userID the Win95 client is supplying. See the "createuser" script supplied with Postgres. (Do you even know what user name the Win95 client is supplying? You may just need to set it appropriately. I have no idea what the Win95 client-side libraries use for a default user ID, but it very likely wouldn't be the same as your Unix userID.) regards, tom lane