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