From: Tom Lane <tgl@sss.pgh.pa.us>
To: Olivier TURPIN <turpin_olivier@bigfoot.com>
Cc: PostgreSQL Interfaces <pgsql-interfaces@postgreSQL.org>
Subject: Re: [INTERFACES] Connection via remote client
Date: Tue, 20 Oct 1998 17:16:07 -0400
Message-ID: <3308.908918167@sss.pgh.pa.us> (raw)
In-Reply-To: <362BA5E2.6230B950@bigfoot.com>
Olivier TURPIN <turpin_olivier@bigfoot.com> 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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-interfaces@postgresql.org
Cc: tgl@sss.pgh.pa.us, turpin_olivier@bigfoot.com
Subject: Re: [INTERFACES] Connection via remote client
In-Reply-To: <3308.908918167@sss.pgh.pa.us>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox