blog/content/middleware/postgresql_in_short.md

---

title: "Postgresql 操作" date: 2022-10-12T15:06:02+07:00

draft: true

基本环境

• OS: Manjaro(Arch Serial)
• Postgresql: v14.5.1

手册

https://github.com/postgres-cn/pgdoc-cn

安装

pacman -S postgresql

升级问题

滚动更新后会更新 Postgresql 到新版本，再次启动 systemctl restart postgresql 后可能会报错 An old version of the database format was found. 导致启动失败。解决如下

https://webhostinggeeks.com/howto/how-to-fix-an-old-version-of-the-database-format-was-found-while-starting-postgresql/

升级数据 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

Export Import https://www.prisma.io/dataguide/postgresql/inserting-and-modifying-data/importing-and-exporting-data-in-postgresql#data-export-with-pg_dump