[Pgpool-general] pool_flush_it: write failed to backend(0)

hi i got the next message pool_flush_it: write failed to backend (0). reason: Connection reset by peer offset:0 wlen: 8 If i have configured child_life_time=0, connection_life_time=0 and client_idle_limit=0 my question is: Why the connection was reseted? maybe a problem with

[Pgpool-general] psql could not send startup packet: connection reset by peer

I have a the problem mentioned in the subject. first pgpool is running , and start my application system, which consumes many connection at stratup , thensuddenly the pgpool reset the connection then when a tried to run psql then pgpool send the message: psql could not send

Re: [Pgpool-general] Recovery from network outage

well... first, i alwas do a ping/traceroute to the host if you can't see the host try to fix your network connections if you can see the host have you tried change listen_addres to '*' ??? with the info that you attach, pgpool is running on the same port than postgres On 05/25/2010

[Pgpool-general] question about pcp_check_fd

hi, i have aquestion about pcp_check_fd funciton on pcp_stream.c in the pgpool 2.2.7 sources, near on the line 355. there is the follow sentence : if (notimeout || (pcp_timeout.tv_sec + pcp_timeout.tc_usec==0) ) else ... Didn't sould be: if (notimeout || (pcp_timeout.tv_sec +

[Pgpool-general] about num_init_children and max_pool

hi! Suppose that, i have a limit of 100 connections on postgres, no more no less, now my question are: if i set a num_init_children to 100 , have i set max_pool to 1 only??? or if i set num_init_children to 50, have i set max_pool to 2 only?? or if i set num_init_children to

Re: [Pgpool-general] question about pcp_check_fd

this applies in 2.3.3 too... On 05/23/2010 06:21 PM, erobles wrote: hi, i have aquestion about pcp_check_fd funciton on pcp_stream.c in the pgpool 2.2.7 sources, near on the line 355. there is the follow sentence : if (notimeout || (pcp_timeout.tv_sec + pcp_timeout.tc_usec==0

[Pgpool-general] redirect output from pgpol to a file

Hi! i tried to redirect the pgpool's output to a file with pgppool -n 21 /tmp/pgpool.log but no lines are written. which is the best way to redirect the output thanks in advance. ___ Pgpool-general mailing list

[Pgpool-general] pgpool stucked after sincronization.

Hi! I tried to reply and sincronize two postgres on pgsql1 and pgsql2 , but when pgpool restart the postgres on pgsql2 , pgpool doesn't attend new conection ,Let me explain better the problem, i have the follow stage: 1.- I have postgres running in pgsql1 and postgres is down in pgsql2.

[Pgpool-general] Doubt with system_db.sql script

Hi! i have a question about system_db.sql script included in pgpool. Really is needed execute this script for pgpool to replicate??? Which is the best database to install it??? template1?? postgres??? ok! maybe the question was a too newbie :-) , but i hope your answers have a nice

[Pgpool-general] postgres conections are stuked after a pcp_recovery_node.

Hi! i have the following scenary: 0. First , i made a copy of whole the postgres dir the backend0 on backend1 1. start up postgres on the backend0 (pgsql1), with port 6543 2. keep down postgres on the backend1 (pgsql2), with port 6543 too. 3. start up the pgpool on the port 5432

[Pgpool-general] start_recovery: remote start failed

Hi! i have this trouble with pgpool-II 2.2.6 and start_recovery. when i tried to recover a node whit this command: pcp_recovery_node 5 pgsql1 9898 root rutilio 1 and the log of pgpool is: 2010-01-27 09:24:12 LOG: pid 6036: CHECKPOINT in the 1st stage done 2010-01-27 09:24:12 LOG: pid

[Pgpool-general] which is advantage of master/slave mode vs replication on pgpool-II

hi! like the subjects said, i am interesting on the advantages of pgpool in master/slave mode over replication mode regards! ___ Pgpool-general mailing list Pgpool-general@pgfoundry.org http://pgfoundry.org/mailman/listinfo/pgpool-general

[Pgpool-general] error to createlang ...

Hi! i have an error when i try to add/create a plpgsql language in Postgresql 8.3.1 on SCO Openserver 5.0.7 createlang: langauge installation failed: ERROR could not access file $libdir/plpgsql: No such file or directory. But, the file plpgsql.so exists in the directory, please,could you

[Pgpool-general] About degeneration mode...

I'am testing the disconnection of the backends configured to replicate the querys, then i shutdown down the backend_hostname1 and pgpool enter to degeneration mode ,ok this is the expected behavior and the querys like insert are executed in the backend_hostname0 ok. But if i

[Pgpool-general] doubt with ProcessFrontendResponse

hi!, I'm having a repeated message from ProcessFrontendResponse: 'failed to read kind from frontend. frontend abnormally exited' That error is critic for pgpool-II??? that way this error affects to pgpool-II??? the version of pgpool-II 2.2.6 on SCO OpenServer 5.0.7 i tried to