[Bucardo-general] dropdb and bucardo

Greg Sabino Mullane greg at endpoint.com
Fri Oct 18 14:39:47 UTC 2013

On Wed, Oct 16, 2013 at 03:41:19PM +0000, Markova, Nina wrote:
> Hello bucardians,
> I need to reload one of the databases for which bucardo replication is set up.
> I would like to do this with less effect on replication for other databases.
> Bucardo 5, CentOS, multi-master (2 masters), multi-slave (2 slaves)
>  Databases - webeq need a reload on all 4 servers (changing to UTF8); I plan to drop webeq and 
> recreate it with UTF8 encoding.

If you are doing a pg_dump and restore, then everything should be fine - all the 
Bucardo tables and functions and triggers should get copied as well. Bucardo 
will not be confused as long as the database name is the same. I don't think 
you need it, but it might be best to dump it with the --oids flag.

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: Digital signature
URL: <https://mail.endcrypt.com/pipermail/bucardo-general/attachments/20131018/f1567544/attachment.sig>

More information about the Bucardo-general mailing list