[Solved] POSTGRESQL remote access

[saswatsa]

Hi

 

I need remote access to the postgresql database from any ip. 

 

Server: johnny.heliohost.org

 

Postgresql user: "saswatsa_me"

Postgresql database: "saswatsa_SMS_mvc"

 

Thank you in advance

 

[Krydos]

Remote access enabled.

[saswatsa]

please tell me the host address and the port to connect with database.

i am using Pg admin 3 to connect the postgresql server.

[Krydos]

Since you created your account on Johnny the host is johnny.heliohost.org if you're connecting remotely, or localhost if your script is running on the server.

[saswatsa]

i am unable to connect with remote server from my computer

[Krydos]

What is the error message?

[saswatsa]

FATAL: no pg_hba.conf entry for host "203.129.207.133", user "saswatsa_me", database "postgres", SSL on FATAL: no pg_hba.conf entry for host "203.129.207.133", user "saswatsa_me", database "postgres", SSL off 

[saswatsa]

Access to database denied

The server doesn't grant access to the database: the server reports 

FATAL: no pg_hba.conf entry for host "203.129.207.133", user "saswatsa_me", database "postgres", SSL on FATAL: no pg_hba.conf entry for host "203.129.207.133", user "saswatsa_me", database "postgres", SSL off 

To access a database on a PostgreSQL server, you first have to grant primary access to the server for your client (Host Based Authentication). PostgreSQL will check the pg_hba.conf file if a pattern that matches your client address / username / database is present and enabled before any SQL GRANT access control lists are evaluated. 

The initial settings in pg_hba.conf are quite restrictive, in order to avoid unwanted security holes caused by unreviewed but mandatory system settings. You'll probably want to add something like 

host all all 192.168.0.0/24 md5 

This example grants MD5 encrypted password access to all databases to all users on the private network 192.168.0.0/24. 

You can use the pg_hba.conf editor that is built into pgAdmin III to edit the pg_hba.conf configuration file. After changing pg_hba.conf, you need to trigger a server configuration reload using pg_ctl or by stopping and restarting the server process. 

[Krydos]

Postgresql database: "saswatsa_SMS_mvc"

database "postgres"

You have remote access to the database "saswatsa_SMS_mvc" like you requested not the database "postgres".