You need to do: > At DB2: > /etc/init.d/postgres stop
*before* rsync. -- Tatsuo Ishii SRA OSS, Inc. Japan > 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 _______________________________________________ Pgpool-general mailing list [email protected] http://pgfoundry.org/mailman/listinfo/pgpool-general
