> > * 2 DB Servers (DB0 and DB1) > > > > * 1 pgpool instance (in a thrid server) > > > > * Streaming replication from DB0 (master) to DB1 (slave) > > > > * If DB0 fails, DB1 must become primary. > > Easy. > > > * As soon as DB0 is ready again, make it slave of DB1. > > With 3.0.2(or CVS HEAD) it's possible if you write a program(outside > pgpool world) which triggers online recovery when DB0 is ready again. > > 3.0.1 or before does not handle the case when DB0 is standby and DB1 > is primary.
I downloaded CVS head (3.0.2), compiled and run it. As soon as it starts, it segfaults: Program received signal SIGSEGV, Segmentation fault. 0x0000000000403c38 in find_primary_node () at main.c:2313 2313 if (!strcmp(res->data[0], "t")) Missing separate debuginfos, use: debuginfo-install cyrus-sasl-lib-2.1.22-19.fc10.x86_64 e2fsprogs-libs-1.41.4-6.fc10.x86_64 glibc-2.9-3.x86_64 keyutils-libs-1.2-3.fc9.x86_64 krb5-libs-1.6.3-18.fc10.x86_64 libselinux-2.0.78-1.fc10.x86_64 openldap-2.4.12-1.fc10.x86_64 openssl-0.9.8g-14.fc10.x86_64 postgresql-libs-8.3.8-2.fc10.x86_64 zlib-1.2.3-18.fc9.x86_64 Daniel _______________________________________________ Pgpool-general mailing list [email protected] http://pgfoundry.org/mailman/listinfo/pgpool-general
