On-Rev and PostgreSQL

[Rick Harrison]

Hi Trevor,

I appreciate your suggestions.  I'm conducting research on
the problems, and I'll get back to you with any answers I may find.

Thanks again,

Rick


On Nov 17, 2009, at 1:11 PM, 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).
> 
> -- 
> Trevor DeVore