[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:
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:
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...
Size: 163 bytes
Desc: not available
More information about the Bucardo-general