Обсуждение: Could not connect to remote socket
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 started 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=false 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 ??
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--
i was able to connect my client machine with my linux server. Actually
It was norton anti virus problem. Both of my client machines had installed
recent norton antivirus and that anti virus was causing this problem. Once i
uninstalled those antivirus from my client machines..they got connected to
linux server.
It was norton anti virus problem. Both of my client machines had installed
recent norton antivirus and that anti virus was causing this problem. Once i
uninstalled those antivirus from my client machines..they got connected to
linux server.
----- Original Message -----From: Tahira AslamTo: pgsql-adminSent: Monday, July 29, 2002 3:31 PMSubject: [ADMIN] Could not connect to remote socketI 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 started giving errorCould not connect to serverCould not connect to remote socketI have taken care of each thing like1) Starting postmaster with -i option2) pgaccess is running successfully3) windows client machines can ping server.4) windows client machines can access server's shared folders through samba services5) pg_hba.conf file has 2 entries for my clients6) i have uncommeted tcpip_socket=false 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 ??