[Solved] remote access requested

[nltrade]

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

 

 

[Flaze]

This support request is being escalated to our root admins.

[Krydos]

Remote access enabled.

[nltrade]

Remote access enabled.

 

Hi folks, I searched the wiki for remote access documentation but came up empty.  Any pointers? 

[Luigi123]

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.

[nltrade]

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. 

[Luigi123]

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

[nltrade]

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?

[Luigi123]

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

[rmurthy]

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!

[nltrade]

A great help, many thanks. The documentation at: https://www.a2hosting.ca/kb/developer-corner/postgresql/remote-postgresql-connections proved useful.