二重化主备切换过程中Postgresql的状态变化

发表于 2017-05-16 | 分类于技术

在使用pacemaker部署的主备服务器环境中，由于使用到了postgresql，对其复杂的状态变化做了如下整理。

1.pgsql-status

￭PRI : running as Primary(Master)
￭HS : running as Hot Standby(Slave)
    HS:alone : running as Hot Standby,not connected to Primary
    HS:async : running as Hot Standby in Asynchronous replication mode
    HS:sync : running as Hot Standby in Synchronous replication mode
￭STOP : stopped

阅读全文 »

PostgreSQL 启动错误：No space left on device

发表于 2015-12-30 | 分类于技术

错误信息：

pg_ctl[2442]: FATAL:  could not create semaphores: No space left on device
pg_ctl[2442]: DETAIL:  Failed system call was semget(5432129, 17, 03600).
pg_ctl[2442]: HINT:  This error does *not* mean that you have run out of disk space...

阅读全文 »