Mac OSX下PostgreSQL安装配置

prequistion: 已经安装Homebrew:

Installing postgreSQL by home brew:

brew install postgresql

For my old mac book pro, I will use following command:

brew install postgresql --no-python --without-ossp-uuid

After installing finished then create database folder:

sudo mkdir /usr/local/var/
sudo mkdir /usr/local/var/postgres
sudo chown yourusername /usr/local/var/postgres

And initialize database:

initdb /usr/local/var/postgres

Add alias startup to script to .bash_profile

alias ptstart='postgres -D /usr/local/var/postgres &'

If you guys happened to meet the PSQL can not connect to server error.You can use following command:

curl | sh

Reconfiguration .psqlrc and put it to the ~/.psqlrc

\pset null <NULL>
\set HISTFILE ~/.psql_history- :HOST - :DBNAME
\set HISTSIZE 2000
\set FETCH_COUNT 1000
\set PROMPT1 '(%n@%M:%>) [%/] > '
\set PROMPT2 ''
\encoding unicode
\pset border 2
\pset format wrapped
\pset pager off