[EtC] Debian13 에서 PostgreSQL 17 설치

 

root@DATABASE:~# apt-get install gnupg2
Installing:                     
  gnupg2

Installing dependencies:
  dirmngr  gnupg  gnupg-l10n  gnupg-utils  gpg  gpg-agent  gpg-wks-client  gpgconf  gpgsm  gpgv  libassuan9  libgcrypt20  libgpg-error-l10n  libgpg-error0  libksba8  libnpth0t64  pinentry-curses
... 중략 ...

Continue? [Y/n] y
Get:1 file:/etc/apt/mirrors/debian.list Mirrorlist [30 B]
Get:2 https://deb.debian.org/debian trixie/main amd64 libgpg-error0 amd64 1.51-4 [82.1 kB]

... 중략 ...

 

root@DATABASE:~# wget -O /usr/share/keyrings/postgresql-keyring.gpg https://www.postgresql.org/media/keys/ACCC4CF8.asc

--2026-01-13 17:44:43--  https://www.postgresql.org/media/keys/ACCC4CF8.asc
Resolving http://www.postgresql.org (http://www.postgresql.org)... 217.196.149.50, 87.238.57.232, 72.32.157.230, ...
Connecting to http://www.postgresql.org (http://www.postgresql.org)|217.196.149.50|:443... connected.
HTTP request sent, awaiting response... 200 OK

... 중략 ...

 

root@DATABASE:~# echo "deb [signed-by=/usr/share/keyrings/postgresql-keyring.gpg] http://apt.postgresql.org/pub/repos/apt $(lsb_release -cs)-pgdg main" | tee /etc/apt/sources.list.d/pgdg.list

deb [signed-by=/usr/share/keyrings/postgresql-keyring.gpg] http://apt.postgresql.org/pub/repos/apt trixie-pgdg main

 

root@DATABASE:~# apt-get update

Get:1 file:/etc/apt/mirrors/debian.list Mirrorlist [30 B]
Get:5 file:/etc/apt/mirrors/debian-security.list Mirrorlist [39 B]
Hit:2 https://deb.debian.org/debian trixie InRelease

... 중략 ...

 

root@DATABASE:~# apt-cache search postgresql-17
pgagent - job scheduling engine for PostgreSQL
postgresql-17 - The World's Most Advanced Open Source Relational Database
postgresql-17-age - Graph database optimized for fast analysis and real-time data processing
postgresql-17-age-dbgsym - debug symbols for postgresql-17-age

... 중략 ...

 

root@DATABASE:~#  apt-get install postgresql-17 postgresql-contrib-17

... 중략 ...
After this operation, 270 MB of additional disk space will be used.
Do you want to continue? [Y/n] y
Get:1 file:/etc/apt/mirrors/debian.list Mirrorlist [30 B]
Get:2 https://deb.debian.org/debian trixie/main amd64 ssl-cert all 1.1.3 [16.8 kB]

... 중략 ...

 

root@DATABASE:~# service postgresql status
● postgresql.service - PostgreSQL RDBMS
     Loaded: loaded (/usr/lib/systemd/system/postgresql.service; enabled; preset: enabled)
     Active: active (exited) since Tue 2026-01-13 17:53:22 KST; 1min 7s ago
 Invocation: 30fda030bc4349a2bac3018b2c86b8c7
   Main PID: 2541 (code=exited, status=0/SUCCESS)
   Mem peak: 1.8M
        CPU: 5ms

Jan 13 17:53:22 DATABASE systemd[1]: Starting postgresql.service - PostgreSQL RDBMS...
Jan 13 17:53:22 DATABASE systemd[1]: Finished postgresql.service - PostgreSQL RDBMS.