Linux下PostgreSQL安装与开机启动.pdfVIP

Linux 下 PostgreSQL 安装与开机启动 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/ini