<html><body><div style="color:#000; background-color:#fff; font-family:Courier New, courier, monaco, monospace, sans-serif;font-size:12pt"><div><span>Is there any possibility you made your dump with </span><code class="OPTION">--disable-triggers ?<br></code></div><div><br><blockquote style="border-left: 2px solid rgb(16, 16, 255); margin-left: 5px; margin-top: 5px; padding-left: 5px;"> <div style="font-family: Courier New, courier, monaco, monospace, sans-serif; font-size: 12pt;"> <div style="font-family: times new roman, new york, times, serif; font-size: 12pt;"> <div dir="ltr"> <font face="Arial" size="2"> <hr size="1"> <b><span style="font-weight:bold;">From:</span></b> Shaun McCloud <smccloud@geo-comm.com><br> <b><span style="font-weight: bold;">To:</span></b> "slony1-general@lists.slony.info" <slony1-general@lists.slony.info> <br> <b><span style="font-weight: bold;">Sent:</span></b> Thursday, 16 February 2012, 15:59<br> <b><span
style="font-weight: bold;">Subject:</span></b> [Slony1-general] Slony not replicating changes<br> </font> </div> <br><div id="yiv934093932">
<style><!--
#yiv934093932
_filtered #yiv934093932 {font-family:Calibri;panose-1:2 15 5 2 2 2 4 3 2 4;}
_filtered #yiv934093932 {font-family:Tahoma;panose-1:2 11 6 4 3 5 4 4 2 4;}
_filtered #yiv934093932 {font-family:Verdana;panose-1:2 11 6 4 3 5 4 4 2 4;}
_filtered #yiv934093932 {font-family:Webdings;panose-1:5 3 1 2 1 5 9 6 7 3;}
#yiv934093932
#yiv934093932 p.yiv934093932MsoNormal, #yiv934093932 li.yiv934093932MsoNormal, #yiv934093932 div.yiv934093932MsoNormal
{margin:0in;margin-bottom:.0001pt;font-size:11.0pt;font-family:"sans-serif";}
#yiv934093932 a:link, #yiv934093932 span.yiv934093932MsoHyperlink
{color:blue;text-decoration:underline;}
#yiv934093932 a:visited, #yiv934093932 span.yiv934093932MsoHyperlinkFollowed
{color:purple;text-decoration:underline;}
#yiv934093932 p.yiv934093932MsoAcetate, #yiv934093932 li.yiv934093932MsoAcetate, #yiv934093932 div.yiv934093932MsoAcetate
{margin:0in;margin-bottom:.0001pt;font-size:8.0pt;font-family:"sans-serif";}
#yiv934093932 span.yiv934093932EmailStyle17
{font-family:"sans-serif";color:windowtext;}
#yiv934093932 span.yiv934093932BalloonTextChar
{font-family:"sans-serif";}
#yiv934093932 .yiv934093932MsoChpDefault
{font-family:"sans-serif";}
_filtered #yiv934093932 {margin:1.0in 1.0in 1.0in 1.0in;}
#yiv934093932 div.yiv934093932WordSection1
{}
--></style>
<div>
<div class="yiv934093932WordSection1">
<div class="yiv934093932MsoNormal">Hello,</div>
<div class="yiv934093932MsoNormal"> </div>
<div class="yiv934093932MsoNormal">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?</div>
<div class="yiv934093932MsoNormal"> </div>
<div class="yiv934093932MsoNormal"><b><span style="font-size:10.0pt;color:#1F497D;">Shaun McCloud – Associate Software Developer<br>
Geo-Comm, Inc</span></b><span style="font-size:10.0pt;color:#1F497D;"><br>
601 W. Saint Germain St., Saint Cloud, MN 56301<br>
<b>Office:</b> 320.240.0040 <b>Fax:</b> 320.240.2389 <b>Toll Free:</b> 888.436.2666<br>
<b><i>click here to visit </i></b><a rel="nofollow" target="_blank" href="http://www.geo-comm.com/"><b><i><span style="color:black;">www.geo-comm.com</span></i></b></a></span></div>
<div class="yiv934093932MsoNormal"><a rel="nofollow" target="_blank" href="http://www.linkedin.com/companies/geocomm"><span style="color:windowtext;text-decoration:none;"><img id="yiv934093932Picture_x0020_3" src="cid:1.2660792946@web171408.mail.ir2.yahoo.com" height="35" border="0" width="35"></span></a>
<a rel="nofollow" target="_blank" href="http://twitter.com/_geocomm"><span style="color:windowtext;text-decoration:none;"><img id="yiv934093932Picture_x0020_4" src="cid:2.2660792947@web171408.mail.ir2.yahoo.com" height="36" border="0" width="36"></span></a></div>
<div class="yiv934093932MsoNormal" style="margin-left:3.75pt;"><span style="font-size:24.0pt;font-family:Webdings;color:green;">P</span><span style="font-size:7.5pt;color:navy;">
</span><span style="font-size:7.5pt;color:green;">Think before you print!</span></div>
<div class="yiv934093932MsoNormal" style=""><b><span style="font-size:10.0pt;color:#1F497D;">Microsoft Certified Desktop Support Technician (MCDST)
</span></b></div>
<div class="yiv934093932MsoNormal"><i><span style="font-size:10.0pt;">Do or do not, there is no try.</span></i></div>
<div class="yiv934093932MsoNormal"><i><span style="font-size:10.0pt;"> -Yoda</span></i></div>
<div class="yiv934093932MsoNormal"> </div>
</div>
</div>
</div><br>_______________________________________________<br>Slony1-general mailing list<br><a ymailto="mailto:Slony1-general@lists.slony.info" href="mailto:Slony1-general@lists.slony.info">Slony1-general@lists.slony.info</a><br><a href="http://lists.slony.info/mailman/listinfo/slony1-general" target="_blank">http://lists.slony.info/mailman/listinfo/slony1-general</a><br><br><br> </div> </div> </blockquote></div> </div></body></html>