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

synchronous_standby_names = 'pgslave001'

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

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:

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

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

Requesting remote access to PostgreSQL database.

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

Thanks in advance!