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 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 momen
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 wrote:
> > I'm
> 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 nod
> 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 argumen
> 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
s
Matthew Bennett 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.
___
Guillaume Lelarge 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'
pgpool2_hostname =
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
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 correctly
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
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
http://pgfou
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
_
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, pgp
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 (1);
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 wrote:
> From: Toshihiro Kitagawa
> Subject: Re: [Pgpool-general] pool_add_prepared_statement: prepared statement
> already exists
> To: "Glyn Astill"
> Cc: pgpo
> 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 c
16 matches
Mail list logo