1.下载源码包
PostgreSQL: File Browserhttps://www.postgresql.org/ftp/source/
2.创建用户
groupadd postgres
useradd -d /home/postgres -m postgres -g postgres
passwd postgres
3.设置环境变量
vim .bash_profile,添加下面内容,同时还需要创建相对应的目录
export PGHOME=/home/postgres/postgresql-14.0
export PGDATA=/home/postgres/postgres_data
export PATH=$PGHOME/bin:$PATH
export LANG=en_US.utf8
export LD_LIBRARY_PATH=$PGHOME/lib:$LD_LIBRARY_PATH
4.编译源码包
cd ~/soft/
tar zxf postgresql-14.0.tar.gz
cd postgresql-14.0
./configure --prefix=/home/postgres/postgresql-14.0 --without-readline
make && make install
5.初始化DB
initdb -D /home/postgres/postgres_data -E UTF8 -U postgres
6.修改参数文件
vim /home/postgres/postgres_data/postgresql.conf,按需修改,这里我修改的有:
listen_addresses = 'xxx'
port = 8432
unix_socket_directories = '/home/postgres/postgres_data'
logging_collector = on
log_directory = '/home/postgres/postgres_log'
log_filename = 'postgresql-%Y-%m-%d.log'
vim /home/postgres/postgres_data/pg_hba.conf,这里主要控制登录,这里我修改的有:
# IPv4 local connections:
#host all all 127.0.0.1/32 trust
host all all 0.0.0.0/0 password
7.启动PostgresSQL
pg_ctl -D /home/postgres/postgres_data -l /home/postgres/postgres_data/postgres_server.log start
8.登录并创建role
psql --host=/home/postgres/postgres_data/ -p 8432
create user odoo with password 'odoo';