这篇文章主要介绍“安装Postgresql12.1的详细步骤”，在日常操作中，相信很多人在安装Postgresql12.1的详细步骤问题上存在疑惑，小编查阅了各式资料，整理出简单好用的操作方法，希望对大家解答”安装Postgresql12.1的详细步骤”的疑惑有所帮助！接下来，请跟着小编一起来学习吧！

1、上传安装包

#cd/usr/src#rz#tar-zxvfpostgresql-12.1.tar.gz#rm-rfpostgresql-12.1.tar.gz

2、添加第三方插件

下载地址：https://www.postgresql.org/docs/12/contrib.html

#cd/usr/src/postgresql-12.1/contrib/#rz#unzipzhparser-master.zip#rm-rfzhparser-master.zip

3、安装postgresql依赖库

#sudoapt-getinstall-ygcclibreadline-devzlib1gzlib1g.devmake

4、安装

#cd/usr/src/postgresql-12.1/#./configure--prefix=/opt/pgsql12.1/--with-wal-blocksize=32--with-blocksize=32#makeworld#makeinstall-world

5、添加用户配置环境变量

#useraddpostgres-m#passwdpostgres#su-postgres$vi~/.profileexportPGPORT=8899exportPGDATA=/home/postgres/pgsql12.1/pg_rootexportLANG=en_US.utf8exportPGHOME=/opt/pgsql12.1/exportLD_LIBRARY_PATH=$PGHOME/lib:/lib64:/usr/lib64:/usr/local/lib64:/lib:/usr/lib:/usr/local/lib:$LD_LIBRARY_PATHexportDATE=`date+"%Y%m%d%H%M"`exportPATH=$PGHOME/bin:$PATH:.exportMANPATH=$PGHOME/share/man:$MANPATHexportPGUSER=postgresexportPGHOST=$PGDATAaliasrm='rm-i'aliasll='ls-lh'exportPGDATABASE=center$exit#reboot或者source~/.profile#usermod-s/bin/bashpostgres#su-postgres$mkdir-p/home/postgres/pgsql12.1/pg_root$initdb-D$PGDATA-EUTF8--locale=C-Upostgres-W#这里需要输入两次密码

6、修改内核参数

$su-root#vi/etc/sysctl.confkernel.shmmax=68719476736kernel.shmall=4294967296kernel.shmmni=4096kernel.sem=5010064128000501001280fs.file-max=7672460net.ipv4.ip_local_port_range=900065000net.core.rmem_default=1048576net.core.rmem_max=4194304net.core.wmem_default=262144net.core.wmem_max=1048576#sysctl-p#vi/etc/security/limits.conf*softnofile131072*hardnofile131072*softnproc131072*hardnproc131072*softcoreunlimited*hardcoreunlimited*softmemlock50000000*hardmemlock50000000

7、关闭防火墙

#sudoufwstatusverboseStatus:activeLogging:on(low)Default:deny(incoming),allow(outgoing),disabled(routed)Newprofiles:skip#sudoufwdisableFirewallstoppedanddisabledonsystemstartup#sudoufwstatusverboseStatus:inactive

8、配置pg_hba.conf

$cd$PGDATA$vipg_hba.conf添加允许访问的IP段hostallall192.168.0.0/16md5hostallall10.10.0.0/16md5

9、配置postgresql.conf

listen_addresses='0.0.0.0'port=7788max_connections=100superuser_reserved_connections=13unix_socket_directories='.'unix_socket_permissions=0700tcp_keepalives_idle=60tcp_keepalives_interval=10tcp_keepalives_count=10shared_buffers=128MBvacuum_cost_delay=10bgwriter_delay=10mswal_writer_delay=10mslog_destination='csvlog'logging_collector=onlog_directory='pg_log'log_filename='postgresql-%Y-%m-%d_%H%M%S.log'log_file_mode=0600log_truncate_on_rotation=onlog_rotation_age=1dlog_rotation_size=10MBlog_checkpoints=onlog_connections=onlog_disconnections=onlog_error_verbosity=verboselog_timezone='Asia/Shanghai'

10、启动数据库

$pg_ctlstart[-d$PGDATA]

11、进入数据库

$psql-h127.0.0.1-p7788-Upostgrespostgres

12、停止数据库

$pg_ctlstop[-mfast|smart|immediate][-d$PGDATA]

13、安装Pgadmin

#sudoaptupdate-y&&sudoaptupgrade-y#sudoapt-getinstall-ypgadmin4pgadmin4-apache2

访问：http://ip:端口/pgadmin4/

到此，关于“安装Postgresql12.1的详细步骤”的学习就结束了，希望能够解决大家的疑惑。理论与实践的搭配能更好的帮助大家学习，快去试试吧！若想继续学习更多相关知识，请继续关注亿速云网站，小编会继续努力为大家带来更多实用的文章！