Re: can only connect to localhost is postgresql

From: "Reshat Sabiq" <sabiq(at)purdue(dot)edu>
To:
Cc: <pgsql-novice(at)postgresql(dot)org>
Subject: Re: can only connect to localhost is postgresql
Date: 2003-01-31 23:17:07
Message-ID: 000e01c2c97e$e07dfa90$b082d380@main
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

I have a question:
Is it a legit thing to have 2 connection modes for the same host:

local all ident
sameuser
local all ident newmode
Thanks,
r.
-----Original Message-----
From: pgsql-novice-owner(at)postgresql(dot)org
[mailto:pgsql-novice-owner(at)postgresql(dot)org] On Behalf Of Reshat Sabiq
Sent: Friday, January 31, 2003 2:19 PM
To: Rob Klaus
Cc: afore(at)sonic(dot)net; pgsql-novice(at)postgresql(dot)org
Subject: Re: [NOVICE] can only connect to localhost is postgresql

I think in pg_hba you'd need to put the IP, rather than the computer
name.

r.

Rob Klaus wrote:

Have you added the appropriate host to the pg_hba.conf file?

At 09:40 AM 1/31/2003 -0800, Art Fore wrote:

When connecting to postgresql database via ODBC, I can only connect via
localhost, I cannot connect via the computer name. I can ping the
computer name and get a return. Postgres is started with the -i option.
Why can I not connect via computer name?

Art

---------------------------(end of broadcast)---------------------------
TIP 3: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to majordomo(at)postgresql(dot)org so that your
message can get through to the mailing list cleanly
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Rob Klaus
Database Analyst
Unique Management Services Inc.
119 East Maple Street
Jeffersonville IN 47130
Phone: 812-285-0886
1-800-879-5453
Fax: 812-285-0895

http://www.unique-mgmt.com <http://www.unique-mgmt.com/>

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~


In response to

Responses

Browse pgsql-novice by date

  From Date Subject
Next Message Michiel Lange 2003-02-01 01:24:14 Re: where is libpq.so
Previous Message Luis Magaña 2003-01-31 23:13:30 Name of days and months