Re: Could not connect to remote socket

Поиск
Список
Период
Сортировка
От joe.f.miller@wcom.com (Joe)
Тема Re: Could not connect to remote socket
Дата
Msg-id a7b1579e.0207290635.5f6b470d@posting.google.com
обсуждение исходный текст
Ответ на Could not connect to remote socket  ("Tahira Aslam" <taslam@etrisoft.net>)
Список pgsql-admin
Check to make sure your firewall settings are allowing traffic to pass
in and out of port 5432. Linux, by default does not keep this port
open. You can view your firewall settings in IPChains. That may not be
the answer, but it could be a contributing factor in the problem.


taslam@etrisoft.net ("Tahira Aslam") wrote in message news:<006101c236eb$1ae4ec60$1b00a8c0@trisoft.com>...
> This is a multi-part message in MIME format.
>
> ------=_NextPart_000_0057_01C23714.F8D99D80
> Content-Type: text/plain;
>     charset="iso-8859-1"
> Content-Transfer-Encoding: quoted-printable
>
> I have my postgresql DB on linux machine. and i have 2 windows clients for =
> this DB.Things were working fine until this morning when client machines st=
> arted giving error
>
> Could not connect to server
> Could not connect to remote socket
>
> I have taken care of each thing like
> 1) Starting postmaster with -i option
> 2) pgaccess is running successfully
> 3) windows client machines can ping server.
> 4) windows client machines can access server's shared folders through samba=
>  services
> 5) pg_hba.conf file has 2 entries for my clients
> 6) i have uncommeted tcpip_socket=3Dfalse in /var/lib/pgsql/data/postgresql=
> .conf file and set it to true.
>
> what else should i do to connect my windows clients machines with my linux =
> server ??
>
>
> ------=_NextPart_000_0057_01C23714.F8D99D80
> Content-Type: text/html;
>     charset="iso-8859-1"
> Content-Transfer-Encoding: quoted-printable
>
> <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
> <HTML><HEAD>
> <META http-equiv=3DContent-Type content=3D"text/html; charset=3Diso-8859-1">
> <META content=3D"MSHTML 6.00.2600.0" name=3DGENERATOR>
> <STYLE></STYLE>
> </HEAD>
> <BODY bgColor=3D#ffffff>
> <DIV>
> <DIV><FONT face=3DArial size=3D2>I have my postgresql DB on linux machine. =
> and i=20
> have 2 windows clients for this DB.Things were working fine until this morn=
> ing=20
> when client machines started giving error</FONT></DIV>
> <DIV><FONT face=3DArial size=3D2></FONT> </DIV>
> <DIV><FONT face=3DArial size=3D2>Could not connect to server</FONT></DIV>
> <DIV><FONT face=3DArial size=3D2>Could not connect to remote socket</FONT><=
> /DIV>
> <DIV><FONT face=3DArial size=3D2></FONT> </DIV>
> <DIV><FONT face=3DArial size=3D2>I have taken care of each thing like</FONT=
> ></DIV>
> <DIV><FONT face=3DArial size=3D2>1) Starting postmaster with -i option</FON=
> T></DIV>
> <DIV><FONT face=3DArial size=3D2>2) pgaccess is running successfully</FONT>=
> </DIV>
> <DIV>
> <DIV><FONT face=3DArial size=3D2>3) windows client machines can ping=20
> server.</FONT></DIV></DIV>
> <DIV><FONT face=3DArial size=3D2>4) windows client machines can access serv=
> er's=20
> shared folders through samba services</FONT></DIV>
> <DIV><FONT face=3DArial size=3D2>5) pg_hba.conf file has 2 entries for my=
> =20
> clients</FONT></DIV>
> <DIV><FONT face=3DArial size=3D2>6) i have uncommeted tcpip_socket=3Dfalse =
> in=20
> /var/lib/pgsql/data/postgresql.conf file and set it to true.</FONT></DIV>
> <DIV><FONT face=3DArial size=3D2></FONT> </DIV>
> <DIV><FONT face=3DArial size=3D2>what else should i do to connect my window=
> s clients=20
> machines with my linux server ??</FONT></DIV>
> <DIV><FONT face=3DArial size=3D2></FONT> </DIV></DIV></BODY></HTML>
>
> ------=_NextPart_000_0057_01C23714.F8D99D80--

В списке pgsql-admin по дате отправления:

Предыдущее
От: Andrew Sullivan
Дата:
Сообщение: Re: [GENERAL] log sql?
Следующее
От: Achilleus Mantzios
Дата:
Сообщение: Re: [SQL] 3-tier