Thread: remote psql

remote psql

From

"Andrew M. Olson"

Date:

01 October 2003, 15:43:52

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.

Here is what I have installed:
-FreeBSD 4.8
-Postgres 7.3(on both sides)

thanks,
Andrew Olson

Re: remote psql

From

Michael A Nachbaur

Date:

01 October 2003, 15:58:32

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@nachbaur.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."