[Solved] access postgresql remotely

[jagoan]

hello.. is it possible to access postgresql remotely? I need to host postgresql database for app that deployed at cyclic.sh.. thank you..

[Krydos]

Yes, just let us know the PostgreSQL database and the database username and we can enable remote access.

Remote access to MySQL databases can be enabled yourself through Plesk, but Plesk doesn't provide any way for you to do that yourself for PostgreSQL databases so we have to do it for you on the command line.

[jagoan]

hello..

this is the database that I want to remote for now:
- db_name: jagoan_shootingforthestars
- db_user: jagoan_ratel

thank you..

[jagoan]

another db_name that need to remote:
- jagoan_whitepaper
- jagoan_dopefrenzy
- jagoan_poypoy

all db_user are: jagoan_ratel

thank you..

[Krydos]

Remote access enabled.

Note to self: We might need to set a limit to the number of remote access per account until we implement a way for users to enable remote access themselves. 😂

[jagoan]

thank you for the remote access enabled..

so what is the host for remote access? I tried to use the domain (jagoan.helioho.st) & IP (65.19.141.77), but it didn't work.. 

[jagoan]

please I need to allow any IP.. thank you..

[Krydos]

3 hours ago, jagoan said:

so what is the host for remote access?

65.19.141.77 port 5432

2 hours ago, jagoan said:

please I need to allow any IP

Remote access to any IP is already allowed.