Thread: Connecting to the database via TCP/IP

Hello all.

I'm using postgresql 7.4 on debian etch. I'm trying to get my database
working over TCP/IP connection.

I therefore have set

> tcpip_socket=true

in my /etc/postgresql/7.4/main/postgresql.conf file, but I cannot seem
to connect via TCP/IP.

I also get:

> yziquel@seldon:~$ telnet 127.0.0.1 5432
> Trying 127.0.0.1...
> Connected to 127.0.0.1.
> Escape character is '^]'.

It's then waiting for input, but no matter what I type, I get:

> Connection closed by foreign host.

What's going wrong here?

Guillaume.

On 6/17/07, Guillaume Yziquel <guillaume.yziquel@free.fr> wrote:

> > yziquel@seldon:~$ telnet 127.0.0.1 5432
> > Trying 127.0.0.1...
> > Connected to 127.0.0.1.
> > Escape character is '^]'.
>
> It's then waiting for input, but no matter what I type, I get:
>
> > Connection closed by foreign host.
>
> What's going wrong here?
My wild guess would be that psql is smarter than the
dumb telnet ... you'd get similar results from an LDAP
server ...

Try using psql (the tool that's meant for this kind of
activity).

> Guillaume.
-- Cheers,
   Andrej