On-Rev and PostgreSQL

[Len Morgan]

The file you'll need to look at (and possibly modify) is the pg_hba.conf 
file in the directory above where PostgreSQL stores the actual data 
tables.  It is very well commented (you'll want to go near the bottom of 
the  file to see the examples that come with the standard distribution).

You are allowed to control access to individual databases by not only 
username/password but also by IP/domain name, whether it is on a secure 
connection etc.  I'm not sure if the PostgreSQL admin program let's you 
do that or not.  I've been using PostgreSQL  since version 1.09 (about 
12 years) and so have "grown up" modifying the files with a text editor.

On a similar point though, how would you even get the revdb.dll "into" 
the revLet so that it could access ANY database?  Since revLets are 
supposed to be platform neutral, how would it know which dll/bundle/so 
to load in the browser?  Has anyone managed to access ANY database from 
a revLet?  If so, could you provide a short script showing how?  I'd 
really like to use SQL Yoga in a revLet but I haven't figured out this 
(very basic) little detail.

len


Trevor DeVore wrote:
> On Nov 15, 2009, at 8:38 PM, Rick Harrison wrote:
>
>> Since the people at Revolution say that PostgreSQL
>> should work fine on their On-Rev server I think that
>> perhaps they should be held accountable for their
>> advertising of said capabilities.
>
> I imagine PostgreSQL works fine if you connect from localhost. Does 
> the database work if you connect with an .irev page running on the 
> server? Usually a database won't allow a user to connect from a remote 
> server without you explicitly telling the database to allow them to do 
> so.
>
>> So the question still remains: "Has anyone out there
>> been able read and write to a PostgreSQL database
>> on an On-Rev server using a revlet?"
>
> I haven't tried, but if you are having trouble then I would check 
> whether or not you authorized the user you are connecting with to 
> connect from outside hosts. By default the database user is usually 
> restricted to connecting from localhost only (at least with MySQL).
>