Re: Could not connect to remote socket - Mailing list pgsql-admin
| From | joe.f.miller@wcom.com (Joe) |
|---|---|
| Subject | Re: Could not connect to remote socket |
| Date | |
| Msg-id | a7b1579e.0207290635.5f6b470d@posting.google.com Whole thread Raw |
| In response to | Could not connect to remote socket ("Tahira Aslam" <taslam@etrisoft.net>) |
| List | 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 by date: