> What I want to do (but i do not know how to do this exactly) would be to stop > the > replication, truncate all the data from old table, and then repopulate the > data from the original table. > What are the steps to do this ?
1. Stop Bucardo: ./bucardo stop 2. Truncate the target table: psql -h remotehost -c 'truncate table mytable' 3. Copy from source to target manually: pg_dump -h sourcehost --section=data -t mytable | psql -h remotehost 4. Start Bucardo: ./bucardo start That's the ideal case. If you have issues, feel free to email here or visit us on the #bucardo channel at irc.freenode.net. -- Greg Sabino Mullane [email protected] End Point Corporation PGP Key: 0x14964AC8
signature.asc
Description: PGP signature
_______________________________________________ Bucardo-general mailing list [email protected] https://mail.endcrypt.com/mailman/listinfo/bucardo-general
