So in your recovery.conf is standby_mode set to on?
standby_mode = 'on'primary_conninfo = 'host=${MASTER_PORT_5432_TCP_ADDR} port=5432 user=${REP_USER} password=${REP_PASS}'trigger_file = '/tmp/promote_db_slave'
On 04/09/2015 12:46 PM, Volkan Unsal wrote: Hi Amit, My postgresql.conf file in the standby server looks like this: wal_level = hot_standby hot_standby = on max_standby_streaming_delay = 15min In the master server, it looks like this: listen_addresses = '*' wal_level = hot_standby max_wal_senders = 10 max_connections=100 checkpoint_segments = 8 wal_keep_segments = 8 archive_mode = on archive_command = 'cp %p /var/lib/postgresql/archive/%f' So in your recovery.conf is standby_mode set to on? -- Adrian Klaveradrian.klaver@aklaver.com
Hi Amit, My postgresql.conf file in the standby server looks like this: wal_level = hot_standby hot_standby = on max_standby_streaming_delay = 15min In the master server, it looks like this: listen_addresses = '*' wal_level = hot_standby max_wal_senders = 10 max_connections=100 checkpoint_segments = 8 wal_keep_segments = 8 archive_mode = on archive_command = 'cp %p /var/lib/postgresql/archive/%f'
pgsql-general by date:
Соглашаюсь с условиями обработки персональных данных