[Pgpool-hackers] database doesnot exist error

[Tatsuo Ishii]

>>> There shouldn't be any harm to do so. Except you won't be able to create
>>> database with the default template database (template1) while pgpool is
>>> connected to the template1 database. But it connects to it every
>>> health_check_period (or every 30 sec if health_check_period<=0).
>>>
>>> Anyway, this is probably something we should fix. You're not required to
>>> have a postgres database.
>> 
>> Are you sure? Many of PostgreSQL tools require to have postgres
>> database. For example, createdb and createuser. So I think a
>> PostgreSQL configuration without postgres database is broken anyway
>> and I think pgpool-Ii do not need to take care of the case.
>> 
>> BTW for #3, probably you are talking about
>> establish_persistent_connection(void) rather than
>> make_persistent_db_connection() takes database parameter, not fixed
>> usage of postgres database. establish_persistent_connection() is used
>> for streaming replication lag check, which is only available 9.0 or
>> later, which definitely has postgres database if you do not broke.
> 
> You can drop the postgres database, and use another one as your postgres
> database. You only need to use the PGDATABASE env variable. It makes it
> really cumbersome to use createdb, createuser, and other tools, and I
> see no reason for doing it, but it works.

Ok. IMO think this kind of usecase is really rare, and fixing it is
not worth the trouble.
--
Tatsuo Ishii
SRA OSS, Inc. Japan
English: http://www.sraoss.co.jp/index_en.php
Japanese: http://www.sraoss.co.jp