一、基本信息
官网
下载 PostgreSql .org/download/
中文社区
中文网
易百教程
二、系统及工具
1、系统版本 Centos7.5 CentOS-7-x86_64-Minimal-1804
2、VMware 版本:VMware Workstation Pro15
3、工具:xshell5
4、PostgreSql: postgresql-11.4.tar.gz
三、安装部署
1、安装基本工具
[ root @localhost ~]# yum install -y vim lrzsz tree wget gcc gcc-c++ readline-devel zlib-devel
2、创建目录,并进入指定目录
[root@localhost ~]# mkdir /opt/postgresql
[root@localhost ~]# cd /opt/postgresql
3、下载
[root@localhost postgresql]# wget
4、解压、查看目录
[root@localhost postgresql]# tar zxvf postgresql-11.4.tar.gz
5、编译
[root@localhost postgresql-11.4]# ./configure –prefix=/usr/local/postgresql
6、安装
[root@localhost postgresql-11.4]# make && make install
7、进入安装后的目录,查看目录结构
[root@localhost ~]# cd /usr/local/postgresql/
8、创建目录 data、log
[root@localhost postgresql]# mkdir /usr/local/postgresql/data
[root@localhost postgresql]# mkdir /usr/local/postgresql/log
9、加入系统环境变量
[root@localhost ~]# vim /etc/profile
在最后写入如下内容
PGHOME=/usr/local/postgresql
export PGHOME
PGDATA=/usr/local/postgresql/data
export PGDATA
PATH=$PATH:$HOME/.local/bin:$HOME/bin:$PGHOME/bin
export PATH
使配置文件生效
[root@localhost ~]# source /etc/profile
10、增加用户 postgres 并赋权
[root@localhost ~]# adduser postgres
[root@localhost ~]# chown -R postgres:root /usr/local/postgresql/
11、初始化数据库
切换用户 postgres
[root@localhost ~]# su postgres
[postgres@localhost root]$ /usr/local/postgresql/bin/initdb -D /usr/local/postgresql/data/
注意:
不能在 root 用户下初始数据库,否则会报错
[root@localhost ~]# /usr/local/postgresql/bin/initdb -D /usr/local/postgresql/data/
initdb: cannot be run as root
Please log in (using, e.g., “su”) as the (unprivileged) user that will
own the server process.
12、编辑配置文件
[postgres@localhost ~]# vim /usr/local/postgresql/data/postgresql.conf
listen_addresses = ‘*’
port = 5432
[postgres@localhost ~]$ vim /usr/local/postgresql/data/pg_hba.conf
说明:
TYPE :pg的连接方式,local:本地unix套接字,host:tcp/ip连接
DATABASE:指定数据库
USER:指定数据库用户
ADDRESS:ip地址,可以定义某台主机或某个网段,32代表检查整个ip地址,相当于固定的ip,24代表只检查前三位,最后一 位是0~255之间的任何一个
METHOD:认证方式,常用的有ident,md5,password,trust,reject。
md5是常用的密码认证方式。
password是以明文密码传送给数据库,建议不要在生产环境中使用。
trust是只要知道数据库用户名就能登录,建议不要在生产环境中使用。
reject是拒绝认证。
13、启动服务
[postgres@localhost ~]$ pg_ctl start -l /usr/local/postgresql/log/pg_server.log
13.1、查看端口信息
ss -tnl
14、查看版本
[postgres@localhost ~]$ psql -V
psql (PostgreSQL) 11.4
15、登录数据库
[postgres@localhost ~]$ psql -U postgres -d postgres
第三方工具测试连接
注意:生产环境,一定要修改密码验证方式
至此,Centos7 安装 PostgreSql 安装部署完毕!
####################################################
如果有安装报错,
装postgreSQL出现configure:error:readline library not found解决方法
需要安装:
yum -y install -y readline-devel
Venta Cialis Hermosillo
Cialis Barato
PubMed 6847780
To measure the effect of different doses of tamoxifen on mammographic density and side effects and compare lower doses to the established 20 mg dose The drug was well tolerated, with expected main side effects of dry mouth and difficulty urinating
viagra prostin cena In late 2009, Knight s wife, Jeanne Knight, learned that her husband had been texting with Nelson while he was on an out of state vacation with their children and she insisted he fire her, saying she was a big threat to our marriage, the opinion said
Hugs and prayers dear friend
Silk Light Original Soymilk 1 cup 60 calories, 6 g protein, 3 g sugars, 1
Solid underscored type indicates the CDRs
May God and all the angels greet you in heaven with hugs
Another important mechanism involved in the anti proliferation effects of 4 OH TAM may be attributed to TAM inducted activation of interferon signal transduction pathway 47
Just a question here guys I have not called my onc yet, but now at least I can say I m not the only one
Peter Horrell, Barclays chief executive officer ofwealth and investment management, said in a statement
1 While evidence of HT s effectiveness for menopausal symptom relief was well supported, its supposed long term health benefits preventing everything from heart disease, osteoporotic fractures, dementia, and even colon cancer actually had very little solid science behind them ETS has proven to be very effective in reducing blushing, with a success rate of 80 90 in people who have had the procedure
GutiГ©rrez doesn t adhere to a strict breeze schedule with Letruska, who comes out of her races looking as though she s ready to go right back into the starting gate
killer, she failed in her CBD hemp oil vape benefits betray her employer, the last will be willing to sacrifice potent CBD gummies
In small restrictive VSD and PDA, the direction and magnitude of the shunt depends on the pressure difference across the shunt Another example is metformin, one of the preferred drugs to treat type 2 diabetes
2 and an increased white blood cell count of 14
The dose of hormonal injections needed to obtain normal testosterone levels and sperm production is proportional to weight, so in obese men, the cost becomes excessive, she said
Personally I have avoided fertilaid because it can screw your cycle up even more if it is somewhat consistent
Bisphosphonates are the most popular drugs prescribed for the treatment of osteoporosis
However, a stopped flow HPLC NMR experiment at 30
There is speculation that use of only one isomer, enclomiphene may lead to fewer side effects and make the medication more effective for men
Mehta S, Jay GD, Woolard RH, Hipona RA, Connolly EM, Cimini DM, Drinkwine JH, Hill NS 1997 Randomized, prospective trial of bilevel versus continuous positive airway pressure in acute pulmonary edema
Conceding to these efforts the Board passed legislation limiting EH helicopter activity to one landing per helicopter per week, an action that would reduce overall helicopter activity by 85 or over 3, 000 flights per year
The client is prescribed ergotamine Ergostat sublingual SL would nt expect so much from a cycle like that tho
Cesar Aliaga, Arunangshu Das Karam El Bayoumy
About this time, the follicle- stimulating hormone level increases slightly, stimulating the development of several follicles in the ovaries
0 Other cancer 0 0 We consider the use of anticoagulation, with or without aspirin 81 mg daily, in patients with low bleeding risk but with regular evaluation of risk benefit and consideration of newly published data
PubMed CrossRef Google Scholar Wilcox AJ, Weinberg CR, Baird DD
Linkage studies suggest that a genetic locus on chromosome 11 is associated with high bone mass
The range of scatter was too great for a statistically significant result
Cannabidiol may potentially inhibit CYP2C9 activity