linux下postgresql安装-优快云博客

本文详细介绍PostgreSQL数据库系统的安装步骤、环境变量设置、数据库初始化、开机自启动配置及权限管理等内容。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

1 添加用户创建目录
useradd postgres -d /usr/local/pgsql
passwd postgres
mkdir /usr/local/pgsql/
mkdir /usr/local/pgsql/data
chown -R postgres /usr/local/pgsql
chown postgres /usr/local/pgsql/data

2 设置环境变量
vi /etc/profile
export LD_LIBRARY_PATH=/usr/local/pgsql/lib:$LD_LIBRARY_PATH
export PATH=/usr/local/pgsql/bin:$PATH
export PGDATA=/usr/local/pgsql/data
export MANPATH=$MANPATH:/usr/local/pgsql/man

3 安装
./configure --prefix=/usr/local/pgsql ;make;make install

4 初始化数据库
su postgres
/usr/local/pgsql/bin/initdb -D /usr/local/pgsql/data

5 添加开机自启动
chmod a+x /tmp/postgresql-8.1.9/contrib/start-scripts/linux
cp /tmp/postgresql-8.1.9/contrib/start-scripts/linux /etc/init.d/postgresql
chkconfig --add postgresql

6 换数据库用户postgres的密码
psql template1
然后
ALTER USER postgres WITH PASSWORD 'password';

7 添加外部的访问连接
在pg_hba.conf加上
host    all         all         192.168.1.104/32      md5
启动
    /usr/local/pgsql/bin/postmaster -i -D /usr/local/pgsql/data &
or
    /usr/local/pgsql/bin/pg_ctl -i -D /usr/local/pgsql/data -l logfile start
关闭   kill -INT `head -1 /usr/local/pgsql/data/postmaster.pid`