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 _______________________________________________ Pgpool-general mailing list [email protected] http://pgfoundry.org/mailman/listinfo/pgpool-general
