*postgresql.conf:* wal_level = hot_standby hot_standby = on archive_mode = on archive_command = 'cp %p ../archive/%f' ## "archive" parallel to data directory max_wal_senders = 10 ## number of slaves
*recovery.conf(in slave)* restore_command = 'cp ../archive/%f "%p"' standby_mode = 'on' primary_conninfo = 'host=MASTERIP port=5432 user=REPLUSER password=REPLPASS' trigger_file = '/tmp/pg_failover_trigger' recovery_target_timeline='latest' *pg_hba.conf* host replication REPLUSER 0.0.0.0/0 md5 The above entries to be added for replication to be configured. -Senthil -- View this message in context: http://postgresql.1045698.n5.nabble.com/streaming-replication-wal-shipping-tp5799821p5800081.html Sent from the PostgreSQL - general mailing list archive at Nabble.com. -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
