Fri Feb 17 08:44:41 PST 2012
- Previous message: [Slony1-general] Slony not replicating changes
- Next message: [Slony1-general] Slony not replicating changes
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
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
- Previous message: [Slony1-general] Slony not replicating changes
- Next message: [Slony1-general] Slony not replicating changes
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
More information about the Slony1-general mailing list