PG Strom Redhat Install

postgre

sudo dnf install https://dl.fedoraproject.org/pub/epel/epel-release-latest-8.noarch.rpm
sudo yum install -y https://download.postgresql.org/pub/repos/yum/reporpms/EL-8-x86_64/pgdg-redhat-repo-latest.noarch.rpm
sudo dnf -y module disable postgresql
sudo yum install -y postgresql10-server postgresql10-devel postgresql-contrib

# pg strom
sudo yum install -y https://heterodb.github.io/swdc/yum/rhel8-noarch/heterodb-swdc-1.1-1.el8.noarch.rpm
sudo yum install pg_strom-PG10 -y

sudo su - postgres
initdb
psql postgres postgres
\password postgres
exit
exit

# edit postgresql.conf

systemctl start postgresql-10
systemctl status -l postgresql-10
systemctl enable postgresql-10

postgis

#enable power tools
sudo nano /etc/yum.repos.d/CentOS-Linux-PowerTools.repo
#enabled=1
sudo yum -y install https://download.postgresql.org/pub/repos/yum/reporpms/EL-8-x86_64/pgdg-redhat-repo-latest.noarch.rpm
sudo yum install -y postgis25_10.x86_64

# nvme strom
sudo yum install https://heterodb.github.io/swdc/yum/rhel8-x86_64//nvme_strom-2.4-3.el8.x86_64.rpm

• native postgis

• pg strom added

• pg strom + nvme strom

How To Install and Use PostgreSQL on CentOS 8 | DigitalOcean

Relational database management systems are a key component of many websites and applications. They provide a structured way to store, organize, and access information. PostgreSQL, also known as Postgres, is a relational database management system that provides an implementation of Structured Query Language, better known as SQL.

https://www.digitalocean.com/community/tutorials/how-to-install-and-use-postgresql-on-centos-8