標籤:style io ar os 使用 sp on art log
原先使用的是官方提供的安裝包,但是安裝包會建立postgre這個使用者,在登陸介面看的有點不爽,搜尋了半天竟然沒有找到如何在osx下編譯安裝的教程,而且如果是按照官方文檔的編譯安裝辦法一定會讓你崩潰,本著源碼安裝都類似的想法,根據以往在Linux下的經驗竟然一把通過了,注意要安裝COMMANDER LINE DEVELOPERS就是了。
./configure
make
sudo mkdir /u01
sudo mkdir -p /u01/pgdata
sudo chown -R gtlions:staff /u01/pgdata
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