PostgreSQL 9.1.2源码编译
PostgreSQL 9.1.2源码编译
刚要入门php,然后开始编译环境,先从PostgreSQL开始...
-----------------------------------------------------------
| System | CentOS 5.7
-----------------------------------------------------------
遇到的编译postgresql的依赖问题,请转文后补充.yum -y install readline-devel
参考:
PostgreSQL 下载页面 http://www.postgresql.org/ftp/source/
#mkdir /usr/local/src/postgresql && cd /usr/local/src/postgresql
#wget http://ftp.postgresql.org/pub/source/v9.1.2/postgresql-9.1.2.tar.gz
解压缩
#tar -zxvf postgresql-9.1.2.tar.gz
#su - -c "useradd -M postgres"
#chown -R postgres:postgres postgresql-9.1.2
配置编译
#./configure --help
#./configure --prefix=/opt/pgsql--sysconfdir=/opt/pgsql/etc
#mkdir/opt/pgsql/data
#chown postgres:postgres /opt/pgsql/data
初始化
# su postgres
bash-3.2$ /opt/pgsql/bin/initdb -D /opt/pgsql/data
[plain]- The files belonging to this database system will be owned by user "postgres".
- This user must also own the server process.
-
- The database cluster will be initialized with locale en_US.UTF-8.
- The default database encoding has accordingly been set to UTF8.
- The default text search configuration will be set to "english".
- fixing permissions on existing directory /opt/pgsql/data ... ok
- creating subdirectories ... ok
- selecting default max_connections ... 100
- selecting default shared_buffers ... 32MB
- creating configuration files ... ok
- creating template1 database in /opt/pgsql/data/base/1 ... ok
- initializing pg_authid ... ok
- initializing dependencies ... ok
- creating system views ... ok
- loading system objects' descriptions ... ok
- creating collations ... ok
- creating conversions ... ok
- creating dictionaries ... ok
- setting privileges on built-in objects ... ok
- creating information schema ... ok
- loading PL/pgSQL server-side language ... ok
- vacuuming database template1 ... ok
- copying template1 to template0 ... ok
- copying template1 to postgres ... ok
- WARNING: enabling "trust" authentication for local connections
- You can change this by editing pg_hba.conf or using the -A option the
- next time you run initdb.
-
- Success. You can now start the database server using:
- /opt/pgsql/bin/postgres -D /opt/pgsql/data
- or
- /opt/pgsql/bin/pg_ctl -D /opt/pgsql/data -l logfile start
添加环境变量
#vi /etc/profile
PATH=/opt/pgsql/bin:$PATH
export PATH
#source /etc/profile
启动:
#mkdir /opt/pgsql/logs/
#chown postgres:postgres /opt/pgsql/logs/
#su postgres
bash-3.2$ /opt/pgsql/bin/pg_ctl -D /opt/pgsql/data -l /opt/pgsql/logs/pgsql.log start
设置启动脚本:
#su -c "cp /usr/local/src/postgresql/postgresql-9.1.2/contrib/start-scripts/linux /etc/rc.d/init.d/postgresql-9.1.2"
#su -c "chmod a+x /etc/rc.d/init.d/postgresql-9.1.2"
#vi /etc/rc.d/init.d/postgresql-9.1.2
|
评论暂时关闭