Mac OSX下编译安装PostgreSQL

原先使用的是官方提供的安装包，可是安装包会创建postgre这个用户。在登陆界面看的有点不爽，搜索了半天居然没有找到怎样在osx下编译安装的教程，并且假设是依照官方文档的编译安装办法一定会让你崩溃，本着源代码安装都类似的想法，依据以往在Linux下的经验居然一把通过了，注意要安装COMMANDER LINE DEVELOPERS就是了。

./configure

make

sudo mkdir /u01

sudo mkdir -p /u01/pgdata

sudo chown -R gtlions:staff /u01/pgdata

sudo make install

vi .bash_profile

export PGDATA=/u01/pgdata

export PG_HOME=/usr/local/pgsql

export PGDATABASE=postgres

export PATH=/usr/local/bin:$PG_HOME/bin:$PATH

export LD_LIBRARY_PATH=$PG_HOME/lib:$LD_LIBRARY_PATH

export DYLD_LIBRARY_PATH=$PG_HOME/lib:$DYLD_LIBRARY_PATH

initdb /u01/pgdata -E utf8

pg_ctl -l $PGDATA/server.log start

gtlions:~ gtlions$ ps -ef | grep postgres
501 1624 1622 0 9:05上午 ??

         0:00.00 postgres: checkpointer process
501 1625 1622   0 9:05上午 ??         0:00.02 postgres: writer process
501 1626 1622   0 9:05上午 ??         0:00.00 postgres: wal writer process
501 1627 1622   0 9:05上午 ??

         0:00.00 postgres: autovacuum launcher process
501 1628 1622   0 9:05上午 ??         0:00.00 postgres: stats collector process
501 1622     1   0 9:05上午 ttys001    0:00.02 /usr/local/pgsql/bin/postgres
501 1636 1613   0 9:06上午 ttys001    0:00.00 grep postgres
gtlions:~ gtlions$ psql -l
                                List of databases
   Name    | Owner | Encoding |   Collate   |    Ctype    | Access privileges
-----------+---------+----------+-------------+-------------+---------------------
postgres | gtlions | UTF8     | zh_CN.UTF-8 | zh_CN.UTF-8 |
template0 | gtlions | UTF8     | zh_CN.UTF-8 | zh_CN.UTF-8 | =c/gtlions         +
           |         |          |             |             | gtlions=CTc/gtlions
template1 | gtlions | UTF8     | zh_CN.UTF-8 | zh_CN.UTF-8 | =c/gtlions         +
           |         |          |             |             | gtlions=CTc/gtlions
(3 rows)

gtlions:~ gtlions$ psql -ac "select version();"
select version();
                                                              version
-----------------------------------------------------------------------------------------------------------------------------------
PostgreSQL 9.3.5 on x86_64-apple-darwin14.0.0, compiled by Apple LLVM version 6.0 (clang-600.0.51) (based on LLVM 3.5svn), 64-bit
(1 row)

gtlions:~ gtlions$

-EOF-

Mac OSX下编译安装PostgreSQL

相关推荐