[Oracle] postgreSQL 14 install (Ubuntu 20.04)

ubuntu 20.04 postgreSQL 설치 방법

 

1 ) apt update

ubuntu@dev1990:~$ sudo apt update

 

2) postgresql install

(extension을 위해서 postgresql-contrib install )

ubuntu@dev1990:~$ sudo apt install postgresql-14 postgresql-contrib

3) systemctl status postgresql.service 

(설치 확인 및 서비스 확인)

ubuntu@dev1990:~$ systemctl status postgresql.service
● postgresql.service - PostgreSQL RDBMS
     Loaded: loaded (/lib/systemd/system/postgresql.service; enabled; vendor preset: enabled)
     Active: active (exited) since Wed 2022-10-12 01:00:51 KST; 1min 9s ago
    Process: 134688 ExecStart=/bin/true (code=exited, status=0/SUCCESS)
   Main PID: 134688 (code=exited, status=0/SUCCESS)
        CPU: 1ms

Oct 12 01:00:51 dev1990 systemd[1]: Starting PostgreSQL RDBMS...
Oct 12 01:00:51 dev1990 systemd[1]: Finished PostgreSQL RDBMS.

4) postgres 계정으로 전환

ubuntu@dev1990:~$ sudo -i -u postgres
postgres@dev1990:~$

5) psql로 접근

postgres@dev1990:~$ psql
psql (14.5 (Ubuntu 14.5-0ubuntu0.22.04.1))
Type "help" for help.

postgres=#