[Pgpool-general] Confusing... pgpool starts on both nodes, but don't replicate.

[Gerd König]

Hi Ruben,

why do you two configurations (for node1 and node2) ?
There's only one active pgpool, e.g. on node1.

Do you have some log entries from pgpool log ?

For another quick-start-guide, you can try:
http://pgpool.projects.postgresql.org/contrib_docs/pgpool-II_for_beginners.pdf

regards...GERD...


» Ruben Alves schrieb:
> Hi everyone,
> I installed pgpool with postgreSQL on Monday. I've been busy since
> yesterday morning, and in the afternoon I've tried to configure
> following those instructions:
> 
>    *
> http://pgpool.projects.postgresql.org/pgpool-II/doc/pgpool-en.html#start
>    *
> http://pgpool.projects.postgresql.org/pgpool-II/doc/tutorial-en.html#replication
> 
> 
> Everything is running fine, pgptool is running, listening for news
> connections etc.. But NOTHING happens. If I change something in node1
> (docsys) nothing is replicated on node2 (docsys2).
> 
> I have this king of configuration (exactly the same file for node1 and
> node2):
> 
> [....]
> # Replication mode
> replication_mode = true
> 
> # Load balancing mode, i.e., all SELECTs are load balanced.
> load_balance_mode = true
> 
> # if there's a data mismatch between master and secondary
> replication_stop_on_mismatch = false
> [...]
> 
> [...]
> #set pgpool2 hostname
> pgpool2_hostname = 'docsys'
> 
> # system DB info
> system_db_hostname = 'docsys'
> system_db_port = 5432
> system_db_dbname = 'pgbench'
> system_db_schema = 'pgbench_public'
> system_db_user = 'pgpool_001'
> system_db_password = 'pass'
> 
> # backend_hostname, backend_port, backend_weight
> # here are examples
> backend_hostname0 = 'docsys'
> backend_port0 = 5432
> backend_weight0 = 1
> backend_data_directory0 = '/backup/postgres/data_001/'
> 
> backend_hostname1 = 'docsys2'
> backend_port1 = 5433
> backend_weight1 = 1
> backend_data_directory1 = '/backup/postgres/data_002/'
> [...]
> 
> 
> (I've just paste parts of the config file in order to not flood this ML)
> 
> I don't really understand how pgpool initialize the replication system.
> I've build a MySQL replication system (master-slaves) and maybe i'm too
> focused on this past experience.
> 
> Can somebody give me a hand ?
> 
> 
> 
> 

-- 
/===============================\
| Gerd König
| - Infrastruktur -
|
| TRANSPOREON GmbH
| Pfarrer-Weiss-Weg 12
| DE - 89077 Ulm
|
| Tel: +49 [0]731 16906 16
| Fax: +49 [0]731 16906 99
| Web: www.transporeon.com
|
\===============================/



Bleiben Sie auf dem Laufenden.
Jetzt den Transporeon Newsletter abonnieren!
http://www.transporeon.com/unternehmen_newsletter.shtml


TRANSPOREON GmbH, Amtsgericht Ulm, HRB 722056
Geschäftsf.: Peter Förster, Roland Hötzl, Marc-Oliver Simon