Hi, Got 2 working datebase. Both at same Amazon EC2 computers. One DB disconnect and want to sync it back, so I made:
At pool: /etc/init.d/pgpool stop At DB1: /etc/init.d/postgres stop sync rsync -avz --delete --progress /var/lib/pgsql/ r...@db2:/var/lib/pgsql/ /etc/init.d/postgres start At DB2: /etc/init.d/postgres stop sync wait for rsync finish at DB1 /etc/init.d/postgres start At pool: /etc/init.d/pgpool start In my opinion should be 2 same postgreses. Really quick after start pgpool got at log: #v+ 2008-12-18 02:04:45 LOG: pid 22174: pgpool successfully started 2008-12-18 02:04:51 ERROR: pid 22223: pool_process_query: 1 th kind N does not match with master connection kind 1 2008-12-18 02:04:51 LOG: pid 22223: notice_backend_error: 1 fail over request from pid 22223 2008-12-18 02:04:51 LOG: pid 22174: starting degeneration. shutdown host 10.X.Y.Z(5432) 2008-12-18 02:04:51 LOG: pid 22174: failover_handler: do not restart pgpool. same master node 0 was selected 2008-12-18 02:04:51 LOG: pid 22174: failover done. shutdown host 10.X.Y.Z(5432) #v- And at postgres log at DB2 got: #v+ LOG: autovacuum launcher started LOG: database system is ready to accept connections WARNING: 6 attrdef record(s) missing for rel Product #v- Why that didn't work ? Regards -- Łukasz Jagiełło G-Forces Web Management Polska T: +44 (0) 845 055 9040 F: +44 (0) 845 055 9038 E: [email protected] W: www.gforces.co.uk This e-mail is confidential and intended solely for the use of the individual to whom it is addressed. If you are not the intended recipient, please notify the sender immediately. Do not disclose the contents of this e-mail to any other person, use it for any purpose, print, copy, store, or distribute it. This e-mail should then be destroyed. Any views expressed in this message are those of the individual sender except where the sender specifically states them to be the views of G-Forces Web Management Ltd. Registered Office: 4 & 5 Kings Row, Armstrong Road, Maidstone, Kent. ME15 6AQ. Registered Company No. 3863609. VAT Registration No. 7250 384 50 _______________________________________________ Pgpool-general mailing list [email protected] http://pgfoundry.org/mailman/listinfo/pgpool-general
