pg.ddx.io pgsql-interfaces@postgresql.org mailing list archive
help / color / mirror / Atom feedConnection via remote client
3+ messages / 2 participants
[nested] [flat]
* Connection via remote client
@ 1998-10-17 09:30 Olivier TURPIN <turpin_olivier@bigfoot.com>
1998-10-19 20:49 ` Re: [INTERFACES] Connection via remote client Olivier TURPIN <turpin_olivier@bigfoot.com>
0 siblings, 1 reply; 3+ messages in thread
From: Olivier TURPIN @ 1998-10-17 09:30 UTC (permalink / raw)
To: pgsql-interfaces
hi!
I'm a new user of PostgreSQL. that's maybe the reason for my asking this
question.
I'm trying to connect via ODBC or pgAdmin from a Win95 client, but the
connection is always refused. I tried to have a look in the postgreSQL
files and modified the pg_hba.conf file to allow remote connection from
the client address with the line:
host all 190.1.1.1 255.255.255.255 trust
No way ! I could not manage to establish that connection !
Can anyone help ? Thanks a lot !
O. Turpin
Attachments:
vcard.vcf (text/x-vcard, 377B) download
begin: vcard
fn: TURPIN Olivier
n: Olivier;TURPIN
org: StradaNet
adr: La Touche;;;Marcillé Raoul;;35560;FRANCE
email;internet: turpin_olivier@bigfoot.com
title: Gérant
tel;work: 02 99 73 68 07
tel;fax: 02 99 73 68 07
x-mozilla-cpt: ;0
x-mozilla-html: FALSE
version: 2.1
end: vcard
* Re: [INTERFACES] Connection via remote client
1998-10-17 09:30 Connection via remote client Olivier TURPIN <turpin_olivier@bigfoot.com>
@ 1998-10-19 20:49 ` Olivier TURPIN <turpin_olivier@bigfoot.com>
1998-10-20 21:16 ` Re: [INTERFACES] Connection via remote client Tom Lane <tgl@sss.pgh.pa.us>
0 siblings, 1 reply; 3+ messages in thread
From: Olivier TURPIN @ 1998-10-19 20:49 UTC (permalink / raw)
To: Sferacarta Software <sferac@bo.nettuno.it>; pgsql-interfaces
Hello,
I thank you for your quick answer !
But the problem still remains. I launched the postmaster with the following
command line:
postmaster -i -S -D/var/lib/pgsql
Idea of what happens ?
I wonder if there is a special user to be defined prior to any connection (?)
Thanks.
Sferacarta Software wrote:
> Hello Olivier,
>
> sabato, 17 ottobre 98, you wrote:
>
> OT> hi!
>
> OT> I'm a new user of PostgreSQL. that's maybe the reason for my asking this
> OT> question.
> OT> I'm trying to connect via ODBC or pgAdmin from a Win95 client, but the
> OT> connection is always refused. I tried to have a look in the postgreSQL
> OT> files and modified the pg_hba.conf file to allow remote connection from
> OT> the client address with the line:
> OT> host all 190.1.1.1 255.255.255.255 trust
> OT> No way ! I could not manage to establish that connection !
>
> OT> Can anyone help ? Thanks a lot !
>
> You need running postmaster with -i parameter.
>
> Jose'
Attachments:
vcard.vcf (text/x-vcard, 377B) download
begin: vcard
fn: TURPIN Olivier
n: Olivier;TURPIN
org: StradaNet
adr: La Touche;;;Marcillé Raoul;;35560;FRANCE
email;internet: turpin_olivier@bigfoot.com
title: Gérant
tel;work: 02 99 73 68 07
tel;fax: 02 99 73 68 07
x-mozilla-cpt: ;0
x-mozilla-html: FALSE
version: 2.1
end: vcard
* Re: [INTERFACES] Connection via remote client
1998-10-17 09:30 Connection via remote client Olivier TURPIN <turpin_olivier@bigfoot.com>
1998-10-19 20:49 ` Re: [INTERFACES] Connection via remote client Olivier TURPIN <turpin_olivier@bigfoot.com>
@ 1998-10-20 21:16 ` Tom Lane <tgl@sss.pgh.pa.us>
0 siblings, 0 replies; 3+ messages in thread
From: Tom Lane @ 1998-10-20 21:16 UTC (permalink / raw)
To: Olivier TURPIN <turpin_olivier@bigfoot.com>; +Cc: pgsql-interfaces
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
^ permalink raw reply [nested|flat] 3+ messages in thread
end of thread, other threads:[~1998-10-20 21:16 UTC | newest]
Thread overview: 3+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
1998-10-17 09:30 Connection via remote client Olivier TURPIN <turpin_olivier@bigfoot.com>
1998-10-19 20:49 ` Olivier TURPIN <turpin_olivier@bigfoot.com>
1998-10-20 21:16 ` Tom Lane <tgl@sss.pgh.pa.us>
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