[Pgpool-hackers] database doesnot exist error

[Guillaume Lelarge]

Hi,

Le 05/24/2011 04:00 PM, Asif Rehman a écrit :
> [...]
> I was setting up pgpool on my system, and I start getting following error in
> database server log.
> 2011-04-22 14:32:01 IST FATAL:  database "postgres" does not exist
> 

Which PostgreSQL release do you use? or did you drop the postgres database?

> So I start looking into the pgpool codebase. where I found that there
> are at-least three functions that are using "postgres" as hardcoded database
> name
> 
> 1- check_postmaster_started
> 2- health_check
> 3- make_persistent_db_connection

You probably mean establish_persistent_connection.

> In the first two functions, if postgres is not found, "template1" is used,
>  But for #3 "postgres" is the only option. Do you think there is any harm in
> using "template1" instead of "postgres"?

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.


-- 
Guillaume
 http://www.postgresql.fr
 http://dalibo.com