calkarob Posted January 5, 2020 Share Posted January 5, 2020 Requesting remote access to PostgreSQL database.Please add access to all db from any ip === listen_addresses = '*' Thanks in advance! Link to comment Share on other sites More sharing options...
flazepe Posted January 5, 2020 Share Posted January 5, 2020 I'm not sure if we would allow "all db". Just in case, what are the databases that you need remote access to? 1 Link to comment Share on other sites More sharing options...
calkarob Posted January 5, 2020 Author Share Posted January 5, 2020 I just dont want to bother you each time I will create new db...For now dbs: calkarob_first_test and calkarob_standard THank you for quick response Link to comment Share on other sites More sharing options...
Luigi123 Posted January 5, 2020 Share Posted January 5, 2020 This support request is being escalated to our root admin. Link to comment Share on other sites More sharing options...
flazepe Posted January 5, 2020 Share Posted January 5, 2020 ...I already escalated it? This happened twice already. Perhaps it's because I didn't say it. 1 Link to comment Share on other sites More sharing options...
Luigi123 Posted January 5, 2020 Share Posted January 5, 2020 ...I already escalated it? This happened twice already. Perhaps it's because I didn't say it.No you didn’t say it though. Link to comment Share on other sites More sharing options...
flazepe Posted January 5, 2020 Share Posted January 5, 2020 Okay. I just thought you were farming posts. Link to comment Share on other sites More sharing options...
calkarob Posted January 5, 2020 Author Share Posted January 5, 2020 Thank you for the information, but I still have problem with psql: FATAL: no pg_hba.conf entry for host "89.74.136.109", user "calkarob_first_user", Link to comment Share on other sites More sharing options...
yashrs Posted January 5, 2020 Share Posted January 5, 2020 Hi @calkarob, please wait for Krydos to enable it for you. Link to comment Share on other sites More sharing options...
Krydos Posted January 6, 2020 Share Posted January 6, 2020 Remote access enabled. Link to comment Share on other sites More sharing options...
calkarob Posted January 11, 2020 Author Share Posted January 11, 2020 Thank you for effort, but I still receive same error when I want use command: $ psql --host=65.19.141.67 --port=5432 --dbname=calkarob_first_test --username=calkarob_first_test Error:psql: FATAL: no pg_hba.conf entry for host "89.74.136.109", user "calkarob_first_test", database "calkarob_first_test", SSL off Link to comment Share on other sites More sharing options...
Krydos Posted January 11, 2020 Share Posted January 11, 2020 I enabled remote connections to the database calkarob_first_test from the user calkarob_first_user. Link to comment Share on other sites More sharing options...
calkarob Posted January 19, 2020 Author Share Posted January 19, 2020 Thank you, it's working just great! I also want to make Set-Up Master (johnny.heliohost.org) - Slave (my local mashine) Replication for PostgreSQL... but I think I can't edit file postgresql.confMaybe you can help me to setup in the best way it's possible... I want few changes if this is posible: wal_level = hot_standbysynchronous_commit = localmax_wal_senders = 5wal_keep_segments = 32synchronous_standby_names = 'pgslave001'archive_mode = onarchive_command = 'cp %p /var/lib/postgresql/9.6/main/archive/%f' Link to comment Share on other sites More sharing options...
vannoty Posted January 21, 2020 Share Posted January 21, 2020 Hello I would like to request for enable PostgreSQL Remote Access. Thanks, vannoty Link to comment Share on other sites More sharing options...
flazepe Posted January 21, 2020 Share Posted January 21, 2020 Please create a new thread and make sure to include the PostgreSQL user and database name. Link to comment Share on other sites More sharing options...
Recommended Posts