[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[kagemai-users:0081] Re: PostgreSQLの利用に失敗してしまいます。
菊本です。
>>>>>>> In [kagemai-users : No.0076]
>>>>>>> t_kikumoto@xxxxxxxxx wrote:
>>> BTS として影舞が非常にお手軽そうなのでインストールしてみました。
>>> XML 使用では問題なく動作したのですが、PostgreSQLを利用しようとすると
>>> 以下のようなエラーが、Apacheのログに出力されました。
....省略....
まだ、解決していないのですが、PostgreSQL 起動時に '-d 2' オプションを
つけて実行し、PostgreSQL 側の状況を確認しました（末尾参照）。
これを見る限りでは、database の作成をしているように見えるのですが、
結局の所、'PostgreSAMPLE' データベースへの接続時に、そのようなデータ
ベースは、作成されてないというエラーとなっています。
PostgreSQL があやしいでしょうか？
何か、アドバイスありましたらお願いいたします。
=== 以下、PostgreSQL のログ ===
2003-05-06 14:50:53.731724500 /usr/local/pgsql/bin/postmaster: ServerLoop: ha
ndling reading 5
2003-05-06 14:50:53.731746500 /usr/local/pgsql/bin/postmaster: ServerLoop: ha
ndling reading 5
2003-05-06 14:50:53.731756500 /usr/local/pgsql/bin/postmaster: ServerLoop: ha
ndling writing 5
2003-05-06 14:50:53.731766500 /usr/local/pgsql/bin/postmaster: BackendStartup:
pid 6495 user postgres db template1 socket 5
2003-05-06 14:50:53.732374500 /usr/local/pgsql/bin/postmaster child[6495]: sta
rting with (postgres -d2 -v131072 -p template1 )
2003-05-06 14:50:53.733365500 FindExec: found "/usr/local/pgsql/bin/postgres"
using argv[0]
2003-05-06 14:50:53.733950500 DEBUG: connection: host=127.0.0.1 user=postgres
database=template1
2003-05-06 14:50:53.734021500 DEBUG: InitPostgres
2003-05-06 14:50:53.753464500 DEBUG: StartTransactionCommand
2003-05-06 14:50:53.753684500 DEBUG: query: select getdatabaseencoding()
2003-05-06 14:50:53.764740500 DEBUG: ProcessQuery
2003-05-06 14:50:53.766421500 DEBUG: CommitTransactionCommand
2003-05-06 14:50:53.767830500 DEBUG: StartTransactionCommand
2003-05-06 14:50:53.767989500 DEBUG: query: SELECT typname, typelem FROM pg_t
ype
2003-05-06 14:50:53.773492500 DEBUG: ProcessQuery
2003-05-06 14:50:53.777473500 DEBUG: CommitTransactionCommand
2003-05-06 14:50:53.783656500 DEBUG: StartTransactionCommand
2003-05-06 14:50:53.783833500 DEBUG: query: create database PostgreSAMPLE wit
h encoding = 'EUC_JP'
2003-05-06 14:50:53.784104500 DEBUG: ProcessUtility: create database PostgreS
AMPLE with encoding = 'EUC_JP'
2003-05-06 14:50:54.198572500 DEBUG: CommitTransactionCommand
2003-05-06 14:50:54.202657500 DEBUG: proc_exit(0)
2003-05-06 14:50:54.202672500 DEBUG: shmem_exit(0)
2003-05-06 14:50:54.202679500 DEBUG: exit(0)
2003-05-06 14:50:54.202979500 /usr/local/pgsql/bin/postmaster: reaping dead pr
ocesses...
2003-05-06 14:50:54.202991500 /usr/local/pgsql/bin/postmaster: CleanupProc: pi
d 6495 exited with status 0
2003-05-06 14:50:54.209024500 /usr/local/pgsql/bin/postmaster: ServerLoop: ha
ndling reading 5
2003-05-06 14:50:54.209042500 /usr/local/pgsql/bin/postmaster: ServerLoop: ha
ndling reading 5
2003-05-06 14:50:54.209052500 /usr/local/pgsql/bin/postmaster: ServerLoop: ha
ndling writing 5
2003-05-06 14:50:54.209062500 /usr/local/pgsql/bin/postmaster: BackendStartup:
pid 6497 user postgres db PostgreSAMPLE socket 5
2003-05-06 14:50:54.213282500 /usr/local/pgsql/bin/postmaster child[6497]: sta
rting with (postgres -d2 -v131072 -p PostgreSAMPLE )
2003-05-06 14:50:54.213304500 FindExec: found "/usr/local/pgsql/bin/postgres"
using argv[0]
2003-05-06 14:50:54.213314500 DEBUG: connection: host=127.0.0.1 user=postgres
database=PostgreSAMPLE
2003-05-06 14:50:54.213324500 DEBUG: InitPostgres
2003-05-06 14:50:54.213331500 FATAL 1: Database "PostgreSAMPLE" does not exis
t in the system catalog.
2003-05-06 14:50:54.213341500 DEBUG: proc_exit(0)
2003-05-06 14:50:54.213347500 DEBUG: shmem_exit(0)
2003-05-06 14:50:54.213390500 DEBUG: exit(0)
2003-05-06 14:50:54.213635500 /usr/local/pgsql/bin/postmaster: reaping dead pr
ocesses...
2003-05-06 14:50:54.213647500 /usr/local/pgsql/bin/postmaster: CleanupProc: pi
d 6497 exited with status 0
2003-05-06 14:50:54.220278500 /usr/local/pgsql/bin/postmaster: ServerLoop: ha
ndling reading 5
2003-05-06 14:50:54.220297500 /usr/local/pgsql/bin/postmaster: ServerLoop: ha
ndling reading 5
2003-05-06 14:50:54.220307500 /usr/local/pgsql/bin/postmaster: ServerLoop: ha
ndling writing 5
2003-05-06 14:50:54.220317500 /usr/local/pgsql/bin/postmaster: BackendStartup:
pid 6498 user postgres db template1 socket 5
2003-05-06 14:50:54.240868500 /usr/local/pgsql/bin/postmaster child[6498]: sta
rting with (postgres -d2 -v131072 -p template1 )
2003-05-06 14:50:54.240891500 FindExec: found "/usr/local/pgsql/bin/postgres"
using argv[0]
2003-05-06 14:50:54.240902500 DEBUG: connection: host=127.0.0.1 user=postgres
database=template1
2003-05-06 14:50:54.240912500 DEBUG: InitPostgres
2003-05-06 14:50:54.241373500 DEBUG: StartTransactionCommand
2003-05-06 14:50:54.241555500 DEBUG: query: select getdatabaseencoding()
2003-05-06 14:50:54.247497500 DEBUG: ProcessQuery
2003-05-06 14:50:54.248860500 DEBUG: CommitTransactionCommand
2003-05-06 14:50:54.249581500 DEBUG: StartTransactionCommand
2003-05-06 14:50:54.249720500 DEBUG: query: SELECT typname, typelem FROM pg_t
ype
2003-05-06 14:50:54.254867500 DEBUG: ProcessQuery
2003-05-06 14:50:54.258641500 DEBUG: CommitTransactionCommand
2003-05-06 14:50:54.264392500 DEBUG: StartTransactionCommand
2003-05-06 14:50:54.264549500 DEBUG: query: drop database PostgreSAMPLE
2003-05-06 14:50:54.264849500 DEBUG: ProcessUtility: drop database PostgreSAM
PLE
2003-05-06 14:50:54.288641500 DEBUG: CommitTransactionCommand
2003-05-06 14:50:54.310010500 DEBUG: proc_exit(0)
2003-05-06 14:50:54.310105500 DEBUG: shmem_exit(0)
2003-05-06 14:50:54.310428500 DEBUG: exit(0)
2003-05-06 14:50:54.312236500 /usr/local/pgsql/bin/postmaster: reaping dead pr
ocesses...
2003-05-06 14:50:54.312251500 /usr/local/pgsql/bin/postmaster: CleanupProc: pi
d 6498 exited with status 0