Connecting to the database via TCP/IP

From: Guillaume Yziquel <guillaume(dot)yziquel(at)free(dot)fr>
To: pgsql-novice(at)postgresql(dot)org
Subject: Connecting to the database via TCP/IP
Date: 2007-06-16 23:28:41
Message-ID: 46747229.7040401@free.fr
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

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(at)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.

Responses

Browse pgsql-novice by date

  From Date Subject
Next Message Andrej Ricnik-Bay 2007-06-17 01:25:02 Re: Connecting to the database via TCP/IP
Previous Message Tom Lane 2007-06-15 21:06:00 Re: Stuck (again) trying to move a 7.x app and database to 8.2