<div dir="ltr"><div><div><div>"Please give more details" :-) Sorry -kidding- just had to say that. <br><br></div><div>These are just the suggestions of another newbie. Take with grain of salt.<br></div><div><br></div>Do the easiest thing - kill the loader, drop the database, create the user, create the database as geo_user and start again.<br></div><div><br></div><div>If you use geo_user to create the database you know he exists and that he owns the database so he won't have trouble writing to it. You can back off the perms later if you want. "createdb -U geo_user foo"<br></div></div><div><div><div><div><br></div><div>I've never used that <a href="http://postgis_restore.pl">postgis_restore.pl</a> script to do a load, I just send the sql to psql (upon reviewing docs on that script I have probably been doing it a bad way! :-)<br></div><div><br>Help for the script mentions that you have to install topology and raster as separate steps before loading IFF you were using them before.<br></div><div><br></div><div>Crank up debugging, don't wait hours for results. I looked up the script and it has a -v option. Try that. You are using a real computer so use the tee command to watch your error file as the script runs. <br><br></div><div>Instead of ending your command with "> errors.txt" use "| tee errors.txt"<br></div><div>This will pipe the errors from stdout to tee and tee will output both the errors.txt file and also send the output stdout so you see it on your screen as it happens.<br><br><br></div><div>Another idea, you should be able to open another window or pgadmin3 and examine the database as it gets loaded -- be like the job descriptions -- "must be able to multitask". It's a database, would not be much fun if you could not access it from more than one program.<br><br></div><div>Brian<br></div><div><br></div></div></div></div></div><div class="gmail_extra"><br><div class="gmail_quote">On Wed, Aug 26, 2015 at 12:01 PM, Lee Hachadoorian <span dir="ltr"><<a href="mailto:Lee.Hachadoorian+L@gmail.com" target="_blank">Lee.Hachadoorian+L@gmail.com</a>></span> wrote:<br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">New Linux machine, new PostGIS install (postgresql-9.3-postgis-2.1). I<br>
created DB and added extensions. Now trying to load database using<br>
<a href="http://postgis_restore.pl" rel="noreferrer" target="_blank">postgis_restore.pl</a>. This is a large database (63GB dump, created from<br>
DB that was probably 600GB or more).<br>
<br>
The script ran for a while. Then it stopped at<br>
<br>
setval<br>
--------<br>
53<br>
(1 row)<br>
<br>
It's been hanging out there for hours now, so I assume something is<br>
hopelessly wrong.<br>
<br>
The loader created foo.dump.lst at 10:50am and I piped errors to a<br>
text file. Errors file shows that I did not create a user who owns one<br>
of the schemas. `ERROR: role "geo_user" does not exist` appears 260<br>
times.<br>
<br>
Can I just kill the loader script with Ctrl+C? Is database<br>
recoverable? Should I just drop database and try again from the<br>
beginning? Is failure related to missing role, or if not how do I<br>
figure out what the error is so that I can get this to run to<br>
completion?<br>
<br>
Best,<br>
--Lee<br>
<span class="HOEnZb"><font color="#888888"><br>
--<br>
Lee Hachadoorian<br>
Asst Professor of Geography, Temple University<br>
<a href="http://geospatial.commons.gc.cuny.edu/" rel="noreferrer" target="_blank">http://geospatial.commons.gc.cuny.edu/</a><br>
_______________________________________________<br>
postgis-users mailing list<br>
<a href="mailto:postgis-users@lists.osgeo.org">postgis-users@lists.osgeo.org</a><br>
<a href="http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users" rel="noreferrer" target="_blank">http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users</a><br>
</font></span></blockquote></div><br><br clear="all"><br>-- <br><div class="gmail_signature"><div dir="ltr"><div><div dir="ltr"><div><div dir="ltr"><div dir="ltr"><div dir="ltr"><div dir="ltr"><div dir="ltr"><div><div>Brian Wilson, GISP</div></div><div><div>@brian_32768</div></div><div><br></div></div></div></div></div></div></div></div></div></div></div>
</div>