I am running into issue with pg_standby. May be my understanding is not correct. Please help. here is what I did .
- I made changes in the postgresql.conf ( archive_mode = on ,archive_command = 'cp -i %p /opt/postgres/archive/%f' , archive_timeout = 60s )
- pg_ctl start -D $PGDATA -l /opt/postgres/logfile
- postgres=# select pg_start_backup('BKP_LBL');
- I have done the base backup and I have used the following command for restore in the recovery.conf
- restore_command = 'pg_standby -d -s 3 -t /tmp/pg_standby.trigger.5432 /opt/postgres/archive/%f %p %r'
- postgres=# select pg_stop_backup();
- Now I have made some changes to the master database and I waited for 30 minutes
- I have stopped the master database
- I have started the slave. But I did not find the changes I have done after I issued the command elect pg_stop_backup();
- The log files have shipped to archive folder
Is there some thing wrong with the I am doing the procedure. Please help
Regards
