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

[Masaichi Hasegawa]

はせがわといいます。

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
>