[PostgreSQL] PostgreSQL 18 버전 및 pgvector 활성화 방법

사전 패키지 설치

sudo apt install curl

Percona repository 설정

Percona 웹사이트에서 percona-release 패키지 패치(Fetch)

wget https://repo.percona.com/apt/percona-release_latest.$(lsb_release -sc)_all.deb

percona-release 패키지 설치

sudo dpkg -i percona-release_latest.$(lsb_release -sc)_all.deb

로컬 캐시 리프레시

sudo apt update

리포지토리 활성화

sudo percona-release setup ppg-18

패키지 수동 설치

sudo apt install -y percona-postgresql-18

sudo apt install -y percona-postgresql-18-repack

sudo apt install -y percona-postgresql-18-pgaudit

sudo apt install -y percona-pgbackrest

sudo apt install -y percona-patroni

sudo apt install -y percona-pgbouncer

sudo apt install -y percona-pgaudit18-set-user

sudo apt install -y percona-pgbadger

sudo apt install -y percona-postgresql-18-wal2json

sudo apt install -y percona-postgresql-contrib

sudo apt install -y percona-haproxy

sudo apt install -y percona-pgpool2

sudo apt install -y percona-pg-gather

sudo apt install -y percona-postgresql-18-pgvector

서비스 시작

postgresql 실행

sudo systemctl status postgresql.service

 

설치 확인

psql --version

psql (PostgreSQL) 18.1 - Percona Server for PostgreSQL 18.1.1

 

접속 방법

su - postgres

psql

 

pgvector 확장 활성화

pgvector extension 설치 확인

postgres=# SELECT * FROM pg_available_extensions WHERE name = 'vector';
  name  | default_version | installed_version |                       comment
--------+-----------------+-------------------+------------------------------------------------------
 vector | 0.8.1           |                   | vector data type and ivfflat and hnsw access methods
(1 row)

 

pgvector 활성화

postgres=# CREATE EXTENSION IF NOT EXISTS vector;
CREATE EXTENSION

활성화된 확장 확인

postgres=# \dx
                                      List of installed extensions
  Name   | Version | Default version |   Schema   |                     Description
---------+---------+-----------------+------------+------------------------------------------------------
 plpgsql | 1.0     | 1.0             | pg_catalog | PL/pgSQL procedural language
 vector  | 0.8.1   | 0.8.1           | public     | vector data type and ivfflat and hnsw access methods
(2 rows)

 

---

참고

설치 과정 공식 문서
https://docs.percona.com/postgresql/18/apt.html

postgresql 접속 방법 공식 문서
https://docs.percona.com/postgresql/18/connect.html

pgvector 활성화 방법 공식 문서
https://docs.percona.com/postgresql/18/enable-extensions.html#pgpool2