postgres数据库11.11安装

postgres-11.11安装

#切换为普通用户user
[root@localhost ~]#su user
#切换到postgres安装包所在目录
[user@localhost root]$cd /usr/local/src

postgresql11-11.11-1PGDG.rhel7.x86_64.rpm
postgresql11-contrib-11.11-1PGDG.rhel7.x86_64.rpm
postgresql11-devel-11.11-1PGDG.rhel7.x86_64.rpm
postgresql11-docs-11.11-1PGDG.rhel7.x86_64.rpm
postgresql11-libs-11.11-1PGDG.rhel7.x86_64.rpm
postgresql11-plperl-11.11-1PGDG.rhel7.x86_64.rpm
postgresql11-server-11.11-1PGDG.rhel7.x86_64.rpm
timescaledb-2-loader-postgresql-11-2.0.0~rc4-0.el7.x86_64.rpm
timescaledb-2-postgresql-11-2.0.0~rc4-0.el7.x86_64.rpm
timescaledb-tools-0.10.0-0.el7.x86_64.rpm
libicu-50.2-4.el7_7.x86_64.rpm
libxslt-1.1.28-5.el7.x86_64.rpm
#安装以上所有安装包
[user@localhost root]$sudo su – postgres

#初始化数据库
-bash-4.2$ initdb
-bash-4.2$ timescaledb-tune --pg-config=/usr/pgsql-11/bin/pg_config
#全部yes
#退出
-bash-4.2$ logout
#启动数据库
[user@localhost root]$ sudo systemctl start postgresql-11
#进入数据库
[user@localhost root]$ sudo su – postgres
-bash-4.2$ psql
psql (11.11)
Type “help” for help.
#设置postgres用户密码
postgres=#alter user postgres with password ‘***********’;
#创建hasura用户并设置密码
postgres=# CREATE ROLE hasura LOGIN PASSWORD ‘hasura123!’;
#创建timescale扩展
postgres=# create extension timescaledb;
#创建database
postgres=# create database test;
#设置创建的database
postgres=# \c test
test=# CREATE EXTENSION IF NOT EXISTS timescaledb CASCADE;
test=# CREATE EXTENSION IF NOT EXISTS pgcrypto;
#退出数据库
test=# exit
#修改监听地址和连接用户数1000
-bash-4.2$ vim 11/data/postgresql.conf

-bash-4.2$ vim 11/data/pg_hba.conf
#修改外部连接模式为md5（密码验证），限制ip段位10.x.x.x

#重启数据库
[user@localhost root]$ sudo systemctl restart postgresql-11