Yes, I have a plan to do something like you said. However at this moment, you could use Apache's rotatelogs:
pgpool -n 2>&1 | /usr/local/apache2/bin/rotatelogs /some/where 86400 (assuming you are using sh or bash etc.) -- Tatsuo Ishii SRA OSS, Inc. Japan > Hello Tatsuo, > > thanks for the quick and very helpful answer. > BTW:...I convinced our developers to evaluate pgpool ASAP, and it's already in > our develop-/test-environment :-)) > > I've one open question: > Is it possible/planned to implement a pgpool-logging mechanism to create e.g. > one log file per day (like it is in postgres). Currently (with debug output > enabled) I get several GBs log each day.... > > thanks in advance...::GERD::... > > Tatsuo Ishii schrieb: > >> while testing pgpool-II I got a bit confused by some "detect_error" > >> messages in > >> the log, which I'm not able to interpret them... > >> Does "detect_error" mean -> "let's look for errors", > > > > Yes, this. So I see no errors here. > > > >> or does it mean -> "I found an error" ? > >> And how to interpret the "C","Z","T" after "kind: " ? I guess these > >> are some > > > > They are related to PostgreSQL frontend/backend protocol. Any data > > from backend to frontend (in this case pgpool) starts with "kind" > > character. In this case, "C" stands for "Command complete", which > > means a comand is done. "Z" means "Ready for query", which means > > backend is prepared to receive next command. "T" means "Row > > description", which describes data type included in a SELECT > > result. To lean more, look into Internals->Frontend/Backend Protocol > > in PostgreSQL documentation. > > -- > > Tatsuo Ishii > > SRA OSS, Inc. Japan > > > >> status indicators, but a first grep over the header files didn't give some > >> information to me. > >> Since health_check doesn't show an error I assume everything's running > >> fine... > >> > >> any hint appreciated....GERD.... > >> > >> 2009-05-06 13:10:59 LOG: pid 708: statement: insert into test > >> (a_int,a_text) > >> values (1, 'eins'); > >> 2009-05-06 13:10:59 DEBUG: pid 708: do_command: Query: BEGIN > >> 2009-05-06 13:10:59 DEBUG: pid 708: detect_error: kind: C > >> 2009-05-06 13:10:59 DEBUG: pid 708: do_command: kind: C > >> 2009-05-06 13:10:59 DEBUG: pid 708: do_command: kind: Z > >> 2009-05-06 13:10:59 DEBUG: pid 708: do_command: transaction state: T > >> 2009-05-06 13:10:59 DEBUG: pid 708: do_command: Query: BEGIN > >> 2009-05-06 13:10:59 DEBUG: pid 708: detect_error: kind: C > >> 2009-05-06 13:10:59 DEBUG: pid 708: do_command: kind: C > >> 2009-05-06 13:10:59 DEBUG: pid 708: do_command: kind: Z > >> 2009-05-06 13:10:59 DEBUG: pid 708: do_command: transaction state: T > >> 2009-05-06 13:10:59 DEBUG: pid 708: get_insert_command_table_name: > >> extracted > >> table name: "test" > >> 2009-05-06 13:10:59 DEBUG: pid 708: waiting for backend 0 completing the > >> query > >> 2009-05-06 13:10:59 DEBUG: pid 708: detect_error: kind: C > >> 2009-05-06 13:10:59 DEBUG: pid 708: detect_error: kind: C > >> 2009-05-06 13:10:59 DEBUG: pid 708: detect_error: kind: C > >> 2009-05-06 13:10:59 DEBUG: pid 708: waiting for backend 1 completing the > >> query > >> ... > >> 2009-05-06 13:11:44 DEBUG: pid 559: starting health checking > >> 2009-05-06 13:11:44 DEBUG: pid 559: health_check: 0 th DB node status: 2 > >> 2009-05-06 13:11:44 DEBUG: pid 559: health_check: 1 th DB node status: 2 > >> -- > >> /===============================\ > >> | Gerd König > >> | - Infrastruktur - > >> | > >> | TRANSPOREON GmbH > >> | Pfarrer-Weiss-Weg 12 > >> | DE - 89077 Ulm > >> | > >> | > >> | Tel: +49 [0]731 16906 16 > >> | Fax: +49 [0]731 16906 99 > >> | Web: www.transporeon.com > >> | > >> \===============================/ > >> > >> > >> > >> Bleiben Sie auf dem Laufenden. > >> Jetzt den Transporeon Newsletter abonnieren! > >> http://www.transporeon.com/unternehmen_newsletter.shtml > >> > >> > >> TRANSPOREON GmbH, Amtsgericht Ulm, HRB 722056 > >> Geschäftsf.: Axel Busch, Peter Förster, Roland Hötzl, Marc-Oliver Simon > >> _______________________________________________ > >> Pgpool-general mailing list > >> [email protected] > >> http://pgfoundry.org/mailman/listinfo/pgpool-general > > > > -- > /===============================\ > | Gerd König > | - Infrastruktur - > | > | TRANSPOREON GmbH > | Pfarrer-Weiss-Weg 12 > | DE - 89077 Ulm > | > | > | Tel: +49 [0]731 16906 16 > | Fax: +49 [0]731 16906 99 > | Web: www.transporeon.com > | > \===============================/ > > > > Bleiben Sie auf dem Laufenden. > Jetzt den Transporeon Newsletter abonnieren! > http://www.transporeon.com/unternehmen_newsletter.shtml > > > TRANSPOREON GmbH, Amtsgericht Ulm, HRB 722056 > Geschäftsf.: Axel Busch, Peter Förster, Roland Hötzl, Marc-Oliver Simon _______________________________________________ Pgpool-general mailing list [email protected] http://pgfoundry.org/mailman/listinfo/pgpool-general
