[Solved] PostgreSQL Remote Access

[gaubry]

Hello,

 

I also like to request remote access to one of my PostgreSQL database.

 

Server: gaubry dot heliohost us

Database Name: gaubry_bibliography

Database user: gaubry_bibliography

Access: all IPs

 

Hope I posted at the right place!

 

Best,

GA

[Flaze]

This support request is being escalated to our root admins.

[gaubry]

Thanks.

 

When it will be active, do I understand well that I have to connect to my database like this?

 

$ psql -h <MYUSERNAME>.heliohost us -d <databaseName> -U <databaseUser>

Edited April 26, 2021 by gaubry

[Luigi123]

Please wait for Krydos when he gets a chance to enabled those for you.

 

He usually on here sometimes but because he has been keeping himself busy doing things for Heliohost.

[Krydos]

Database Name: gaubry_bibliography

Database user: gaubry_bibliography

In mysql it is common practice to have a user with the same name as a database, but in postgresql it isn't allowed. Please provide a user that doesn't have the same name as an existing database.

[gaubry]

Thanks for the answer !

Apparently, gaubry_bibliography does not exist anymore. Did you change it? If yes, I'm ok with the change you did and you can proceed to open the remote access.

[Krydos]

I did not change it. I likely never existed because cpanel won't allow you to create a postgresql database user that has the same name as a database. If you want remote access you need to provide the database and the username you want to have access.

[gaubry]

Ups... Sorry, then I did a mistake in my request:

Database name is gaubry_bibliography
User is gaubry_gaubry

Thanks!

[Krydos]

Remote access enabled.