PostgreSQL

OS

(16)
apt update
apt -y install postgresql


(18)

apt update
apt -y install postgresql

 

 

(9)
apt update
apt -y install postgresql

 

(7)

--yum リポジトリの追加
yum install -y https://download.postgresql.org/pub/repos/yum/9.4/redhat/rhel-7-x86_64/pgdg-redhat94-9.4-3.noarch.rpm
yum info postgresql94-server postgresql94-contrib
--インストール
yum install -y postgresql94-server postgresql94-contrib postgresql94-devel postgresql94-libs
psql --version

--DB初期化
export PGSETUP_INITDB_OPTIONS='-E UTF8 --locale=C'
/usr/pgsql-9.4/bin/postgresql94-setup initdb


--DB起動
systemctl enable postgresql-9.4.service
systemctl start postgresql-9.4.service
systemctl status postgresql-9.4.service


--DB接続
su - postgres
psql

 

(8)
https://computingforgeeks.com/how-to-install-postgresql-11-on-centos-rhel-8/


--yum リポジトリの追加
dnf install https://download.postgresql.org/pub/repos/yum/reporpms/EL-8-x86_64/pgdg-redhat-repo-latest.noarch.rpm

--インストール

dnf module disable postgresql
dnf clean all
dnf -y install postgresql11-server postgresql11
dnf info postgresql11-server postgresql11

--DB初期化
/usr/pgsql-11/bin/postgresql-11-setup initdb


systemctl enable postgresql-11
systemctl start postgresql-11
systemctl status postgresql-11

 

(2012R2)


https://eng-entrance.com/postgresql-download-install