nltrade Posted February 14, 2021 Share Posted February 14, 2021 Hi folks, I have created a postgresql database: nltrade_hockey1 with user: nltrade_rh I would like to request remote access to interact with the database. (feel free to delete if posted in incorrectly in duplicate!) Best,RH Link to comment Share on other sites More sharing options...
flazepe Posted February 14, 2021 Share Posted February 14, 2021 This support request is being escalated to our root admins. 1 Link to comment Share on other sites More sharing options...
Krydos Posted February 14, 2021 Share Posted February 14, 2021 Remote access enabled. 1 Link to comment Share on other sites More sharing options...
nltrade Posted February 14, 2021 Author Share Posted February 14, 2021 Remote access enabled. Hi folks, I searched the wiki for remote access documentation but came up empty. Any pointers? Link to comment Share on other sites More sharing options...
Luigi123 Posted February 14, 2021 Share Posted February 14, 2021 Are you talking about if there is a documentation to enable remote access yourself without you having to request Krydos? If so, users don't have permission to do this on a shared host. It always has to be done manually by Krydos and he does this to other users a lot of times. I don’t know about the VPS server but I think you could probably do that on your own because you will have a full root admin access and pretty much you can do anything. Link to comment Share on other sites More sharing options...
nltrade Posted February 15, 2021 Author Share Posted February 15, 2021 Are you talking about if there is a documentation to enable remote access yourself without you having to request Krydos? If so, users don't have permission to do this on a shared host. It always has to be done manually by Krydos and he does this to other users a lot of times. I don’t know about the VPS server but I think you could probably do that on your own because you will have a full root admin access and pretty much you can do anything. Thanks for the reply. No, not looking to enable remote access myself. Is access through ssh? If that is the case, just the address/port to use to ssh in would be great. Link to comment Share on other sites More sharing options...
Luigi123 Posted February 15, 2021 Share Posted February 15, 2021 Unfortunately it’s not available on a shared host. You need a VPS if you want to access the SSH and to run it. Check it out: heliohost.org/vps 1 Link to comment Share on other sites More sharing options...
nltrade Posted February 15, 2021 Author Share Posted February 15, 2021 Unfortunately it’s not available on a shared host. You need a VPS if you want to access the SSH and to run it. Check it out: heliohost.org/vps Thanks, I think I am missing something. My goal is to port a postgresql database from my local server to tommy. I understood that remote access would allow me to do this. Is there no way to port this database without the "upgrade" to VPS? Link to comment Share on other sites More sharing options...
Luigi123 Posted February 15, 2021 Share Posted February 15, 2021 Remote access can be used to connect PostgreSQL DB using host and port: Host=65.19.143.6 (or tommy.heliohost.org)Port=5432 (the default postgresql port) Again, for security reasons, Heliohost does not prove SSH logins for shared hosting accounts Link to comment Share on other sites More sharing options...
rmurthy Posted February 15, 2021 Share Posted February 15, 2021 Remote access in this case will be access to your PostgreSQL DB using the Host and port provided. You can use pg_dump to dump an SQL file that you can import into after connecting to the PostgreSQL server remotely or through Cpanel. Hope this helps and good luck! 1 Link to comment Share on other sites More sharing options...
nltrade Posted February 15, 2021 Author Share Posted February 15, 2021 A great help, many thanks. The documentation at: https://www.a2hosting.ca/kb/developer-corner/postgresql/remote-postgresql-connections proved useful. Link to comment Share on other sites More sharing options...
Recommended Posts