一、下载PostgreSQL安装包:postgresql-14.3.tar.gz
解压至/usr/local/postgres
二、执行以下命令进行安装,并启动:
./configure
make
make install
adduser postgres
mkdir /usr/local/pgsql/data
mkdir /usr/local/pgsql/log
chown postgres /usr/local/pgsql/data
chown postgres /usr/local/pgsql/log
su - postgres
/usr/local/pgsql/bin/initdb -D /usr/local/pgsql/data
/usr/local/pgsql/bin/pg_ctl -D /usr/local/pgsql/data -l logfile start
如果执行./configure时,没找到依赖包,则安装相应的依赖包。
三、配置允许其他IP访问:
vi ../data/postgresql.conf
listen_addresses = '*'
四、配置用户访问权限:
vi ../data/pg_hba.conf
host all all 0.0.0.0/0 md5
五、创建用户密码或修改用户密码:
./psql
create user postgres password '123456';
或者:ALTER user postgres WITH PASSWORD '123456';