Jump to content

[Solved] PostgreSQL Remote Access


gaubry

Recommended Posts

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

Link to comment
Share on other sites

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 by gaubry
Link to comment
Share on other sites

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.
Link to comment
Share on other sites

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.

Link to comment
Share on other sites

Guest
This topic is now closed to further replies.
×
×
  • Create New...