danistation Posted May 31, 2010 Posted May 31, 2010 Hi, I know that new Postgre Databases / Users, and users privileges must be done by cPanel. Well, I have created a new postgree database and a new user to access it. I want to connect this new database using pgAdmin3, on debian: pgAdmin3 configuration: host: danistation.heliohost.org port: 5432 database: dstation_teste user: dstation_teste pass: ****** But I get only error: FATAL: no pg_hba.conf entry for host "my_ip_address", user "dstation_teste", database "dstation_teste", SSL off Is it possible to use pgAdmin3 to connect to this postgre database? Thanks!
Wizard Posted June 1, 2010 Posted June 1, 2010 This support request is being escalated to our root admin.
danistation Posted June 1, 2010 Author Posted June 1, 2010 Is this database hosted at HelioHost? Yes. The database is on heliohost.org. My account is dstation. I created this database by cpanel.danistation.heliohost.org But, I want to connect to this database using pgAdmin3 installed on my debian machine. I receive this error trying to connect. Is it possible? I'm not using iptables or other firewall. I'm directly connected to internet. Thanks.
Ashoat Posted June 1, 2010 Posted June 1, 2010 Sorry, but we don't offer remote PostgreSQL database access Unfortunately, they use a file to set access IPs, so we can't restrict access like we can with MySQL.
danistation Posted June 1, 2010 Author Posted June 1, 2010 Sorry, but we don't offer remote PostgreSQL database access Unfortunately, they use a file to set access IPs, so we can't restrict access like we can with MySQL. Ok, that was my doubt. Thanks for relpy!
Recommended Posts