saswatsa Posted March 24, 2018 Share Posted March 24, 2018 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 Quote Link to comment Share on other sites More sharing options...
Krydos Posted March 24, 2018 Share Posted March 24, 2018 Remote access enabled. Quote Link to comment Share on other sites More sharing options...
saswatsa Posted March 31, 2018 Author Share Posted March 31, 2018 please tell me the host address and the port to connect with database.i am using Pg admin 3 to connect the postgresql server. Quote Link to comment Share on other sites More sharing options...
Krydos Posted March 31, 2018 Share Posted March 31, 2018 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. Quote Link to comment Share on other sites More sharing options...
saswatsa Posted April 5, 2018 Author Share Posted April 5, 2018 i am unable to connect with remote server from my computer Quote Link to comment Share on other sites More sharing options...
Krydos Posted April 6, 2018 Share Posted April 6, 2018 What is the error message? Quote Link to comment Share on other sites More sharing options...
saswatsa Posted April 17, 2018 Author Share Posted April 17, 2018 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 Quote Link to comment Share on other sites More sharing options...
saswatsa Posted April 17, 2018 Author Share Posted April 17, 2018 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. Quote Link to comment Share on other sites More sharing options...
Krydos Posted April 17, 2018 Share Posted April 17, 2018 Postgresql database: "saswatsa_SMS_mvc"database "postgres"You have remote access to the database "saswatsa_SMS_mvc" like you requested not the database "postgres". Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.