Joshua,
Let me rephrase what I wrote. The database is on a public machine
(Linux), but the postgresql postmaster runs on a private machine
(Solaris 10). Can we access the postgresql database through the public
machine, even though the postmaster is running from a (different)
private machine?
thanx
keith
Joshua D. Drake wrote:
So, the question is, can someone go through these (public) web pages and
access the postgresql database if the postgresql server is running on
the private machine?
We have other data in the postgresql and would like to only have to use
one database types, i.e., postgresql.
If you are using proper host control then yes you can make it so that
the PHP user is only able to access the public data in the private
database. See here:
http://www.postgresql.org/docs/8.3/static/client-authentication.html
http://www.postgresql.org/docs/8.3/static/user-manag.html
Sincerely,
Joshua D. Drake
--
"Nonviolence is not a cover for cowardice, but it is the supreme virtue of the brave." Mohandas Karamchand Gandhi
=======================================================
Keith D. Evans
Joint Center for Earth Systems Technology/UMBC
(301) 614-6282 (M,Tu)
(410) 455-5751 (W,Th,F)
http://www.jcet.umbc.edu/bios/evanmain.html
========================================================
Any opinions expressed in this email are not those of
NASA, or the Goddard Space Flight Center, or the Joint
Center for Earth Systems Technology or the University
of Maryland Baltimore County.
========================================================
--
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
