Re: Remote Connection

From: justin <justin(at)emproshunts(dot)com>
To: Bob Pawley <rjpawley(at)shaw(dot)ca>, pgsql-general <pgsql-general(at)postgresql(dot)org>
Subject: Re: Remote Connection
Date: 2009-02-12 23:15:25
Message-ID: 4994AD8D.9070502@emproshunts.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<meta content="text/html;charset=ISO-8859-1" http-equiv="Content-Type">
<title></title>
</head>
<body bgcolor="#ffffff" text="#000000">
Bob Pawley wrote:
<blockquote cite="mid:58F3235CF9DB4B39AF56CF0C7AF2D9F3(at)Bob" type="cite">
<meta http-equiv="Content-Type" content="text/html; ">
<meta content="MSHTML 6.00.6000.16809" name="GENERATOR">
<style></style>
<div>Hi</div>
<div>&nbsp;</div>
<div>I've been operating on localhost successfully for some time.</div>
<div>&nbsp;</div>
<div>I am now attempting to access a Postgresql 8.3 database
installed on one of my other computers conneted through a router.</div>
<div>&nbsp;</div>
<div>Is this possible?</div>
<div>&nbsp;</div>
<div>My first attempts have been with Postgresql Admin.</div>
<div>&nbsp;</div>
<div>I changed host to the IP address of the computer and input the
other info.</div>
<div>&nbsp;</div>
<div>I also ran - listen virtual; on the receiving server.</div>
<div>&nbsp;</div>
<div>It hasn't connected successfully. I get the message 'Server not
listening'</div>
<div>&nbsp;</div>
<div>What else can I do??</div>
<div>&nbsp;</div>
<div>Bob</div>
</blockquote>
<br>
Postgresql is configure by default to drop all connections that are not
localhost <br>
<br>
see <br>
<a class="moz-txt-link-freetext" href="http://www.postgresql.org/docs/8.3/interactive/auth-pg-hba-conf.html">http://www.postgresql.org/docs/8.3/interactive/auth-pg-hba-conf.html</a><br>
to make sure its configured to accept connections other than localhost<br>
<br>
Second on the router make sure port 5432 is open and porting to the
Postgresql which is the default port.&nbsp; <br>
<br>
<br>
<br>
<br>
</body>
</html>

Attachment Content-Type Size
unknown_filename text/html 1.7 KB

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Adrian Klaver 2009-02-12 23:17:59 Re: Remote Connection
Previous Message Bob Pawley 2009-02-12 23:04:54 Remote Connection