[Solved] PostgreSQL Remote Access

[calkarob]

Requesting remote access to PostgreSQL database.

Please add access to all db from any ip === listen_addresses = '*'

 

 

Thanks in advance!

 

[Flaze]

I'm not sure if we would allow "all db". Just in case, what are the databases that you need remote access to?

[calkarob]

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

[Luigi123]

This support request is being escalated to our root admin.

[Flaze]

...I already escalated it? This happened twice already. Perhaps it's because I didn't say it.

[Luigi123]

...I already escalated it? This happened twice already. Perhaps it's because I didn't say it.

No you didn’t say it though.

[Flaze]

Okay. I just thought you were farming posts.

[calkarob]

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",

[yashrs]

Hi @calkarob, please wait for Krydos to enable it for you.

[Krydos]

Remote access enabled.

[calkarob]

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

[Krydos]

I enabled remote connections to the database calkarob_first_test from the user calkarob_first_user.

[calkarob]

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.conf

Maybe you can help me to setup in the best way it's possible...

 

I want few changes if this is posible:

 

wal_level = hot_standby

synchronous_commit = local

max_wal_senders = 5

wal_keep_segments = 32

synchronous_standby_names = 'pgslave001'

archive_mode = on
archive_command = 'cp %p /var/lib/postgresql/9.6/main/archive/%f'

[vannoty]

Hello   I would like to request for enable PostgreSQL Remote Access.

 

 

 

 

Thanks,

 

vannoty

 

[Flaze]

Please create a new thread and make sure to include the PostgreSQL user and database name.