This is a cryptographically signed message in MIME format.
--------------ms080808020909080702060605
Content-Type: multipart/alternative;
boundary="------------040201080704010108050903"
This is a multi-part message in MIME format.
--------------040201080704010108050903
Content-Type: text/plain; charset=UTF-8; format=flowed
Content-Transfer-Encoding: quoted-printable
Hello,
I think you make mistake writing "listen_addresses =3D 10.0.0.*". I doubt=
it can be done like this... Try "listen_addresses =3D '*'" first. Also
see, that addresses are in form '10.0.0.1' and not 10.0.0.1. (use ' )
If this doesn't help try telneting server (port 5432) from client
mashine. Maybe theres a firewall in between??
2009.11.02 15:26, Shruthi A ra=C5=A1=C4=97:
> Hi,
>
> I want a postgres client to be able to connect to a postgres sever on
> a remote machine. But i'm not able to make it work. Assume both the
> machines are on a LAN 10.0.0.* .Following available advice, this is
> what i did:
>
> -- In pg_hba.conf, i added the line
> host all all 10.0.0.1/24 <http://10.0.0.1/24> trust
>
> -- In postgresql.conf, i added the line
> listen_addresses =3D 10.0.0.*
>
> -- Restarted the server with the cmd
> ./pg_ctl -D <data_folder> reload
>
>
> This doesn't work. What else should i do to make remote connection wor=
k?
>
> I'm lost! Please help!
>
>
> Thanks a lot,
>
> Shruthi
>
--
Julius Tuskenis
Programavimo skyriaus vadovas
UAB nSoft
mob. +37068233050
--------------040201080704010108050903
Content-Type: text/html; charset=UTF-8
Content-Transfer-Encoding: quoted-printable
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<meta content=3D"text/html; charset=3DUTF-8" http-equiv=3D"Content-Type=
">
</head>
<body bgcolor=3D"#ffffff" text=3D"#000000">
Hello, <br>
<br>
I think you make mistake writing "listen_addresses =3D
10.0.0.*". I doubt it can be done like this... Try "listen_addresses =3D
'*'" first. Also see, that addresses are in form '10.0.0.1' and not
10.0.0.1. (use ' ) <br>
If this doesn't help try telneting server (port 5432) from client
mashine. Maybe theres a firewall in between??<br>
<br>
<br>
2009.11.02 15:26, Shruthi A ra=C5=A1=C4=97:
<blockquote
cite=3D"mid:6caee9520911020526q4216a7b7qfbc792f2677dbc30 [at] mai l.gmail.com"=
type=3D"cite">Hi,<br>
<br>
I want a postgres client to be able to connect to a postgres sever on a
remote machine.=C2=A0 But i'm not able to make it work.=C2=A0 Assume both=
the
machines are on a LAN 10.0.0.* .Following available advice, this is
what i did:<br>
<br>
<meta http-equiv=3D"CONTENT-TYPE" content=3D"text/html; charset=3DUTF-8=
">
<title></title>
<meta name=3D"GENERATOR" content=3D"OpenOffice.org 2.3 (Linux)">
<style type=3D"text/css">
<!--
[at] page { size: 21cm 29.7cm; margin: 2cm }
P { margin-bottom: 0.21cm }
-->
</style>
<p>-- In pg_hba.conf, i added the line<br>
host all all <a moz-do-not-send=3D"true" href=3D"http://10.0.0.1/24">10.0=
=2E0.1/24</a>
trust</p>
<p>-- In postgresql.conf, i added the line<br>
listen_addresses =3D
10.0.0.*</p>
<p>-- Restarted the server with the cmd <br>
=2E/pg_ctl -D <data_folder>
reload</p>
<p><br>
This doesn't work.=C2=A0 What else should i do to make remote connection
work? <br>
</p>
<p>I'm lost!=C2=A0 Please help!</p>
<p><br>
</p>
<p>Thanks a lot,</p>
<p>Shruthi<br>
</p>
</blockquote>
<br>
<br>
<pre class=3D"moz-signature" cols=3D"72">--
Julius Tuskenis
Programavimo skyriaus vadovas
UAB nSoft
mob. +37068233050</pre>
</body>
</html>
--------------040201080704010108050903--
--------------ms080808020909080702060605
Content-Type: application/pkcs7-signature; name="smime.p7s"
Content-Transfer-Encoding: base64
Content-Disposition: attachment; filename="smime.p7s"
Content-Description: S/MIME Cryptographic Signature
MIAGCSqGSIb3DQEHAqCAMIACAQExCzAJBgUrDgMCGgUAMIAGCSqGSIb3DQEH AQAAoIIGJjCC
Aw8wggJ4oAMCAQICCQCB1aFglJHbtzANBgkqhkiG9w0BAQQFADBNMQswCQYD VQQGEwJMVDEL
MAkGA1UECBMCTFQxDjAMBgNVBAoTBW5Tb2Z0MQ4wDAYDVQQLEwVuU29mdDER MA8GA1UEAxMI
blNvZnQgQ0EwHhcNMDkwNjI1MTgyNDUzWhcNMTAwNjI1MTgyNDUzWjBpMQsw CQYDVQQGEwJM
VDEQMA4GA1UEBxMHVmlsbml1czEOMAwGA1UEChMFblNvZnQxGDAWBgNVBAMT D0p1bGl1cyBU
dXNrZW5pczEeMBwGCSqGSIb3DQEJARYPanVsaXVzQG5zb2Z0Lmx0MIGfMA0G CSqGSIb3DQEB
AQUAA4GNADCBiQKBgQC73A+rjzOkfYrVAGaI/pYg0F8RzO7Dti2hhk+bctS4 Ibaz3uPCQi+7
siuWP6zx8wKF6ck3vNVBOMveZzvmjMFeAXnbbBaf0o2QFZ0L083vJawq7lic fLTI5QTTPqvP
jgC8KBWyvWpq6qy1Q7jp3or7A2FKE3fBo68eKr9l/yfE3wIDAQABo4HaMIHX MAkGA1UdEwQC
MAAwLAYJYIZIAYb4QgENBB8WHU9wZW5TU0wgR2VuZXJhdGVkIENlcnRpZmlj YXRlMB0GA1Ud
DgQWBBRtQ3sJDUF6zNynzZXcGFkSbQVCzTB9BgNVHSMEdjB0gBS/CyhXUMKf LMp4f10XvzPh
YV5vRKFRpE8wTTELMAkGA1UEBhMCTFQxCzAJBgNVBAgTAkxUMQ4wDAYDVQQK EwVuU29mdDEO
MAwGA1UECxMFblNvZnQxETAPBgNVBAMTCG5Tb2Z0IENBggkAgdWhYJSR27Iw DQYJKoZIhvcN
AQEEBQADgYEAeSEQ2HdWubGGZWZf+AUFFdsoiFTe4QL6V3z8X1tk7/nOZHOf HdViQRjoGoeg
MVEr5WEv072Pd6Q9IhE2euAB4gVHy3BM3MKGFgB94irjEpm4uHSpRWHF+yp9 up+51F75M8aG
4tZWtbqd7zU0NXwR1ibRWnprWrpmRwgSiN+xVqYwggMPMIICeKADAgECAgkA gdWhYJSR27cw
DQYJKoZIhvcNAQEEBQAwTTELMAkGA1UEBhMCTFQxCzAJBgNVBAgTAkxUMQ4w DAYDVQQKEwVu
U29mdDEOMAwGA1UECxMFblNvZnQxETAPBgNVBAMTCG5Tb2Z0IENBMB4XDTA5 MDYyNTE4MjQ1
M1oXDTEwMDYyNTE4MjQ1M1owaTELMAkGA1UEBhMCTFQxEDAOBgNVBAcTB1Zp bG5pdXMxDjAM
BgNVBAoTBW5Tb2Z0MRgwFgYDVQQDEw9KdWxpdXMgVHVza2VuaXMxHjAcBgkq hkiG9w0BCQEW
D2p1bGl1c0Buc29mdC5sdDCBnzANBgkqhkiG9w0BAQEFAAOBjQAwgYkCgYEA u9wPq48zpH2K
1QBmiP6WINBfEczuw7YtoYZPm3LUuCG2s97jwkIvu7Irlj+s8fMChenJN7zV QTjL3mc75ozB
XgF522wWn9KNkBWdC9PN7yWsKu5YnHy0yOUE0z6rz44AvCgVsr1qauqstUO4 6d6K+wNhShN3
waOvHiq/Zf8nxN8CAwEAAaOB2jCB1zAJBgNVHRMEAjAAMCwGCWCGSAGG+EIB DQQfFh1PcGVu
U1NMIEdlbmVyYXRlZCBDZXJ0aWZpY2F0ZTAdBgNVHQ4EFgQUbUN7CQ1Beszc p82V3BhZEm0F
Qs0wfQYDVR0jBHYwdIAUvwsoV1DCnyzKeH9dF78z4WFeb0ShUaRPME0xCzAJ BgNVBAYTAkxU
MQswCQYDVQQIEwJMVDEOMAwGA1UEChMFblNvZnQxDjAMBgNVBAsTBW5Tb2Z0 MREwDwYDVQQD
EwhuU29mdCBDQYIJAIHVoWCUkduyMA0GCSqGSIb3DQEBBAUAA4GBAHkhENh3 VrmxhmVmX/gF
BRXbKIhU3uEC+ld8/F9bZO/5zmRznx3VYkEY6BqHoDFRK+VhL9O9j3ekPSIR NnrgAeIFR8tw
TNzChhYAfeIq4xKZuLh0qUVhxfsqfbqfudRe+TPGhuLWVrW6ne81NDV8EdYm 0Vp6a1q6ZkcI
EojfsVamMYICmjCCApYCAQEwWjBNMQswCQYDVQQGEwJMVDELMAkGA1UECBMC TFQxDjAMBgNV
BAoTBW5Tb2Z0MQ4wDAYDVQQLEwVuU29mdDERMA8GA1UEAxMIblNvZnQgQ0EC CQCB1aFglJHb
tzAJBgUrDgMCGgUAoIIBljAYBgkqhkiG9w0BCQMxCwYJKoZIhvcNAQcBMBwG CSqGSIb3DQEJ
BTEPFw0wOTExMDIxMzM5MzJaMCMGCSqGSIb3DQEJBDEWBBQcRQFjd5IYQ0he Sn/ErrwHvxJ6
mzBfBgkqhkiG9w0BCQ8xUjBQMAsGCWCGSAFlAwQBAjAKBggqhkiG9w0DBzAO BggqhkiG9w0D
AgICAIAwDQYIKoZIhvcNAwICAUAwBwYFKw4DAgcwDQYIKoZIhvcNAwICASgw aQYJKwYBBAGC
NxAEMVwwWjBNMQswCQYDVQQGEwJMVDELMAkGA1UECBMCTFQxDjAMBgNVBAoT BW5Tb2Z0MQ4w
DAYDVQQLEwVuU29mdDERMA8GA1UEAxMIblNvZnQgQ0ECCQCB1aFglJHbtzBr BgsqhkiG9w0B
CRACCzFcoFowTTELMAkGA1UEBhMCTFQxCzAJBgNVBAgTAkxUMQ4wDAYDVQQK EwVuU29mdDEO
MAwGA1UECxMFblNvZnQxETAPBgNVBAMTCG5Tb2Z0IENBAgkAgdWhYJSR27cw DQYJKoZIhvcN
AQEBBQAEgYAZh9qKzCiHBXzzGFvLyGEpFTL3b0oAhcLHqCA/tVgpJT/Na2Wk NlLwdcOuh+m7
D91BPObiT8J7suLwSXBaBbdt1p2A0nux/DQo0XZAzArX65yAtbVTyyRzUGR6 DJ2hpaoVxeig
/HGrsE1Ab2xVCgS/AVMa2syD1hjYpADOYWszdwAAAAAAAA==
--------------ms080808020909080702060605--
