-PostgreSQLインストール-

  
 FreeBSD Ports

 pgsqlユーザに代わる(*^^)v


[root@sub2 /usr/local/pgsql]# su - pgsql

 データベースを初期化
$ initdb
The files belonging to this database system will be owned by user "pgsql".
This user must also own the server process.

The database cluster will be initialized with locale C.

creating directory /usr/local/pgsql/data... ok
creating directory /usr/local/pgsql/data/base... ok
creating directory /usr/local/pgsql/data/global... ok
creating directory /usr/local/pgsql/data/pg_xlog... ok
creating directory /usr/local/pgsql/data/pg_clog... ok
creating template1 database in /usr/local/pgsql/data/base/1... ok
creating configuration files... ok
initializing pg_shadow... ok
enabling unlimited row size for system tables... ok
initializing pg_depend... ok
creating system views... ok
loading pg_description... ok
creating conversions... ok
setting privileges on built-in objects... ok
vacuuming database template1... ok
copying template1 to template0... ok

Success. You can now start the database server using:

/usr/local/bin/postmaster -D /usr/local/pgsql/data
or
/usr/local/bin/pg_ctl -D /usr/local/pgsql/data -l logfile start


 起動してみる(^o^)丿

$ postmaster -i -S &  

 確認してみます。
$ ps axw

7938 ?? Ss 0:00.01 postmaster -i -S (postgres)
7939 ?? S 0:00.00 postmaster: stats buffer process (postgres)
7941 ?? S 0:00.00 postmaster: stats collector process (postgres)


$ cd /usr/local/pgsql/data

$ vi pg_hba.conf

ネットワークアドレス192.168.1.0に所属するホストを全てアクセス許可したいので・・・

 ↓ 追加しました。

host  all  192.168.1.0  255.255.255.0  trust