Re: [Pgpool-general] PGpool not pooling...

2011-10-12 Thread Armin Nesiren
pools allowed for a child process max_pool = 4 * i know that number is set to 33 while im trying to connect 34 but it should put in a queue right? * -- **De:* Armin Nesiren [armin.nesi...@intera.si] *Enviado el:* miércoles, 12 de octubre de 2011 01:14 p.m. *Para

Re: [Pgpool-general] PGpool not pooling...

2011-10-12 Thread Armin Nesiren
it is supposed to do that right, ok so if i want to do a sizing for the maximux of conections i can have for my server how could i do it? How could i test pooling then? -- *De:* Armin Nesiren [armin.nesi...@intera.si] *Enviado el:* miércoles, 12 de octubre de 2011 01:22 p.m

Re: [Pgpool-general] PGpool not pooling...

2011-10-12 Thread Armin Nesiren
What is your values for num_init_childern and max_pool in pgpool.conf ? On Wed, Oct 12, 2011 at 8:00 PM, Matias Israel Malpica Escobar matias.malp...@thyssenkrupp.com wrote: HI i am testing pgpool with pgbench, i am running the following: *pgbench Matt -U testuser -p -c 34 -t 10 -C -d

[Pgpool-general] slow pgpool-II-3.1

2011-10-06 Thread Armin Nesiren
Hi everyone, I'm experiencing performance issues with pgpool-3.1 Problem is that when I connect through pgpool to database, database works slower than when I connect directly to master. In this test case, I have disabled node2, just to check performance directly and through pgpool. What can be a

Re: [Pgpool-general] pgpool autovacuum sugestions

2011-09-29 Thread Armin Nesiren
Thanks for answers. On Thu, Sep 29, 2011 at 2:59 PM, Tatsuo Ishii is...@sraoss.co.jp wrote: Hello, first, I'm sorry if it is already been asked, but I can not find it. What is suggestion for vaccum or autovacuum for pgpool configurations. I have pgpool configured for streaming

[Pgpool-general] Data not same on both nodes, streaming replication load balancing

2011-09-20 Thread Armin Nesiren
Hi everyone, I have configuration pgpool streaming replication load balancing configuration with two nodes. pgpool version is 3.1.0-alpha2 (hatsuiboshi), postgres on both nodes is 9.0.4 Reason why I have use this version is that latest stable version (at that time) 3.0.1 was everything but not

[Pgpool-general] Old master can not behaviour as slave. CURRVAL error after recovery.

2011-05-23 Thread Armin Nesiren
Hi there, I'm running pgpool cluster with stream-replication on postgres 9.0.2 and pgpool-II-3.1.0alpha1. There is one master and two slave nodes. After failure simulation of my master node (node 0), my secondary node took master role. After I have recovered my old master node, i have problems..

[Pgpool-general] hash index - does not work from slave.

2011-03-22 Thread Armin Nesiren
I have problem reading from slave node values that is indexed with hash index. Does pgpool replicate hash indexes? Is there any special configuration for hash index? -- Armin ___ Pgpool-general mailing list Pgpool-general@pgfoundry.org

Re: [Pgpool-general] hash index - does not work from slave.

2011-03-22 Thread Armin Nesiren
Riggs si...@2ndquadrant.com wrote: On Tue, Mar 22, 2011 at 3:04 PM, Guillaume Lelarge guilla...@lelarge.info wrote: Le 22/03/2011 15:25, Armin Nesiren a écrit : I have problem reading from slave node values that is indexed with hash index. Does pgpool replicate hash indexes? Is there any

Re: [Pgpool-general] hash index - does not work from slave.

2011-03-22 Thread Armin Nesiren
-based replication. For these reasons, hash index use is presently discouraged. On Tue, Mar 22, 2011 at 4:59 PM, Armin Nesiren armin.nesi...@intera.siwrote: But, what am I doing wrong then. When I insert something in master node, and after that take select, I see my record. On slave, when

Re: [Pgpool-general] replication/failover feature in Master/Slavemode

2011-01-28 Thread Armin Nesiren
Also I have same problem. When I do pcp_recovery of my old primary node (node 0), failover_command is not executed, I have set failback_command, and that command creates trigger file for me. This configuration works fine right now, but I would like to know if this is right way to do it? On Fri,

Re: [Pgpool-general] pcp_recovery_node

2011-01-25 Thread Armin Nesiren
/index_en.php Japanese: http://www.sraoss.co.jp No answer here? That's real problem for me. I would really appreciate any help or suggestion. Thanks. On Fri, Jan 21, 2011 at 9:21 AM, Armin Nesiren armin.nesi...@intera.si wrote: This is what bothers me from node1

Re: [Pgpool-general] pcp_recovery_node

2011-01-25 Thread Armin Nesiren
Looks like everything work, thanks a lot! On Tue, Jan 25, 2011 at 9:46 AM, Armin Nesiren armin.nesi...@intera.siwrote: I have them both installed on machine. But in sql/* folders, you must manually set Makefile to use libs from specified dir, looks like I have forgot to do that. 2011/1/25

[Pgpool-general] pcp_recovery_node

2011-01-20 Thread Armin Nesiren
Hi to everyone, I'm having problem with pcp_recovery_node. I have 3 computer architecture. One computer is with installed pg_pool, and two other are nodes. Pg_pool version installed is 3.0.1, and postgres is 9.0.2 I have streaming replication configured. I'm trying to setup automatic recovery of

Re: [Pgpool-general] pcp_recovery_node

2011-01-20 Thread Armin Nesiren
Actually, yesterday in desperate moments I have done that, I got cvs version of pgpool. I think I have same situation. I have added failback script that creates trigger file on my new primary node, but standby is acting like primary.. On Fri, Jan 21, 2011 at 8:19 AM, Tatsuo Ishii