标签 “postgresql” 下的文章

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

在使用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

错误信息:

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...

阅读全文>>