-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1
"Ranga Nathan" <[EMAIL PROTECTED]> writes:
> Anyone played with Postgresql? I am trying to set the pg_hba.conf so that
> I can access the database (only test now) from anywhere. I dont know what
> to specify under the IP part to allow world access. Also I dont know how
> to get the ssl access working with the hostssl in the config file. I did
> configure it with --with-openssl and it did compile and install clean.
>
> Any clues?
I had a similar issue a couple years ago, where I wanted remote access
to a Postgresql database so I could write a custom GUI to maintain it
instead of having to ssh in and do everything from an xterm. I finally
settled on using an ssh tunnel, which the remote server sees as coming
from localhost, so I didn't have to mess with pg_hba.conf.
ssh -L 5000:localhost:5432 remotehost
listens on port 5000 on the local machine, and passes anything it receives
over to the ssh daemon on "remotehost", which then passes it to port 5432,
which is the port that postgresql uses.
This isn't particularly suited to giving public access to your database,
if
that's what you're after. But for granting access to users who are already
trusted with shell accounts on the server, it works fine.
- --
John Abreau / Executive Director, Boston Linux & Unix
Email [EMAIL PROTECTED] / WWW http://www.abreau.net / PGP-Key-ID 0xD5C7B5D9
PGP-Key-Fingerprint 72 FB 39 4F 3C 3B D6 5B E0 C8 5A 6E F1 2C BE 99
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.2.1 (GNU/Linux)
Comment: Exmh version 2.6 02/09/2003
iQCVAwUBPo9W9lV9A5rVx7XZAQIrLQP/QByct0XjpKhD/6vqhZrVZrAGb2FhcIMp
h5+eazJIoCrbgV26dA2z6iCiqTt/C8q6GDKcSW6DpyaJ1iXfQCBncb1lqs8F1fZK
ENKEBjyOSPeLKzXegXVjj1XcqoEHGRfdTXMEfvSwdnCe7ZjNhPS0A/P2PQlqKbU4
oPGSUROJVEM=
=XeKm
-----END PGP SIGNATURE-----
_______________________________________________
Boston-pm mailing list
[EMAIL PROTECTED]
http://mail.pm.org/mailman/listinfo/boston-pm
