Le 21/02/2011 09:43, Tatsuo Ishii a écrit : > Hi pgpool hackers, > > We have discussed about a problem with "application_name" in > Paris. Pgpool keeps connection to PostgreSQL. From PostgreSQL 9.0, > there is a new SET variable called "application_name" which is left > after clients disconnects to pgpool. So if you take a look at the > output of pg_stat_activity, there are some entries which keep > application_name as "psql" if you use psql via pgpool. > > I think we could just get ride of the problem by just adding 'SET > application_name TO "pgpool"' to the reset_query_list in > pgpool.conf(note that you should remove single quote). > > The reason why we use double quote surrounding pgpool is, > reset_query_list does not allow to use single quote. > (maybe we should introduce some escape syntax). > > Unfortunately pgpoolAdmin dislikes this when using pgpool.conf > management page but it's different story. > > What do you think?
It's only one part of the story. When a client disconnects from pgPool, pgPool should send the SET command. Just like you said. But, when a client reconnects to pgPool, pgPool should extract the application_name parameter from the startup packet and send the application_name to PostgreSQL, so that the application_name is the good one. -- Guillaume http://www.postgresql.fr http://dalibo.com _______________________________________________ Pgpool-hackers mailing list [email protected] http://pgfoundry.org/mailman/listinfo/pgpool-hackers
