--NextPart_Webmail_9m3u9jl4l_26557_1210176720_0
Content-Type: text/plain
Content-Transfer-Encoding: 8bit
We've recently installed Postgresql 8.3 on a Windows Server 2003, Standard
Edition, Service Pack 2 machine. I am able to connect locally via pgAdmin
but not remotely.
The error message we are receiving in the Application event log is...
XX000: could not bind IPv4 socket: No error
The above occurs twice and then we get
WARNING 01000: could not create list socket for "loaner-mikec"
Our postgresql.conf contains...
#------------------------------------------------------------------------------
# CONNECTIONS AND AUTHENTICATION
#------------------------------------------------------------------------------
# - Connection Settings -
listen_addresses = 'localhost,marlon,loaner-mikec'
# what IP address(es) to listen on;
# comma-separated list of addresses;
# defaults to 'localhost', '*' = all
# (change requires restart)
****t = 5432 # (change requires restart)
max_connections = 100 # (change requires restart)
host all all marlon/32 trust
host all all loaner-mikec/32 trust
host all all marlon trust
marlon, and loaner-mikec are two machine names from which we're trying to
connect. We previously tried using ip address instead of machine names,
but got the same negative symptoms.
Any help greatly appreciated.
--NextPart_Webmail_9m3u9jl4l_26557_1210176720_0
Content-Type: text/html
Content-Transfer-Encoding: 8bit
<html>
<!-- BEGIN WEBMAIL STATIONERY -->
<head></head>
<body>
<!-- WEBMAIL STATIONERY noneset -->
<DIV>We've recently installed Postgresql 8.3 on a Windows Server 2003,
Standard Edition, Service Pack 2 machine. I am able to connect locally via
pgAdmin but not remotely. </DIV>
<DIV>
<DIV> </DIV>
<DIV>The error message we are receiving in the Application event log
is...</DIV>
<DIV> </DIV>
<DIV>XX000: could not bind IPv4 socket: No error</DIV>
<DIV> </DIV>
<DIV>The above occurs twice and then we get</DIV>
<DIV> </DIV>
<DIV>WARNING 01000: could not create list socket for
"loaner-mikec"</DIV></DIV>
<DIV> </DIV>
<DIV>Our postgresql.conf contains...</DIV>
<DIV> </DIV>
<DIV>#------------------------------------------------------------------------------<BR>#
CONNECTIONS AND
AUTHENTICATION<BR>#------------------------------------------------------------------------------</DIV>
<DIV># - Connection Settings -</DIV>
<DIV>listen_addresses =
'localhost,marlon,loaner-mikec'<BR> # what IP
address(es) to listen on;<BR> #
comma-separated list of addresses;<BR> #
defaults to 'localhost', '*' = all<BR> #
(change requires restart)<BR>****t = 5432 # (change
requires restart)<BR>max_connections = 100 # (change
requires restart)</DIV>
<DIV> </DIV>
<DIV>host all all marlon/32 trust<BR>host
all all loaner-mikec/32 trust<BR>host all
all marlon trust</DIV>
<DIV> </DIV>
<DIV>marlon, and loaner-mikec are two machine names from which we're
trying to connect. We previously tried using ip address instead of machine
names, but got the same negative symptoms.</DIV>
<DIV> </DIV>
<DIV>Any help greatly appreciated.</DIV>
<!-- END WEBMAIL STATIONERY -->
</body>
</html>
--NextPart_Webmail_9m3u9jl4l_26557_1210176720_0--
|
