<html>
<head>
<style><!--
.hmmessage P
{
margin:0px;
padding:0px
}
body.hmmessage
{
font-size: 12pt;
font-family:Calibri
}
--></style></head>
<body class='hmmessage'><div dir='ltr'>Hi,<div> I'm trying to restore after a Hard upgrade from Postgresql 9.0 and PostGIS 2.0SVN to Postgresql 9.3 with Postgis 2.1 and PointCloud.</div><div>The back-up dump went fine and the re-installation of 9.3, 2.1 and Pointcloud all fine.</div><div>This is a LiDAR DB and the back-up dump file is 513GB, so its a large restore job (I'd imagine).</div><div>Anyway, I've set the following process off:</div><div><br></div><div>sudo perl /usr/share/postgresql/9.3/contrib/postgis-2.1/postgis_restore.pl "/storage2/bkup/pg_upgrade.backup" | psql -h localhost -p 5432 -U postgres lidar_db 2> errors.txt</div><div><br></div><div>The process gets to:</div><div><br></div><div>Writing manifest of things to read from dump file...</div><div>Writing ASCII to stdout...</div><div><br></div><div>and would seem to be stuck as it has been in this state for over 24 hours.</div><div>Using 'top' I can't see any CPU or MEM values to suggest the process is still working, just very busy because of the large file.</div><div><br></div><div>The process creates a new 630kb file called:</div><div><br></div><div>pg_upgrade.backup.lst</div><div><br></div><div>but it is not getting any bigger.</div><div><br></div><div>Basically, should a 500GB+ dump file take hours to restore and should it be stuck in this state for so long??</div><div>Where could I look for the problem and what solutions might I try.</div><div>The erros.txt file gets created but its empty 0kb.</div><div><br></div><div>Regards,</div><div><br></div><div>Paul</div><div> </div><div> </div> </div></body>
</html>