hspierre Posted August 2 Share Posted August 2 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 Link to comment Share on other sites More sharing options...
MoneyBroz Posted August 2 Share Posted August 2 This support request is being escalated to our root admins. Link to comment Share on other sites More sharing options...
hspierre Posted August 2 Author Share Posted August 2 thanks. I am wondering how long it will be done. Thanks again Link to comment Share on other sites More sharing options...
Krydos Posted August 2 Share Posted August 2 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. Link to comment Share on other sites More sharing options...
hspierre Posted August 3 Author Share Posted August 3 I did enable remote access, but it shows error as attachment. Can you tell me how to fix it. Thanks again Link to comment Share on other sites More sharing options...
wolstech Posted August 3 Share Posted August 3 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. Link to comment Share on other sites More sharing options...
hspierre Posted August 3 Author Share Posted August 3 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" Link to comment Share on other sites More sharing options...
Unknown025 Posted August 3 Share Posted August 3 Krydos is a root administrator, he will be able to help you if you choose PostgreSQL and need remote access. Link to comment Share on other sites More sharing options...
hspierre Posted August 3 Author Share Posted August 3 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 Link to comment Share on other sites More sharing options...
Ookma-Kyi Posted August 3 Share Posted August 3 (edited) @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 Link to comment Share on other sites More sharing options...
Krydos Posted August 4 Share Posted August 4 Remote access enabled. host=65.19.154.94 port=5432 username=hspierre_invdb_1 dbname=hspierre_invdb password=<set in Plesk> Link to comment Share on other sites More sharing options...
hspierre Posted August 4 Author Share Posted August 4 it works. thanks a lot Link to comment Share on other sites More sharing options...
Recommended Posts