Hi All,
Can we install mutliple copies of pgpool in different locations in one
machine, e.g, /opt/pgpool-0, /opt/pgpool-1, /opt/pgpool-2, ..., and
launch all instances simutanously(of course in diffrent ports)?
As long as you use different ports logging directory and so on, ok.
The
Hi Toshihiro,
How did you get on with this? Is there anything I can provide to help?
Glyn
--- On Tue, 18/1/11, Toshihiro Kitagawa kitag...@sraoss.co.jp wrote:
From: Toshihiro Kitagawa kitag...@sraoss.co.jp
Subject: Re: [Pgpool-general] pool_add_prepared_statement: prepared statement
But, when I write the insert statement in a function, pgpool sends it to the
slave. Why?
create table spl_tbl(j int);
create function plpgsql_testfunc(i int) returns int
language plpgsql
as
$$
declare
col int;
begin
--for i in 1..10 loop
insert into spl_tbl values
You need to tell pgpool that your function is writing to DB.
Please refer to black_function_list directive of pgpool.conf.
--
Tatsuo Ishii
SRA OSS, Inc. Japan
English: http://www.sraoss.co.jp/index_en.php
Japanese: http://www.sraoss.co.jp
But, when I write the insert statement in a function,
Hi guys,
I'm using pgbench to benchmark the pgpool. In order to avoid table
lock, I tried to set insert_lock as false, but it caused pgpool hang.
If I set insert_lock back to true, it works fine.
Do we have to set insert_lock true? Any suggestions?
Thanks for your time!
Br,
Zhidong
Hi List;
It seems that setting replication_mode = true will produce a single
master/multiple slaves scenario. Does PGPOOL support multi-master
replication?
Thanks in advance
___
Pgpool-general mailing list
Pgpool-general@pgfoundry.org
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
I am setting up PGpool with PostgreSQL 9.0 using streaming replication. I want
to use PGpool to load balance between the live database and the hot-standby. The
two Postgres servers are running on their own machines and PGpool is running on
it's own server. I think I have everything set up
Le 20/01/2011 23:58, Matthew Bennett a écrit :
I am setting up PGpool with PostgreSQL 9.0 using streaming replication. I want
to use PGpool to load balance between the live database and the hot-standby.
The
two Postgres servers are running on their own machines and PGpool is running
on
Guillaume Lelarge guillaume@... writes:
Can you show us your pgpool.conf file?
It is a the stock pgpool.conf file except for the following changes:
socket_dir = '/var/run'
pcp_socket_dir = '/var/run'
logdir = '/mnt/pgpool'
master_slave_mode = true
master_slave_sub_mode = 'stream'
Matthew Bennett mbennett@... writes:
It is a the stock pgpool.conf file except for the following changes:
socket_dir = '/var/run'
pcp_socket_dir = '/var/run'
I figured out the problem. The socket_dir and pcp_socket_dir needed to be set to
/tmp. Sorry about that.
It seems that setting replication_mode = true will produce a single
master/multiple slaves scenario. Does PGPOOL support multi-master
replication?
You can create multi-master like set up. If you have 2 servers:
server1:
pgpool connects to PostgreSQL running on server1 and server2
I'm using pgbench to benchmark the pgpool. In order to avoid table
lock, I tried to set insert_lock as false, but it caused pgpool hang.
If I set insert_lock back to true, it works fine.
Do we have to set insert_lock true? Any suggestions?
Can you show us pgpool version, pgbench arguments,
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 nodes.
I
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
Ok. Can you show the pgpool log and PostgreSQL log(both node 0 and 1)
when you did:
pcp_recovery_node 20 localhost 9898 postgres password 0 -d
--
Tatsuo Ishii
SRA OSS, Inc. Japan
English: http://www.sraoss.co.jp/index_en.php
Japanese: http://www.sraoss.co.jp
Actually, yesterday in desperate
16 matches
Mail list logo