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@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@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@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@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@lists.runrev.com
Please visit this url to subscribe, unsubscribe and manage your subscription
preferences:
http://lists.runrev.com/mailman/listinfo/use-revolution