| From: | akp geek <akpgeek(at)gmail(dot)com> |
|---|---|
| To: | pgsql-general(at)postgresql(dot)org |
| Subject: | PG_STANDBY ISSUE |
| Date: | 2009-11-20 20:38:14 |
| Message-ID: | 2024a9fb0911201238uff8900agcec2482927eee30b@mail.gmail.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | 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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tom Lane | 2009-11-20 21:33:31 | Re: panic failed to add item |
| Previous Message | Lorenzo Allegrucci | 2009-11-20 20:26:10 | Re: Strange performance degradation |