> 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.
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. -- Tatsuo Ishii SRA OSS, Inc. Japan English: http://www.sraoss.co.jp/index_en.php Japanese: http://www.sraoss.co.jp _______________________________________________ Pgpool-hackers mailing list [email protected] http://pgfoundry.org/mailman/listinfo/pgpool-hackers
