[Pgpool-general] Replication problem

[Tatsuo Ishii]

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/ root at 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: lukasz.jagiello at gforces.pl
> 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
> Pgpool-general at pgfoundry.org
> http://pgfoundry.org/mailman/listinfo/pgpool-general