<html><body style="word-wrap: break-word; -webkit-nbsp-mode: space; -webkit-line-break: after-white-space; "><span class="Apple-style-span" style="border-collapse: collapse; font-family: arial; font-size: 13px; ">I set up a new machine and am trying to do a restore from a<br>pg_dumpall. First question, is this possible. I noticed after running<br>the command:<br><br>psql 'file_to_restore' postgres<br><br>that for the most part, all of the databases get restored, however, tables<br>that contain spatial info (such as the_geom) are missing from their<br>respective databases.<br><br>I was reading the documentation and see a reference to a "Hard Restore" using<br><br>sh utils/postgis_restore.pl lwpostgis.sql newdb olddb.dump -E=UNICODE<br>> restore.log<br><br>But I can't find postgis_restore.pl on my system. </span><div><font class="Apple-style-span" face="arial" size="3"><span class="Apple-style-span" style="border-collapse: collapse; font-size: 13px; "><br class="webkit-block-placeholder"></span></font></div><div><span class="Apple-style-span" style="border-collapse: collapse; font-family: arial; font-size: 13px; ">Additionally, I am concerned<br>that the pg_dumpall may not have bee done with -Fc. Can a pg_dumpall<br>be restored if it contains spatial info from postgis?<br><br>It looks like I am about to learn the hard way how to do a proper<br>postgis backup, and that the postgresql procedures I am used to, may<br>not be sufficient.<br><br>Thanks for any advice that might help me get this db back up<br></span></div><div><font class="Apple-style-span" face="arial" size="3"><span class="Apple-style-span" style="border-collapse: collapse; font-size: 13px; "><br class="webkit-block-placeholder"></span></font></div><div><font class="Apple-style-span" face="arial" size="3"><span class="Apple-style-span" style="border-collapse: collapse; font-size: 13px; ">Kirk</span></font></div><br></body></html>