[Bucardo-general] resync a table

Greg Sabino Mullane greg at endpoint.com
Wed May 4 14:53:57 UTC 2016

> 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 greg at endpoint.com
End Point Corporation
PGP Key: 0x14964AC8
-------------- next part --------------
A non-text attachment was scrubbed...
Name: signature.asc
Type: application/pgp-signature
Size: 163 bytes
Desc: not available
URL: <https://mail.endcrypt.com/pipermail/bucardo-general/attachments/20160504/93a688a3/attachment.sig>

More information about the Bucardo-general mailing list