[pgcluster: 807] Re: 環境構築に関する質問

[myoujint]

明神です。

Createdbの結果は以下のようになりました。

[postgres ＠ repl bin]$ createdb db1 -p 5441
createdb: database creation failed: ERROR:  This query is not permitted when
all replication servers fell down

ちなみに先ほど一部抜粋したものは、pg_ctl実行時にコンソールに出力されたもので
す。
最初に起動したDBは以下のようなメッセージで、後に起動しようとしたDBは永遠とコ
ンソールに出力され続けます。

pg_ctl -D /usr/local/pgsql/data start
postmaster starting
[postgres ＠ repl bin]$ LOG:  could not create IPv6 socket: Address family not
supported by protocol
LOG:  database system was shut down at 2005-09-02 13:16:14 JST
LOG:  checkpoint record is at 0/A2D59C
LOG:  redo record is at 0/A2D59C; undo record is at 0/0; shutdown TRUE
LOG:  next transaction ID: 551; next OID: 17230
LOG:  database system is ready

> はせがわといいます。
>
> 2005/09/02 12:41:00, "myoujint" <myoujint ＠ nttdata-hokkaido.co.jp> was
wrote
> > [postgres ＠ repl postgres]$ netstat -an|grep 5441
> > tcp        0      0 0.0.0.0:5441            0.0.0.0:*
> LISTEN
> > unix  2      [ ACC ]     STREAM     LISTENING     989171
> /tmp/.s.PGSQL.5441
> クラスタサーバは起動していますね。
> では、 createdb db1 -p 5441 はできますか。
>
> 以下は良くわかりません。
> >
> > 5443は起動しようとすると以下のようにコンソールに出力され続け、うまく起動
> でき
> > ません。
> > ＜一部抜粋＞
> > LOG:  could not create IPv6 socket: Address family not supported by
protocol
> > LOG:  database system was shut down at 2005-09-02 12:15:43 JST
> > LOG:  checkpoint record is at 0/A302E0
> > LOG:  redo record is at 0/A302E0; undo record is at 0/0; shutdown TRUE
> > LOG:  next transaction ID: 544; next OID: 17230
> > FATAL:  DummyProc[0] is in use by PID 17240
> > LOG:  background writer process (PID 17246) exited with exit code 1
> > LOG:  terminating any other active server processes
> > LOG:  all server processes terminated; reinitializing
> > LOG:  database system was interrupted at 2005-09-02 12:16:19 JST
> > LOG:  checkpoint record is at 0/A302E0
> > LOG:  redo record is at 0/A302E0; undo record is at 0/0; shutdown TRUE
> > LOG:  next transaction ID: 544; next OID: 17230
> > LOG:  database system was not properly shut down; automatic recovery in
> > progressFATAL:  DummyProc[0] is in use by PID 17240
> > FATAL:  DummyProc[0] is in use by PID 17240
> > FATAL:  DummyProc[1] is in use by PID 17246
> > LOG:  background writer process (PID 17250) exited with exit code 0
> > LOG:  terminating any other active server processes
> > LOG:  all server processes terminated; reinitializing
> > LOG:  semctl(130351114, 0, IPC_RMID, ...) failed: Identifier removed
> > LOG:  semctl(130383883, 0, IPC_RMID, ...) failed: Identifier removed
> > LOG:  semctl(130416652, 0, IPC_RMID, ...) failed: Identifier removed
> > LOG:  semctl(130449421, 0, IPC_RMID, ...) failed: Identifier removed
> > LOG:  semctl(130482190, 0, IPC_RMID, ...) failed: Identifier removed
> > LOG:  semctl(130514959, 0, IPC_RMID, ...) failed: Identifier removed
> > LOG:  semctl(130547728, 0, IPC_RMID, ...) failed: Identifier removed
> > LOG:  database system was interrupted at 2005-09-02 12:16:19 JST
> > LOG:  checkpoint record is at 0/A302E0
> > LOG:  redo record is at 0/A302E0; undo record is at 0/0; shutdown TRUE
> > LOG:  next transaction ID: 544; next OID: 17230
> > LOG:  database system was not properly shut down; automatic recovery in
> > progress
> > LOG:  database system is ready
> > LOG:  record with zero length at 0/A3031C
> > LOG:  redo is not required
> > LOG:  record with zero length at 0/A3031C
> > LOG:  redo is not required
> > LOG:  database system is ready
> > LOG:  background writer process (PID 17256) exited with exit code 1
> > LOG:  terminating any other active server processes
> > LOG:  all server processes terminated; reinitializing
> > LOG:  database system was shut down at 2005-09-02 12:16:20 JST
> > LOG:  checkpoint record is at 0/A3031C
> > LOG:  redo record is at 0/A3031C; undo record is at 0/0; shutdown TRUE
> > LOG:  next transaction ID: 544; next OID: 17230
> > LOG:  database system is ready
> > LOG:  database system is ready
> > LOG:  background writer process (PID 17259) exited with exit code 1
> > LOG:  terminating any other active server processes
> > LOG:  all server processes terminated; reinitializing
> > LOG:  database system was interrupted at 2005-09-02 12:16:20 JST
> > LOG:  checkpoint record is at 0/A3031C
> > LOG:  redo record is at 0/A3031C; undo record is at 0/0; shutdown TRUE
> > LOG:  next transaction ID: 544; next OID: 17230
> > LOG:  database system was not properly shut down; automatic recovery in
> > progress
> > LOG:  record with zero length at 0/A30358
> > LOG:  redo is not required
> > LOG:  database system is ready
> > LOG:  background writer process (PID 17261) exited with exit code 1
> > LOG:  terminating any other active server processes
> > LOG:  all server processes terminated; reinitializing
> > LOG:  database system was interrupted at 2005-09-02 12:16:20 JST
> > LOG:  checkpoint record is at 0/A30358
> > LOG:  redo record is at 0/A30358; undo record is at 0/0; shutdown TRUE
> > LOG:  next transaction ID: 544; next OID: 17230
> > LOG:  database system was not properly shut down; automatic recovery in
> > progress
> > LOG:  record with zero length at 0/A30394
> > LOG:  redo is not required
> >
> > どちらか先に起動したほうは、正常に起動されたように見えています。
> > 5443は、5441のDATAディレクトリをコピーしてポート番号を変えたものになり
> ます。
> >
> > Postgresql.confの設定値
> >  listen_addresses = '*'
> >  port = 5441　　　　　　　　　　<-　コピーしたディレクトリの設定は5443
> >