nir osovsky wrote:
My questions are:
1. Why the above insert command failed?
Have you properly set up the users in pg_hba.conf in both pgsql servers?
2. What do I need to configure in order for any change to the testdb on
dev1 to replicate automaticly to testdb on dev2?
In your pgpool.conf
Can you show me the error log of PostgreSQL?
Also is it possible to try the latest version of of pgpool-II (2.1)?
--
Tatsuo Ishii
SRA OSS, Inc. Japan
Hi,
I'm trying to configure pgpool-II 2.to to replication between two computers
and postgresql database in each.
pgpool-II is defined on dev1.
Thank you, Jaume.
Attached my pg_hba.conf (identical in 2 servers) and pgpool.conf. I
appreciate if you can let me know if I need to change something.
pg_hba.conf
=
# local is for Unix domain socket connections only
local all all trust
# IPv4
Tatsuo Ishii wrote:
In summary it's an expected behavior. You saw that when second node
went down, the session was not disconncted is a bug with 2.1. In the
CVS head you will see the same behavior regardless which node goes
down.
The reason for this change was explained in the following