PG_STANDBY ISSUE - Mailing list pgsql-general

From akp geek
Subject PG_STANDBY ISSUE
Date
Msg-id 2024a9fb0911201238uff8900agcec2482927eee30b@mail.gmail.com
Whole thread Raw
Responses Fwd: PG_STANDBY ISSUE  (akp geek <akpgeek@gmail.com>)
Re: PG_STANDBY ISSUE  (Richard Huxton <dev@archonet.com>)
List pgsql-general
Hi experts -

                I am running into issue with pg_standby. May be my understanding is not correct. Please help. here is what I did .

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

Regards


pgsql-general by date:

Previous
From: Lorenzo Allegrucci
Date:
Subject: Re: Strange performance degradation
Next
From: Tom Lane
Date:
Subject: Re: panic failed to add item