hot standby 切换

 

 

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