<html><body style="word-wrap: break-word; -webkit-nbsp-mode: space; -webkit-line-break: after-white-space; "><div>Hi there,</div><div><div><br class="webkit-block-placeholder"></div><div>I just wanted to restore a dump which I did, which includes some postgis data. But, it doesn't work and instead I get this error message:</div><div><br class="webkit-block-placeholder"></div><div><br class="webkit-block-placeholder"></div><div><div>pg_restore: restoring data for table "boundaries_national"</div><div>pg_restore: [archiver (db)] error returned by PQputCopyData: server closed the connection unexpectedly</div><div><span class="Apple-tab-span" style="white-space: pre; "> </span>This probably means the server terminated abnormally</div><div><span class="Apple-tab-span" style="white-space: pre; "> </span>before or while processing the request.</div><div>pg_restore: *** aborted because of error</div><div><br class="webkit-block-placeholder"></div><div>The log shows this:</div></div><div>__________________________________________________________________</div><div>LOG: server process (PID 737) was terminated by signal 10</div><div>LOG: terminating any other active server processes</div><div>WARNING: terminating connection because of crash of another server process</div><div>DETAIL: The postmaster has commanded this server process to roll back the current transaction and exit, because another server process exited abnormally and possibly corrupted shared memory.</div><div>HINT: In a moment you should be able to reconnect to the database and repeat your command.</div><div>LOG: all server processes terminated; reinitializing</div><div>LOG: database system was interrupted at 2008-02-01 15:07:12 CET</div><div>LOG: checkpoint record is at 0/FC56620C</div><div>LOG: redo record is at 0/FC56620C; undo record is at 0/0; shutdown FALSE</div><div>LOG: next transaction ID: 0/8880241; next OID: 9551872</div><div>LOG: next MultiXactId: 1; next MultiXactOffset: 0</div><div>LOG: database system was not properly shut down; automatic recovery in progress</div><div>LOG: redo starts at 0/FC566254</div><div>LOG: record with zero length at 0/FC7435DC</div><div>LOG: redo done at 0/FC7435B4</div><div>LOG: database system is ready</div><div>__________________________________________________________________</div><div><br class="webkit-block-placeholder"></div><div><br class="webkit-block-placeholder"></div><div>What does it mean? The dump is from a 8.1 database, whereas the new one is 8.2. There is surely as well some difference in postgis version. Can it be linked to that? I am working with Leopard.</div><div><br class="webkit-block-placeholder"></div><div>Thanks for any advice.</div><div><br class="webkit-block-placeholder"></div><div>Stef</div><div><br class="webkit-block-placeholder"></div><div><span class="Apple-style-span" style="font-size: 12px; "><font class="Apple-style-span" face="Gill Sans"> </font><font class="Apple-style-span" face="Gill Sans">____________________________________________________________________</font></span></div><div apple-content-edited="true"><div style="word-wrap: break-word; -webkit-nbsp-mode: space; -webkit-line-break: after-white-space; "><span class="Apple-style-span" style="font-size: 12px; "><div class="AppleMailSignature" id="3FDCCD74-11B8-4932-A8DA-20E337E1C5F3"><p style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; "><font class="Apple-style-span" face="Gill Sans"> </font></p><div style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; "><span class="Apple-style-span" style="font-size: 13px; "><font class="Apple-style-span" color="#464646" face="Gill Sans" size="3"><span class="Apple-style-span" style="font-size: 12px; "> </span></font><font class="Apple-style-span" color="#7E1D20" face="Gill Sans" size="3"><span class="Apple-style-span" style="font-size: 12px; "> Lean Back and Relax - Enjoy some Nature Photography</span></font></span></div><div style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; font: normal normal normal 13px/normal Helvetica; min-height: 16px; font-size: 13px; "><span class="Apple-style-span" style="font-size: 12px; "><div style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; font: normal normal normal 13px/normal Helvetica; min-height: 16px; "><font class="Apple-style-span" color="#000000"><font class="Apple-style-span" face="'Gill Sans'" size="3"><span class="Apple-style-span" style="font-size: 12px; "> </span></font></font><a href="http://photoblog.la-famille-schwarzer.de/"><font class="Apple-style-span" face="'Gill Sans'" size="3"><span class="Apple-style-span" style="font-size: 12px; "><font class="Apple-style-span" color="#5A6EC4">http://photoblog.la-famille-schwarzer.de</font></span></font></a></div><div><font class="Apple-style-span" color="#000000"><font class="Apple-style-span" face="'Gill Sans'"><br class="webkit-block-placeholder"></font></font></div></span></div><div style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; font: normal normal normal 13px/normal Helvetica; min-height: 16px; "><font class="Apple-style-span" color="#000000"><font class="Apple-style-span" face="'Gill Sans'" size="3"><span class="Apple-style-span" style="font-size: 12px; "> </span></font></font><font class="Apple-style-span" face="'Gill Sans'" size="3"><span class="Apple-style-span" style="font-size: 12px; "><font class="Apple-style-span" color="#7E1D20">Appetite for Global Dat</font></span></font><font class="Apple-style-span" face="'Gill Sans'" size="3"><span class="Apple-style-span" style="font-size: 12px; "><font class="Apple-style-span" color="#7E1D20">a? UNEP GEO Data Portal: </font></span></font><font class="Apple-style-span" face="'Gill Sans'" size="3"><span class="Apple-style-span" style="font-size: 12px; "><font class="Apple-style-span" color="#7E1D20"> </font></span></font></div><div style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; font: normal normal normal 13px/normal Helvetica; min-height: 16px; "><font class="Apple-style-span" color="#000000"><font class="Apple-style-span" face="'Gill Sans'" size="3"><span class="Apple-style-span" style="font-size: 12px; "> </span></font></font><a href="http://geodata.grid.unep.ch/"><font class="Apple-style-span" face="'Gill Sans'" size="3"><span class="Apple-style-span" style="font-size: 12px; "><font class="Apple-style-span" color="#5A6EC4">http://geodata.grid.unep.ch</font></span></font></a></div><div style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; "><font class="Apple-style-span" face="Gill Sans"> </font><font class="Apple-style-span" face="Gill Sans">____________________________________________________________________</font></div></div><br class="Apple-interchange-newline"><div><br class="khtml-block-placeholder"></div><div><font class="Apple-style-span" face="Gill Sans"><br class="khtml-block-placeholder"></font></div><br class="Apple-interchange-newline"></span></div></div></div></body></html>