Ubuntu 24.04 PostgreSQL Installation

- PostgreSQL installation command

After launching the terminal, execute the command below.

 

$ sudo apt update && sudo apt upgrade -y

$ sudo apt install postgresql postgresql-client

 

 

[ Execution log ]

gangserver@RC530-U0407:~$ sudo apt install postgresql postgresql-client
[sudo] gangserver 암호: 
패키지 목록을 읽는 중입니다... 완료
의존성 트리를 만드는 중입니다... 완료
상태 정보를 읽는 중입니다... 완료        
다음의 추가 패키지가 설치될 것입니다 :
  libcommon-sense-perl libjson-perl libjson-xs-perl libllvm17t64 libpq5
  libtypes-serialiser-perl postgresql-16 postgresql-client-16
  postgresql-client-common postgresql-common
제안하는 패키지:
  postgresql-doc postgresql-doc-16
다음 새 패키지를 설치할 것입니다:
  libcommon-sense-perl libjson-perl libjson-xs-perl libllvm17t64 libpq5
  libtypes-serialiser-perl postgresql postgresql-16 postgresql-client
  postgresql-client-16 postgresql-client-common postgresql-common
0개 업그레이드, 12개 새로 설치, 0개 제거 및 3개 업그레이드 안 함.
43.6 M바이트 아카이브를 받아야 합니다.
이 작업 후 175 M바이트의 디스크 공간을 더 사용하게 됩니다.
계속 하시겠습니까? [Y/n] y

(... Log omitted ...)

 

 

 

- Connect to a database(postgres) using psql

$ sudo -u postgres psql

 

[ Execution log ]

gangserver@RC530-U0407:~$ sudo -u postgres psql
psql (16.15 (Ubuntu 16.15-0ubuntu0.24.04.1))
Type "help" for help.

postgres=# 

 

 

- Exit psql

postgres=# \q

 

[ Execution log ]

postgres=# \q
gangserver@RC530-U0407:~$