[Bucardo-general] Odd 'inconsistency' after one-time-copy

Greg Sabino Mullane greg at endpoint.com
Thu Jul 25 14:58:27 UTC 2013


On Tue, Jul 23, 2013 at 02:49:21PM -0700, Paul Theodoropoulos wrote:
...
> measure of a database's consistency - that much I do realize. So
> this could just be a byproduct of trigger-based transfer of data to
> a blank db - I dunno (obligatory /not a pgdba from me).  I ran a
> 'vacuum full' but there was no change in space consumed.

I would try doing a pg_relation_size() and pg_total_replication_size() on 
the exact tables in question - it could simply be that the slave has 
non-replicated items in its database that the master does not.

-- 
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/20130725/52672c96/attachment.sig>


More information about the Bucardo-general mailing list