on-rev remote database

[Len Morgan]

  Pierre,

I'm trying to write a program that will access data on a public database 
(Postgresql) and I don't really want to give pgAdmin to all of my 
users.  That would be disaster!  The localhost only access has never 
been the case.  I've been using Postgres for more than 15 years now and 
I always have users access a common database (although it's always been 
from a private network).

pgAdmin remote access is not my problem.  It's access to the data from 
the outside.  I can always use cPanel if I need to maintain the database 
but I've got to have remote access for end users (who could be anywhere 
in the world).

len


On 10/17/2010 7:27 PM, Pierre Sahores wrote:
> Ien,
>
> You can't do this because the on-rev PostgreSQL servers security rules (following in this the best practices recommanded by the PostgreSQL team) are set to allow localhost connections only. Why don't you  simply use the on-Rev phpPgAdmin panel from your home box ? Works perfect and let us do exactly all what we could do in using PgAdmin on the 5432 unprotected port.
>
> HTH,
>
> Pierre
>
> Le 17 oct. 2010 à 21:42, Len Morgan a écrit :
>
>> Pierre,
>>
>> I'm not having any trouble with the phpPgAdmin because that's running on the same server as Postgres is.  What I'm trying to do is use (for the time being) PgAdmin from my computer at home to talk to the server at on-rev.  So far, all I get is a message that there is no server listening there so I'm thinking it's some sort of firewall issue.  Has anyone been able to successfully connect to Postgres on on-rev from a remote computer?
>>
>> len
>>
>>
>> On 10/17/2010 11:52 AM, Pierre Sahores wrote:
>>> Ien,
>>>
>>> There went some troubles, full solved months ago, about login to the phpPgAdmin panel of the cPanel, on the loki server at least. All worked from that time 100% well. Both MySQL and PostgreSQL are yet full usable in the on-rev environment and some of my apps use both on a 24/7 basis (MySQL for the earliest ones, and PostgreSQL for all the other and next to come.
>>>
>>> HTH,
>>>
>>> Pierre
>>>
>>> Le 17 oct. 2010 à 13:05, Len Morgan a écrit :
>>>
>>>> I seem to remember someone having trouble connecting to a database on their on-rev account remotely a while back.  Was this ever resolved?  I'd like to have a database that can be accessed from anywhere but I'd rather not go through the hoops of making a web service to get at the data.
>>>>
>>>> Was this too much of a security issue for the hosting service to allow?
>>>>
>>>> len morgan
>>>> _______________________________________________
>>>> use-revolution mailing list
>>>> use-revolution at lists.runrev.com
>>>> Please visit this url to subscribe, unsubscribe and manage your subscription preferences:
>>>> http://lists.runrev.com/mailman/listinfo/use-revolution
>>>>
>>> --
>>> Pierre Sahores
>>> mobile : (33) 6 03 95 77 70
>>>
>>> www.woooooooords.com
>>> www.sahores-conseil.com
>>>
>>>
>>>
>>>
>>>
>>>
>>> _______________________________________________
>>> use-revolution mailing list
>>> use-revolution at lists.runrev.com
>>> Please visit this url to subscribe, unsubscribe and manage your subscription preferences:
>>> http://lists.runrev.com/mailman/listinfo/use-revolution
>>>
>>>
>> _______________________________________________
>> use-revolution mailing list
>> use-revolution at lists.runrev.com
>> Please visit this url to subscribe, unsubscribe and manage your subscription preferences:
>> http://lists.runrev.com/mailman/listinfo/use-revolution
>>
> --
> Pierre Sahores
> mobile : (33) 6 03 95 77 70
>
> www.woooooooords.com
> www.sahores-conseil.com
>
>
>
>
>
>
> _______________________________________________
> use-revolution mailing list
> use-revolution at lists.runrev.com
> Please visit this url to subscribe, unsubscribe and manage your subscription preferences:
> http://lists.runrev.com/mailman/listinfo/use-revolution
>
>