title: "Postgresql 操作" date: 2022-10-12T15:06:02+07:00
https://github.com/postgres-cn/pgdoc-cn
pacman -S postgresql
滚动更新后会更新 Postgresql 到新版本,再次启动 systemctl restart postgresql 后可能会报错 An old version of the database format was found. 导致启动失败。解决如下
升级数据 https://suay.site/?p=1130
stream replica https://girders.org/postgresql/2021/11/05/setup-postgresql14-replication/
logic replica https://hevodata.com/learn/postgresql-master-slave-replication/#intro
Connection pool https://github.com/yandex/odyssey https://pgpool.net/mediawiki/index.php/Main_Page
Replication extension https://github.com/2ndQuadrant/pglogical