$ LOG: could not create socket for statistics collector: Protocol not supported
LOG: database system was shut down at 2004-09-17 14:20:52 CST
LOG: checkpoint record is at 0/9B6E1C
LOG: redo record is at 0/9B6E1C; undo record is at 0/0; shutdown TRUE
LOG: next transaction ID: 541; next OID: 17143
LOG: database system is ready
PID USERNAME PRI NICE SIZE RES STATE TIME WCPU CPU COMMAND
891 postgres 96 0 13508K 2708K select 0:00 0.00% 0.00% postgres
如果看到上面類似的進程,那麼我們的PostgreSQL就啟動成功,能夠使用了。
最後再建立一個資料庫:
$ /usr/local/pgsql/bin/createdb test # 建立一個資料庫test
CREATE DATABASE
建立資料庫成功後,就能夠通過PostgreSQL的用戶端串連過去:
$ /usr/local/pgsql/bin/psql test
Welcome to psql 7.4.5, the PostgreSQL interactive terminal.
Type: \copyright for distribution terms
\h for help with SQL commands
\? for help on internal slash commands
\g or terminate with semicolon to execute query
\q to quit