postgresql 12.5軟體原始碼安裝

# 透過引數關閉大頁

echo never > /sys/kernel/mm/transparent_hugepage/enabled  

echo 'echo never >   /sys/kernel/mm/transparent_hugepage/enabled' >> /etc/rc.d/rc.local

# 驗證是否關閉了透明大頁

grep HugePages_Total  /proc/meminfo

cat /proc/sys/vm/nr_hugepages

vm.dirty_expire_centisecs=3000

net.ipv4.tcp_synack_retries=2

net.core.rmem_default=262144

vm.dirty_background_bytes=409600000

net.core.wmem_default=262144

vm.mmap_min_addr=65536

vm.overcommit_ratio=90

kernel.shmmni=819200

net.core.rmem_max=4194304

vm.dirty_writeback_centisecs=100

fs.file-max=76724600

net.core.somaxconn=4096

fs.aio-max-nr=1048576

net.ipv4.tcp_max_tw_buckets=262144

vm.swappiness=0

fs.nr_open=20480000

net.ipv4.tcp_fin_timeout=5

net.ipv4.ip_local_port_range=40000   65535

net.ipv4.tcp_keepalive_probes=3

net.ipv4.tcp_mem=8388608   12582912 16777216

kernel.shmmax = 329853488332

kernel.shmall=80530636

kernel.shmmni =   4096

kernel.msgmax =   65536

kernel.msgmni =   2005

kernel.msgmnb =   65536

kernel.sem=4096   2147483647 2147483646 512000

net.ipv4.tcp_keepalive_intvl=20

net.ipv4.tcp_keepalive_time=60

vm.overcommit_memory=0

net.ipv4.tcp_syncookies=1

net.ipv4.tcp_max_syn_backlog=4096

net.ipv4.tcp_timestamps=1

net.ipv4.tcp_rmem=8192   87380 16777216

net.ipv4.tcp_wmem=8192   65536 16777216

net.core.wmem_max=4194304

vm.dirty_ratio=80

net.core.netdev_max_backlog=10000

vm.zone_reclaim_mode=0

net.ipv4.tcp_tw_reuse=1

vm.nr_hugepages=192000

vm.nr_overcommit_hugepages=1000000

vm.overcommit_memory   = 2

* soft nofile 655360

* hard nofile   655360

* soft nproc 655360

* hard nproc 655360

* soft memlock   unlimited

* hard memlock   unlimited

* soft core   unlimited

* hard core   unlimited

-- 關閉防火牆

systemctl stop   firewalld

systemctl disable   firewalld

-- 關閉 selinux

vi /etc/selinux/config

SELINUX=disabled               -- 修改為disabled

groupadd   postgres;useradd -g  postgres postgres

echo " postgres23" | passwd  postgres--stdin

解壓軟體包

tar xvf postgresql-12.5.tar.gz   -C /data/

編譯 pg 軟體

mkdir -p   /data/postgresql12.5/

cd   /data/postgresql-12.5/

./configure   –prefix=/data/postgresql12.5/

make   && make install

安裝後，可執行檔案，庫檔案等都會安裝在 /data/postgresql12.5/ 中。

[postgres@localhost   pg1205]$ ls

bin  data    include  lib  share

export.utf8

export PGHOME=/data/postgresql12.5/

export PGDATA=$PGHOME/data/

export PGPORT=5432

export   LD_LBRARY_PATH=$PGHOME/lib:$LD_LIBRARY_PATH

export   PATH=$PGHOME/bin:$PATH

m kdir   $PGDATA

i nitdb   –locale=C -E UNICODE -D $PGDATA

如下示例說明資料庫建立成功

  The files belonging to this database system   will be owned by user "postgres".

This   user must also own the server process.

The   database cluster will be initialized with locale "C".

The   default text search configuration will be set to "english".

Data   page checksums are disabled.

fixing   permissions on existing directory /data/postgresql12.5/data ... ok

creating   subdirectories ... ok

selecting   dynamic shared memory implementation ... posix

selecting   default max_connections ... 100

selecting   default shared_buffers ... 128MB

selecting   default time zone ... America/New_York

creating   configuration files ... ok

running   bootstrap script ... ok

performing   post-bootstrap initialization ... ok

syncing   data to disk ... ok

initdb:   warning: enabling "trust" authentication for local connections

You can   change this by editing pg_hba.conf or using the option -A, or

--auth-local   and --auth-host, the next time you run initdb.

Success.   You can now start the database server using:

    pg_ctl -D /data/postgresql12.5/data/ -l   logfile start

listen_ addresses = '*'          #   what IP address(es) to listen on;

                                        #   comma-separated list of addresses;

                                        # defaults to   'localhost'; use '*' for all

                                        #   (change requires restart)

port =   5432                             #   (change requires restart)

max_connections   = 1000                  # (change requires restart)

host      all             all             0.0.0.0/0               md5

p g_ctl   -D $PGDATA  stop  # 停止 pg 命令

pg_ctl -D   $PGDATA  start  # 啟動 pg 命令

[postgre s@zabbix data]$ pg_ctl -D $PGDATA -l logfile start

waiting   for server to start.... done

server   started

[postgres@   zabbix data]$ pg_ctl -D $PGDATA stop

waiting   for server to shut down.... done

server   stopped

c p   /data/postgresql-12.5/contrib/start-scripts/linux /etc/init.d/postgresql

chkconfig   –add postgresql

chmod 755   /etc/init.d/postgresql

prefix= /data/postgresql12.5 # 軟體的安裝路徑

PGDATA="/data/postgresql12.5/data"   # 資料存放路徑

PGUSER=postgres   # 啟動 postgresql 服務的使用者

s ervice   postgresql stop

service postgresql   start