PGCluster 之一 setup

超、凢脫俗 2023-02-18 01:45 37阅读 0赞

PGCluster is a multi-master and synchronous replication tool of PostgreSQL based on shared-nothing architecture, developed by Atsushi Mitani and PGCluster developer’s team.

The lead developer of pgCluster has moved on to pgCluster2, and all development on pgCluster has halted. While pgCluster’s code is not fully mature, it is being used in production at a few sites.

A complete pgcluster requires at least 6 machines (3 database servers, 2 load balancers and a monitoring/failover controller). Also, it requires modifications to PostgreSQL core, so the Postgres version of pgCluster is always behind the mainstream version.

  1. 192.168.56.101 lb1
  2. 192.168.56.102 lb2
  3. 192.168.56.103 mf1
  4. 192.168.56.111 n1
  5. 192.168.56.112 n2
  6. 192.168.56.113 n3

版本

  1. # cat /etc/centos-release
  2. CentOS Linux release 7.4.1708 (Core)
  3. #
  4. #
  5. # yum list installed |grep -i postgresql
  6. postgresql11.x86_64 11.8-1PGDG.rhel7 @pgdg11
  7. postgresql11-contrib.x86_64 11.8-1PGDG.rhel7 @pgdg11
  8. postgresql11-debuginfo.x86_64 11.5-1PGDG.rhel7 @pgdg11
  9. postgresql11-devel.x86_64 11.8-1PGDG.rhel7 @pgdg11
  10. postgresql11-docs.x86_64 11.8-1PGDG.rhel7 @pgdg11
  11. postgresql11-libs.x86_64 11.8-1PGDG.rhel7 @pgdg11
  12. postgresql11-llvmjit.x86_64 11.8-1PGDG.rhel7 @pgdg11
  13. postgresql11-odbc.x86_64 12.01.0000-1PGDG.rhel7 @pgdg11
  14. postgresql11-plperl.x86_64 11.8-1PGDG.rhel7 @pgdg11
  15. postgresql11-plpython.x86_64 11.8-1PGDG.rhel7 @pgdg11
  16. postgresql11-pltcl.x86_64 11.8-1PGDG.rhel7 @pgdg11
  17. postgresql11-server.x86_64 11.8-1PGDG.rhel7 @pgdg11
  18. postgresql11-tcl.x86_64 2.4.0-2.rhel7.1 @pgdg11
  19. postgresql11-test.x86_64 11.8-1PGDG.rhel7 @pgdg11
  20. # su - postgres
  21. Last login: Wed Jan 15 18:34:12 CST 2020 on pts/0
  22. $
  23. $
  24. $ psql -c "select version();"
  25. version
  26. ---------------------------------------------------------------------------------------------------------
  27. PostgreSQL 11.8 on x86_64-pc-linux-gnu, compiled by gcc (GCC) 4.8.5 20150623 (Red Hat 4.8.5-39), 64-bit
  28. (1 row)

版本

https://www.postgresql.org/ftp/projects/pgFoundry/pgcluster/

看上去已经停止开发了。

在这里插入图片描述

参考:
http://wiki.postgresql.org/wiki/PgCluster

发表评论

表情:
评论列表 (有 0 条评论,37人围观)

还没有评论,来说两句吧...

相关阅读

    相关 __setup

    > 原文网址:[\_\_setup\_IT利刃出鞘的博客-CSDN博客\_\_\_setup][setup_IT_-CSDN_setup] > > 目录 > > 作用