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 = 5wal_keep_segments = 32synchronous_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: psql: FATAL: no pg_hba.conf entry for host "89.74.136.109", user "calkarob_first_test", database "calkarob_first_test", SSL off

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!