Re: Network Connection

From: Paul Thomas <paul(at)tmsl(dot)demon(dot)co(dot)uk>
To: Valter <pgsql(at)intersic(dot)com(dot)br>
Cc: "pgsql-general (at) postgresql (dot) org" <pgsql-general(at)postgresql(dot)org>
Subject: Re: Network Connection
Date: 2004-03-16 19:41:42
Message-ID: 20040316194142.A3557@bacon
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general


On 16/03/2004 19:20 Valter wrote:
> I have started postmaster and connected thru psql and that is ok.
>
> But when I try to connect over the network I get a connection refused
> message, inquiring if server is running on port 5432.
>
> I am using Mandrake Linux 9.2 and pgsql 7.3.4 (which cames with Mandrake)

Have you edited postgresql.conf to set tcpip_socket = true ? If this is
not done then you can't access the database using tcp/ip. Also, edit
pg_hba.conf to allow you connect from another machine. Remember to restart
the database afterwards.

HTH

--
Paul Thomas
+------------------------------+---------------------------------------------+
| Thomas Micro Systems Limited | Software Solutions for
Business |
| Computer Consultants |
http://www.thomas-micro-systems-ltd.co.uk |
+------------------------------+---------------------------------------------+

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Bruce Momjian 2004-03-16 19:46:34 Re: L doesn't seem to be working in to_char()
Previous Message Tom Lane 2004-03-16 19:40:53 Re: L doesn't seem to be working in to_char()