1、切换
[root@pg2 ~]# cd /tmp/
[root@pg2 tmp]# touch postgresql.trigger.5432
2、确认切换是否成功
1)查看recovery文件
[root@pg2 tmp]# cd /u01/pg9.1/data
[root@pg2 data]# ls
recovery.done
2)查看recovery的状态
[root@pg2 data]# su - postgres
[postgres@pg2 ~]$ psql
sfdb=# select pg_is_in_recovery();
pg_is_in_recovery
-------------------
f
(1 row)
3)查看日志
[postgres@pg2 ~]$ cd /u01/pg9.1/data/pg_log/
[postgres@pg2 pg_log]$ cat postgresql-2012-02-28_063145.log
LOG: archive recovery complete
LOG: autovacuum launcher started
LOG: database system is ready to accept connections