On-Rev and PostgreSQL

[Trevor DeVore]

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
Blue Mango Learning Systems
ScreenSteps: http://www.screensteps.com
Releasable Revolution Resources for Developers: http://revolution.bluemangolearning.com