[Solved] remote access for postgres DBs.

[hspierre]

Hey guys, would very much appreciate if I could get remote access for postgres DBs.

database: hspierre_helio

user:  hspierre_1

host:  hspierre.helioho.st

[MoneyBroz]

This support request is being escalated to our root admins.

[hspierre]

thanks. I am wondering how long it will be done. Thanks again

[Krydos]

Before remote access can be enabled, you need to actually create the database and database user. I see a MariaDB database with the name you listed above. You can enable remote connections yourself through Plesk for MariaDB though so you don't need to contact us for that.

[hspierre]

I did enable remote access, but it shows error as attachment. Can you tell me how to fix it. Thanks again

[wolstech]

MariaDB and Postgres are two entirely different database systems and aren't compatible with each other. You created a MariaDB database but are trying to connect using a Postgres tool.

You need to do one of the following:

• Create a postgres database instead, then have Krydos enable remote access on it, then connect to it.
• Use software designed for MariaDB to connect to the database you already created.

Which one you do will depend on what database type you actually need...

 

Also, the server hostname should be tommy2.heliohost.org, not your domain.

 

 

[hspierre]

Thanks. I created one postgresql db and it shows another error as attachment. Please tell me how to fix it. Thanks again.

By the way, please tell me what is Krydos. I have no idea for what you describe "Krydos enable remote access on it"

[Unknown025]

Krydos is a root administrator, he will be able to help you if you choose PostgreSQL and need remote access.

[hspierre]

Hey Krydos , would very much appreciate if I could get remote access for postgres DBs. the error is as attachment. Thanks

 

database: hspierre_invdb

user:  hspierre_invdb_1

host:  ommy2.heliohost.org

 

[Ookma-Kyi]

@Krydos hspierre needs remote access to his PostgreSQL database.

 

@hspierre Have you considered using MariaDB, it might be faster as far as getting remote access goes.

Some helpful reading while you wait.

Edited August 3 by Ookma-Kyi

[Krydos]

Remote access enabled.

host=65.19.154.94
port=5432
username=hspierre_invdb_1
dbname=hspierre_invdb
password=<set in Plesk>

 

[hspierre]

it works. thanks a lot