Hello,
I've two server : A B.
In the Server A, I've the table 1 and 3
In the Server B, I've the table 2 and 4.
I would like to know if the server A can replicate the table 1 and 3 to the
server B.
And the server B can replicate the table 2 and 4 to the server A ?
Thank you,
My idea was, and I didn't test it, it's:
Server 1Server 2
postgres 9 A postgres9 B
pgpool A pgpool B
application A application B
The idea was :
- pgpool A is active, it's doing a streaming replication with postgres A and
B.
-application A is
.
To analyze the problem, I recommend to look into:
- Pgpool log
- PostgreSQL log
Can you show me?
--
Tatsuo Ishii
SRA OSS, Inc. Japan
English: http://www.sraoss.co.jp/index_en.php
Japanese: http://www.sraoss.co.jp
On Wed, Feb 23, 2011 at 4:49 PM, Micka mickamus...@gmail.com
Hey,
It seems that after restarting the server, it works well now
Thx,
On Wed, Feb 23, 2011 at 12:29 AM, Tatsuo Ishii is...@sraoss.co.jp wrote:
mickael@PTI2:~$ pcp_node_count 10 localhost 9898 postgres1 pgpoolAdmin
AuthorizationError
is it possible that i'm configuring the wrong
Hi,
I'm trying to understand pgPool-II on my local server.
But I encounter this bug now :
2011-02-23 09:52:03 LOG: pid 1101: pgpool-II successfully started. version
3.1.0-alpha1 (umiyameboshi)
2011-02-23 09:52:03 DEBUG: pid 1132: I am 1132
2011-02-23 09:52:03 ERROR: pid 1101:
check user
--
does your db nodes' pg_hba.conf file contains this row?
local replicationpostgres trust
Peter
On 2/23/11 11:17 AM, Micka wrote:
thx :
mickael@PTI2:~$ sudo su - postgres
postgres@PTI2:~$ /usr/lib/postgresql/9.0/bin/pg_ctl -D
/usr/local/pgsql/data -l logpostgres
/pgpool directory is empty.
THx,
On Wed, Feb 23, 2011 at 2:04 PM, Micka mickamus...@gmail.com wrote:
Ubuntu 10.04 server,
Sorry,
On Wed, Feb 23, 2011 at 2:04 PM, Tatsuo Ishii is...@sraoss.co.jp wrote:
What is your platform pgpool-II is running on?
So what is your platform
Thanks it seems that it was the problem, but it didn't go far after that ^^
see :
2011-02-23 14:59:53 LOG: pid 936: pgpool-II successfully started. version
3.1.0-alpha1 (umiyameboshi)
2011-02-23 14:59:53 DEBUG: pid 968: I am 968
2011-02-23 14:59:53 DEBUG: pid 970: I am 970
2011-02-23 14:59:53
Ok,
mickael@PTI2:~$ sudo nano /usr/local/etc/pcp.conf
# USERID:MD5PASSWD
# postgres: test
postgres:098f6bcd4621d373cade4e832627b4f6
postgres1:6b9883ad2fdc7256b95cfafbbe8e455b
micka:098f6bcd4621d373cade4e832627b4f6
With pgpool Admin, in the Login screen, when I enter:
Login: postgres
may try it with Postgresql 9.
On 2/8/11, Micka mickamus...@gmail.com wrote:
I would like to know if it is preferable to use postgreSQL 9 or
Postgresql
8.3.8 ?
Postgresql 8.3.8 is described in the tutorial.
Thanks,
On Tue, Feb 8, 2011 at 1:19 PM, AI Rumman rumman...@gmail.com
10 matches
Mail list logo