Re: remote psql

From: Michael A Nachbaur <mike(at)nachbaur(dot)com>
To: "Andrew M(dot) Olson" <anolson(at)vt(dot)edu>, pgsql-general(at)postgresql(dot)org
Subject: Re: remote psql
Date: 2003-10-01 15:57:40
Message-ID: 200310010857.40854.mike@nachbaur.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Wednesday 01 October 2003 08:50 am, Andrew M. Olson wrote:
> Hi,
>
> I am trying to access PostgreSQL remotely with psql, and I am having some
> trouble. I am running the server with the -i option to allow Tcp-sockets
> and the pg_hba.conf is configed to let my subnet access it. I can access
> the server locally and with the pgAdmin III on Win2K. What is even
> stranger is that psql works remotely with the -l or -c option, but when I
> just try to connect it sits there, no errors(on the server either), no
> nothing.

What's the relevant line in your pg_hba.conf? I had some similar problems
like this when I used a funky authentication type. If I use "md5" the issues
went away.

--
/* Michael A. Nachbaur <mike(at)nachbaur(dot)com>
* http://nachbaur.com/pgpkey.asc
*/

"Anyone who is capable of getting themselves made President
should on no account be allowed to do the job."

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Richard Huxton 2003-10-01 15:57:43 Re: Migrating Access to Postgres
Previous Message Andrew M. Olson 2003-10-01 15:50:52 remote psql