[Pgpool-general] Replication problem

[Łukasz Jagiełło]

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