The below are issues and fix with Vagrant and PG / Ora software related : **************************************************************************** 1. How do I prevent “No supported authentication methods available” when using putty to connect vagrant machine go to /etc/sshd/sshd-config -> change PasswordAuthenticator as Yes from No and save it and restart machine 2. How to fix from windows to PG Linux server connectivity.. To check ip tables off or not in vagrant linux or vm [root@pgnode1 bin]# iptables -nvL Chain INPUT (policy ACCEPT 0 packets, 0 bytes) pkts bytes target prot opt in out source destination Chain FORWARD (policy ACCEPT 0 packets, 0 bytes) pkts bytes target prot opt in out source destination Chain OUTPUT (policy ACCEPT 0 packets, 0 bytes) pkts bytes target prot opt in out source destination [root@pgnode1 bin]# iptab
How to do Streaming / Replication Setup on PG : ************************************* Stage 1 : Note down, In this Stage 1, The below example shows that Primary and Standby replication only..No fail over & Fail Back.. For failover , refer stage 2 and fail back refer stage 3 . Primary : Primary Side : 192.168.100.11 Secondary : 192.168.100.12 1. CREATE USER replicator WITH REPLICATION ENCRYPTED PASSWORD 'replicator'; 2. Edit postgresql.conf as below ALTER SYSTEM SET wal_level TO 'replica'; Must be at least set to hot_standby until version 9.5 or replica ALTER SYSTEM SET archive_mode TO 'ON'; ALTER SYSTEM SET max_wal_senders TO '3'; ALTER SYSTEM SET wal_keep_segments TO '10'; ALTER SYSTEM SET listen_addresses TO '*'; ALTER SYSTEM SET hot_standby TO 'ON'; ALTER SYSTEM SET archive_command TO 'cp %p /mnt/server/archivedir/%f'; You may not need archive_mode or archive_command or res