Greg Sabino Mullane greg at endpoint.com
Fri Feb 17 08:44:41 PST 2012
On Fri, Feb 17, 2012 at 02:30:24PM +0000, Shaun McCloud wrote:
> My code is not creating the dump with --disable-triggers.

There are very few things it could be then. If it works in other 
situations, that means the Slony triggers are enabled and working 
on the tables, which rules out one possibility. Open the pg_dump 
output in a text editor and make sure it is using INSERTs, and that 
there is nothing funny at the top of the script (e.g. changing 
the session_replication_role or disabling triggers). Also, I'm 
assuming this is a --data-only pg_dump? Finally, make sure your are 
loading the output into the correct database and that no 
search_path/schema tweaks could be affecting things.

If all else fails, see if you can create a simple test case (e.g. 
pg_dump a single small table) and post it here.

-- 
Greg Sabino Mullane greg at endpoint.com
End Point Corporation
PGP Key: 0x14964AC8
-------------- next part --------------
A non-text attachment was scrubbed...
Name: not available
Type: application/pgp-signature
Size: 163 bytes
Desc: not available
Url : http://lists.slony.info/pipermail/slony1-general/attachments/20120217/48b3a139/attachment.pgp 


More information about the Slony1-general mailing list