Thu Feb 16 08:38:12 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 ]
Is there any possibility you made your dump with --disable-triggers ? >________________________________ > From: Shaun McCloud <smccloud at geo-comm.com> >To: "slony1-general at lists.slony.info" <slony1-general at lists.slony.info> >Sent: Thursday, 16 February 2012, 15:59 >Subject: [Slony1-general] Slony not replicating changes > > > >Hello, > >I’m working on a project where we are using pg_dump to get the data out of one database and then using psql to load it into another. The second database is the master db in a Slony replication cluster. However, no matter what options I specify in pg_dump the changes are not being replicated. I’ve use a standard dump which uses COPY, a --inserts dump which uses insert into & a --insert-columns dump which adds column names to the insert into statements. However, if I edit the data in pgAdmin III using the view option for the table, that change is replicated just fine. What is the difference between editing the data that way in pgAdmin III and using psql to load a dump file? > >Shaun McCloud – Associate Software Developer >Geo-Comm, Inc >601 W. Saint Germain St., Saint Cloud, MN 56301 >Office: 320.240.0040 Fax: 320.240.2389 Toll Free: 888.436.2666 >click here to visit www.geo-comm.com >PThink before you print! >Microsoft Certified Desktop Support Technician (MCDST) >Do or do not, there is no try. > -Yoda > >_______________________________________________ >Slony1-general mailing list >Slony1-general at lists.slony.info >http://lists.slony.info/mailman/listinfo/slony1-general > > > -------------- next part -------------- An HTML attachment was scrubbed... URL: http://lists.slony.info/pipermail/slony1-general/attachments/20120216/faf82257/attachment.htm -------------- next part -------------- A non-text attachment was scrubbed... Name: image001.jpg Type: image/jpeg Size: 1129 bytes Desc: image001.jpg Url : http://lists.slony.info/pipermail/slony1-general/attachments/20120216/faf82257/attachment.jpg -------------- next part -------------- A non-text attachment was scrubbed... Name: image002.jpg Type: image/jpeg Size: 1068 bytes Desc: image002.jpg Url : http://lists.slony.info/pipermail/slony1-general/attachments/20120216/faf82257/attachment-0001.jpg
- 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