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

## 安装

```shell
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

```shell

```

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