Ubuntu Üzerine Standalone Postgresql Kurulumu

1-Apt den paketleri yükle. apt-get, Ubuntu gibi Debian temelli Linux dağıtımlarında, tanımlanmış kaynaklardan yeni yazılım paketlerini indirme ve bağımlılıkları ile birlikte kurma, paketleri yükseltme, paket liste içeriklerini güncelleme gibi işlemleri yerine getirmek için kullanılan bir komut satırı arayüzüdür.

pardus@umbreon00mdc0:~$ 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 — quiet -O — https://www.postgresql.org/media/keys/ACCC4CF8.asc | sudo apt-key add -
sudo apt-get update
sudo apt-get -y install postgresql
[sudo] password for pardus: ********

Çıktı:

E: gnupg, gnupg2 and gnupg1 do not seem to be installed, but one of them is required for this operation
Hit:1 https://spacewalk.turktelekom.com.tr/pardus21 yirmibir InRelease
Hit:2 https://spacewalk.turktelekom.com.tr/pardusguvenlik21 yirmibir InRelease
Err:3 http://apt.postgresql.org/pub/repos/apt yirmibir-pgdg InRelease
Could not connect to apt.postgresql.org:80 (72.32.157.246), connection timed out Could not connect to apt.postgresql.org:80 (87.238.57.227), connection timed out Could not connect to apt.postgresql.org:80 (147.75.85.69), connection timed out Could not connect to apt.postgresql.org:80 (217.196.149.55), connection timed out
Reading package lists… Done
W: Failed to fetch http://apt.postgresql.org/pub/repos/apt/dists/yirmibir-pgdg/InRelease Could not connect to apt.postgresql.org:80 (72.32.157.246), connection timed out Could not connect to apt.postgresql.org:80 (87.238.57.227), connection timed out Could not connect to apt.postgresql.org:80 (147.75.85.69), connection timed out Could not connect to apt.postgresql.org:80 (217.196.149.55), connection timed out
W: Some index files failed to download. They have been ignored, or old ones used instead.
Reading package lists… Done
Building dependency tree… Done
.
.
.
Processing triggers for man-db (2.9.4–2) …
Processing triggers for libc-bin (2.31–13+deb11u3) …

2-Postgre kullanıcısına geçiyoruz.

pardus@umbreon00mdc0:~$ sudo su postgres

3-Database ‘e bağlanıyoruz.Login olabildiyseniz veritabanınız kurulmuş demektir.

postgres@umbreon00mdc0:/home/pardus$ psql

4-\q quit kelimesinden gemektedir,veritabanından çıkış yapıyoruz.

postgres-# \q

5-Pardus kullanıcısına geçtik.

postgres@umbreon00mdc0:/home/pardus$ exit

6-Pardus İşletim sisteminin OS versiyonuna bakıyoruz.

pardus@umbreon00mdc0:~$ cat /etc/os-release

Çıktı:

PRETTY_NAME=”Pardus GNU/Linux 21 (yirmibir)”
NAME=”Pardus GNU/Linux”
VERSION_ID=”21.3"
VERSION=”21.3 (yirmibir)”
VERSION_CODENAME=yirmibir
ID=pardus
HOME_URL=”https://www.pardus.org.tr/"
SUPPORT_URL=”https://forum.pardus.org.tr/"
BUG_REPORT_URL=”https://talep.pardus.org.tr/"
ID_LIKE=debian
PARDUS_CODENAME=yirmibir

7-Postgresql servisinin durum bilgisine bakıyoruz.

pardus@umbreon00mdc0:~$ sudo systemctl status postgresql.service

Çıktı:

postgresql.service — PostgreSQL RDBMS
Loaded: loaded (/lib/systemd/system/postgresql.service; enabled; vendor preset: enabled)
Active: active (exited) since Tue 2022–09–13 10:43:45 +03; 12min ago
Main PID: 946158 (code=exited, status=0/SUCCESS)
Tasks: 0 (limit: 629145)
Memory: 0B
CPU: 0
CGroup: /system.slice/postgresql.service
Sep 13 10:43:45 umbreon00mdc0 systemd[1]: Starting PostgreSQL RDBMS…
Sep 13 10:43:45 umbreon00mdc0 systemd[1]: Finished PostgreSQL RDBMS.

8-İsterseniz aşağıdaki komut ile servisi durdurabilirsiniz.

pardus@umbreon00mdc0:~$ sudo systemctl stop postgresql.service

Teşekkürler..