Postgres Pro
Downloads
Home   >   mailing lists

Re: running postgresql on a private machine accessing it from public web pages - Mailing list pgsql-general

From Joshua D. Drake
Subject Re: running postgresql on a private machine accessing it from public web pages
Date
Msg-id 1242925349.16418.12.camel@jd-laptop.pragmaticzealot.org
Whole thread Raw
In response to running postgresql on a private machine accessing it from public web pages  ("Keith D. Evans" <evans@umbc.edu>)
Responses Re: running postgresql on a private machine accessing it from public web pages  ("Keith D. Evans" <evans@umbc.edu>)
List pgsql-general
Tree view 
> 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

--
PostgreSQL - XMPP: jdrake@jabber.postgresql.org
   Consulting, Development, Support, Training
   503-667-4564 - http://www.commandprompt.com/
   The PostgreSQL Company, serving since 1997

pgsql-general by date:

Previous
From: "Keith D. Evans"
Date:
Subject: running postgresql on a private machine accessing it from public web pages
Next
From: Kenneth Tilton
Date:
Subject: Postgres, DB design, and object IDs (of any ilk)