Failover is possible using Bucardo, although that is not one of its primary goals. For swap syncs, of course, there is very little that needs to be done; just point your application to the other database. For a pushdelta sync on the other hand, making one of the targets into a source involves the following steps:
End Point Dev offers professional support for Bucardo, as well as specializing in developing, designing, and marketing effective websites. Since 1995, our diverse team of developers has shown that End Point can handle your organization’s greatest web and database challenges.