Skip to content

Install & Uninstall

Jump to bottom
Phawat63915 edited this page Feb 8, 2023 · 32 revisions

Install & Uninstall PostgreSQL Database Server and Client

Tip: หากต้องการติดตั้ง PostgreSQL ในระบบปฏิบัติการอื่นๆ ดูเพิ่มเติมที่ PostgreSQL Download หรือ PostgreSQL Wiki

คู่มือนี้ครอบคลุมการติดตั้งและกำหนดค่า PostgreSQL Database Server & Client บน 👇 ระบบปฏิบัติการต่อไปนี้

Operating system list

Ubuntu 22.04 LTS, 20.04 LTS, 18.04 LTS and Debian 11, 10, 9

  • Ubuntu 22.04 LTS
  • Ubuntu 20.04 LTS
  • Ubuntu 18.04 LTS
  • Debian 11
  • Debian 10
  • Debian 9

Install

Step 1: Enable PostgreSQL 15 Package Repository

  1. เช็คว่ามี PostgreSQL Package ว่าเป็นเวอร์ชั้นที่เราต้องการหรือไม่
sudo apt-cache search postgresql | grep postgresql
  1. Add PostgreSQL Package Repository (หากไม่มีให้เพิ่มเข้าไป)
sudo sh -c 'echo "deb http://apt.postgresql.org/pub/repos/apt $(lsb_release -cs)-pgdg main" > /etc/apt/sources.list.d/pgdg.list'
wget -qO- https://www.postgresql.org/media/keys/ACCC4CF8.asc | sudo tee /etc/apt/trusted.gpg.d/pgdg.asc &>/dev/null
sudo apt update -y

Step 2: Install PostgreSQL Database Server and Client

Note: apt install -y postgresql คือเครื่องที่เราจะให้เป็น Server Database และ ส่วนเครื่องที่ไม่ได้เป็น Database Server หรือ เครื่องที่เป็น Client จะไม่สามารถใช้คำสั่ง เช่น psql -U postgresql -h <ip-server-database> -p <port> เพื่อเชื่อมต่อไปยัง Database Server จะไม่สามารถใช้คำสั่งนี้ได้เนื่องต้อง apt install -y postgresql-client ก่อนถึงจะสามารถใช้ได้

(15.1) Latest Version Server Database

sudo apt install -y postgresql

Client

sudo apt install -y postgresql-client
Other version (1-14)

(14.0) Server Databse

sudo apt install -y postgresql-14

Client

sudo apt install -y postgresql-client-14

(13.4) Server Database

sudo apt install -y postgresql-13

Client

sudo apt install -y postgresql-client-13

(12.8)

sudo apt install -y postgresql-12 postgresql-client-12

(11.13)

sudo apt install -y postgresql-11 postgresql-client-11

(10.18)

sudo apt install -y postgresql-10 postgresql-client-10
Client (9.6.23) ```bash sudo apt install -y postgresql-9.6 ``` Server ```bash sudo apt install -y postgresql-client-9.6 ```
Client (9.5.27) ```bash sudo apt install -y postgresql-9.5 ``` Server ```bash sudo apt install -y postgresql-client-9.5 ```
Client (9.4.32) ```bash sudo apt install -y postgresql-9.4 ``` Server ```bash sudo apt install -y postgresql-client-9.4 ```
Client (9.3.27) ```bash sudo apt install -y postgresql-9.3 ``` Server ```bash sudo apt install -y postgresql-client-9.3 ```
Client (9.2.24) ```bash sudo apt install -y postgresql-9.2 ``` Server ```bash sudo apt install -y postgresql-client-9.2 ```
Client (9.1.24) ```bash sudo apt install -y postgresql-9.1 ``` Server ```bash sudo apt install -y postgresql-client-9.1 ```
Client (9.0.24) ```bash sudo apt install -y postgresql-9.0 ``` Server ```bash sudo apt install -y postgresql-client-9.0 ```
Client (8.4.23) ```bash sudo apt install -y postgresql-8.4 ``` Server ```bash sudo apt install -y postgresql-client-8.4 ```
Client (8.3.23) ```bash sudo apt install -y postgresql-8.3 ``` Server ```bash sudo apt install -y postgresql-client-8.3 ```
Client (8.2.23) ```bash sudo apt install -y postgresql-8.2 ``` Server ```bash sudo apt install -y postgresql-client-8.2 ```
Client (8.1.23) ```bash sudo apt install -y postgresql-8.1 ``` Server ```bash sudo apt install -y postgresql-client-8.1 ```
Client (8.0.23) ```bash sudo apt install -y postgresql-8.0 ``` Server ```bash sudo apt install -y postgresql-client-8.0 ```
Client (7.4.25) ```bash sudo apt install -y postgresql-7.4 ``` Server ```bash sudo apt install -y postgresql-client-7.4 ```
Client (7.3.26) ```bash sudo apt install -y postgresql-7.3 ``` Server ```bash sudo apt install -y postgresql-client-7.3 ```
Client (7.2.5) ```bash sudo apt install -y postgresql-7.2 ``` Server ```bash sudo apt install -y postgresql-client-7.2 ```
Client (7.1.5) ```bash sudo apt install -y postgresql-7.1 ``` Server ```bash sudo apt install -y postgresql-client-7.1 ```
Client (7.0.5) ```bash sudo apt install -y postgresql-7.0 ``` Server ```bash sudo apt install -y postgresql-client-7.0 ```
Client (6.5.5) ```bash sudo apt install -y postgresql-6.5 ``` Server ```bash sudo apt install -y postgresql-client-6.5 ```
Client (6.4.5) ```bash sudo apt install -y postgresql-6.4 ``` Server ```bash sudo apt install -y postgresql-client-6.4 ```
Client (6.3.5) ```bash sudo apt install -y postgresql-6.3 ``` Server ```bash sudo apt install -y postgresql-client-6.3 ```
Client (6.2.5) ```bash sudo apt install -y postgresql-6.2 ``` Server ```bash sudo apt install -y postgresql-client-6.2 ```
Client (6.1.5) ```bash sudo apt install -y postgresql-6.1 ``` Server ```bash sudo apt install -y postgresql-client-6.1 ```
Client (6.0.5) ```bash sudo apt install -y postgresql-6.0 ``` Server ```bash sudo apt install -y postgresql-client-6.0 ```
Client (5.0.5) ```bash sudo apt install -y postgresql-5.0 ``` Server ```bash sudo apt install -y postgresql-client-5.0 ```
Client (4.4.5) ```bash sudo apt install -y postgresql-4.0 ``` Server ```bash sudo apt install -y postgresql-client-4.0 ```
Client (3.3.5) ```bash sudo apt install -y postgresql-3.0 ``` Server ```bash sudo apt install -y postgresql-client-3.0 ```
Client (2.2.5) ```bash sudo apt install -y postgresql-2.0 ``` Server ```bash sudo apt install -y postgresql-client-2.0 ```
Client (1.1.5) ```bash sudo apt install -y postgresql-1.0 ``` Server ```bash sudo apt install -y postgresql-client-1.0 ```

Step 3: Start PostgreSQL Database Server

sudo systemctl enable postgresql
sudo systemctl start postgresql

Step 4: Check PostgreSQL Database Server Status

systemctl status postgresql

Step 5: Check PostgreSQL Version

sudo -u postgres psql -c "SELECT version();"

OR:

psql --version

Uninstall

sudo apt-get --purge remove postgresql postgresql-* -y && sudo rm -rf /var/lib/postgresql/ && sudo rm -rf /var/log/postgresql/ && sudo rm -rf /etc/postgresql/

Red Hat Enterprise, Rocky, or Oracle version 9, 8

  • Red Hat Enterprise Linux 9
  • Rocky Linux 9
  • Oracle Linux 9
  • Red Hat Enterprise Linux 8
  • Rocky Linux 8
  • Oracle Linux 8

Install

Step 1: Enable PostgreSQL 15 Package Repository

  1. Add PostgreSQL Package Repository (หากไม่มีให้เพิ่มเข้าไป)
Red Hat Enterprise, Rocky, or Oracle 9 
sudo dnf install -y https://download.postgresql.org/pub/repos/yum/reporpms/EL-9-x86_64/pgdg-redhat-repo-latest.noarch.rpm
Red Hat Enterprise, Rocky, or Oracle 8 
sudo dnf install -y https://download.postgresql.org/pub/repos/yum/reporpms/EL-8-x86_64/pgdg-redhat-repo-latest.noarch.rpm
sudo dnf -qy module disable postgresql

Step 2: Install PostgreSQL 15 Database Server and Client Select a version next step

(15.1) Latest Version 
sudo dnf install -y postgresql15-server postgresql15-client

Step 3: Start PostgreSQL Database Server

sudo /usr/pgsql-15/bin/postgresql-15-setup initdb
sudo systemctl enable postgresql-15
sudo systemctl start postgresql-15

Step 4: Check PostgreSQL Database Server Status

systemctl status postgresql-15
(14.0) Old Version 
sudo dnf install -y postgresql14-server postgresql14-client

Step 3: Start PostgreSQL Database Server

sudo /usr/pgsql-14/bin/postgresql-14-setup initdb
sudo systemctl enable postgresql-14
sudo systemctl start postgresql-14

Step 4: Check PostgreSQL Database Server Status

systemctl status postgresql-14
(13.4) Old Version 
sudo dnf install -y postgresql13-server postgresql13-client

Step 3: Start PostgreSQL Database Server

sudo /usr/pgsql-13/bin/postgresql-13-setup initdb
sudo systemctl enable postgresql-13
sudo systemctl start postgresql-13

Step 4: Check PostgreSQL Database Server Status

systemctl status postgresql-13
(12.8) Old Version 
sudo dnf install -y postgresql12-server postgresql12-client

Step 3: Start PostgreSQL Database Server

sudo /usr/pgsql-12/bin/postgresql-12-setup initdb
sudo systemctl enable postgresql-12
sudo systemctl start postgresql-12

Step 4: Check PostgreSQL Database Server Status

systemctl status postgresql-12
(11.13) Old Version 
sudo dnf install -y postgresql11-server postgresql11-client

Step 3: Start PostgreSQL Database Server

sudo /usr/pgsql-11/bin/postgresql-11-setup initdb
sudo systemctl enable postgresql-11
sudo systemctl start postgresql-11

Step 4: Check PostgreSQL Database Server Status

systemctl status postgresql-11

Step 5: Check PostgreSQL Version

sudo -u postgres psql -c "SELECT version();"

OR:

psql --version

Red Hat Enterprise, CentOS, Scientific or Oracle version 7

  • Red Hat Enterprise Linux 7
  • CentOS 7
  • Scientific Linux 7
  • Oracle Linux 7

Install

Step 1: Enable PostgreSQL 15 Package Repository

  1. Add PostgreSQL Package Repository (หากไม่มีให้เพิ่มเข้าไป)
sudo yum install -y https://download.postgresql.org/pub/repos/yum/reporpms/EL-7-x86_64/pgdg-redhat-repo-latest.noarch.rpm

Step 2: Install PostgreSQL 15 Database Server and (Select a version to Next Step)

(15.1) Latest Version 
sudo yum install -y postgresql15-server

Step 3: Start PostgreSQL Database Server

sudo /usr/pgsql-15/bin/postgresql-15-setup initdb
sudo systemctl enable postgresql-15
sudo systemctl start postgresql-15

Step 4: Check PostgreSQL Database Server Status

systemctl status postgresql-15
(14.0) Old Version 
sudo yum install -y postgresql14-server

Step 3: Start PostgreSQL Database Server

sudo /usr/pgsql-14/bin/postgresql-14-setup initdb
sudo systemctl enable postgresql-14
sudo systemctl start postgresql-14

Step 4: Check PostgreSQL Database Server Status

systemctl status postgresql-14
(13.4) Old Version 
sudo yum install -y postgresql13-server

Step 3: Start PostgreSQL Database Server

sudo /usr/pgsql-13/bin/postgresql-13-setup initdb
sudo systemctl enable postgresql-13
sudo systemctl start postgresql-13

Step 4: Check PostgreSQL Database Server Status

systemctl status postgresql-13
(12.8) Old Version 
sudo yum install -y postgresql12-server

Step 3: Start PostgreSQL Database Server

sudo /usr/pgsql-12/bin/postgresql-12-setup initdb
sudo systemctl enable postgresql-12
sudo systemctl start postgresql-12

Step 4: Check PostgreSQL Database Server Status

systemctl status postgresql-12
(11.13) Old Version 
sudo yum install -y postgresql11-server

Step 3: Start PostgreSQL Database Server

sudo /usr/pgsql-11/bin/postgresql-11-setup initdb
sudo systemctl enable postgresql-11
sudo systemctl start postgresql-11

Step 4: Check PostgreSQL Database Server Status

systemctl status postgresql-11

Step 5: Check PostgreSQL Version

sudo -u postgres psql -c "SELECT version();"

OR:

psql --version

Red Hat Enterprise, CentOS, Scientific or Oracle version 6

  • Red Hat Enterprise Linux 6
  • CentOS 6
  • Scientific Linux 6
  • Oracle Linux 6

Install

Step 1: Enable PostgreSQL 15 Package Repository

  1. Add PostgreSQL Package Repository (หากไม่มีให้เพิ่มเข้าไป)
sudo yum install -y https://download.postgresql.org/pub/repos/yum/reporpms/EL-6-x86_64/pgdg-redhat-repo-latest.noarch.rpm

Step 2: Install PostgreSQL 15 Database Server and (Select a version to Next Step)

(15.1) Latest Version 
sudo yum install -y postgresql15-server

Step 3: Start PostgreSQL Database Server

sudo service postgresql-15 initdb
sudo chkconfig postgresql-15 on
sudo service postgresql-15 start

Step 4: Check PostgreSQL Database Server Status

systemctl status postgresql-15
(14.0) Old Version 
sudo yum install -y postgresql14-server

Step 3: Start PostgreSQL Database Server

sudo service postgresql-14 initdb
sudo chkconfig postgresql-14 on
sudo service postgresql-14 start

Step 4: Check PostgreSQL Database Server Status

systemctl status postgresql-14
(13.4) Old Version 
sudo yum install -y postgresql13-server

Step 3: Start PostgreSQL Database Server

sudo service postgresql-13 initdb
sudo chkconfig postgresql-13 on
sudo service postgresql-13 start

Step 4: Check PostgreSQL Database Server Status

systemctl status postgresql-13
(12.8) Old Version 
sudo yum install -y postgresql12-server

Step 3: Start PostgreSQL Database Server

sudo service postgresql-12 initdb
sudo chkconfig postgresql-12 on
sudo service postgresql-12 start

Step 4: Check PostgreSQL Database Server Status

systemctl status postgresql-12
(11.13) Old Version 
sudo yum install -y postgresql11-server

Step 3: Start PostgreSQL Database Server

sudo service postgresql-11 initdb
sudo chkconfig postgresql-11 on
sudo service postgresql-11 start

Step 4: Check PostgreSQL Database Server Status

systemctl status postgresql-11

Step 5: Check PostgreSQL Version

sudo -u postgres psql -c "SELECT version();"

OR:

psql --version

Fedora version 37, 36

  • Fedora version 37
  • Fedora version 36

Install

Step 1: Enable PostgreSQL 15 Package Repository

  1. Add PostgreSQL Package Repository (หากไม่มีให้เพิ่มเข้าไป)
Fedora version 37 
sudo dnf install -y https://download.postgresql.org/pub/repos/yum/reporpms/F-37-x86_64/pgdg-fedora-repo-latest.noarch.rpm
Fedora version 36 
sudo dnf install -y https://download.postgresql.org/pub/repos/yum/reporpms/F-36-x86_64/pgdg-fedora-repo-latest.noarch.rpm

Step 2: Install PostgreSQL 15 Database Server and Client (Select a version to Next Step)

(15.1) Latest Version 
sudo dnf install -y postgresql15-server postgresql15-client

Step 3: Start PostgreSQL Database Server

sudo /usr/pgsql-15/bin/postgresql-15-setup initdb
sudo systemctl enable postgresql-15
sudo systemctl start postgresql-15

Step 4: Check PostgreSQL Database Server Status

systemctl status postgresql-15
(14.0) Old Version 
sudo dnf install -y postgresql14-server postgresql14-client

Step 3: Start PostgreSQL Database Server

sudo /usr/pgsql-14/bin/postgresql-14-setup initdb
sudo systemctl enable postgresql-14
sudo systemctl start postgresql-14

Step 4: Check PostgreSQL Database Server Status

systemctl status postgresql-14
(13.4) Old Version 
sudo dnf install -y postgresql13-server postgresql13-client

Step 3: Start PostgreSQL Database Server

sudo /usr/pgsql-13/bin/postgresql-13-setup initdb
sudo systemctl enable postgresql-13
sudo systemctl start postgresql-13

Step 4: Check PostgreSQL Database Server Status

systemctl status postgresql-13
(12.8) Old Version 
sudo dnf install -y postgresql12-server postgresql12-client

Step 3: Start PostgreSQL Database Server

sudo /usr/pgsql-12/bin/postgresql-12-setup initdb
sudo systemctl enable postgresql-12
sudo systemctl start postgresql-12

Step 4: Check PostgreSQL Database Server Status

systemctl status postgresql-12
(11.13) Old Version 
sudo dnf install -y postgresql11-server postgresql11-client

Step 3: Start PostgreSQL Database Server

sudo /usr/pgsql-11/bin/postgresql-11-setup initdb
sudo systemctl enable postgresql-11
sudo systemctl start postgresql-11

Step 4: Check PostgreSQL Database Server Status

systemctl status postgresql-11

Step 5: Check PostgreSQL Version

sudo -u postgres psql -c "SELECT version();"

OR:

psql --version

ww

Cheat Sheets

Clone this wiki locally