psql hangs during load of pg_dumpall file - Mailing list pgsql-sql

<div class="Section1"><p class="MsoNormal"><font face="Arial" size="2"><span style="font-size:10.0pt;
font-family:Arial">Hi,</span></font><p class="MsoNormal"><font face="Arial" size="2"><span style="font-size:10.0pt;
font-family:Arial"> </span></font><p class="MsoNormal"><font face="Arial" size="2"><span style="font-size:10.0pt;
font-family:Arial">I am using version 8.1.3 on Windows XP professional (I have also tested this under 8.1.4). I have
createda pg_dumpall file from my database after loading a couple of megabytes of data (approximately 2 Mbytes) into a
schemacontaining roughly 30 tables and 20 sequences. </span></font><p class="MsoNormal"><font face="Arial"
size="2"><spanstyle="font-size:10.0pt; 
font-family:Arial"> </span></font><p class="MsoNormal"><font face="Arial" size="2"><span style="font-size:10.0pt;
font-family:Arial">When I try to recreate my database from the pg_dumpall output file the psql session I am using hangs
forever.The command I am using to load the pg_dumpall file is:</span></font><p class="MsoNormal"><font face="Arial"
size="2"><spanstyle="font-size:10.0pt; 
font-family:Arial"> </span></font><p class="MsoNormal"><font face="Arial" size="2"><span style="font-size:10.0pt;
font-family:Arial">"C:\Program Files\PostgreSQL\8.1\bin\psql.exe" -h localhost -p <non standard port> -U postgres
-fpg_dumpall_ouput_file.sql</span></font><p class="MsoNormal"><font face="Arial" size="2"><span
style="font-size:10.0pt;
font-family:Arial"> </span></font><p class="MsoNormal"><font face="Arial" size="2"><span style="font-size:10.0pt;
font-family:Arial">After about 5 to 10 seconds the scripted commands in pg_dumpall_ouput_file.sql hangs forever without
producingany error messages. The interesting and annoying from the point of view of trying to debug what is going on is
thatafter I kill the psql process and retry the script will hang at different points in the process of running the
commandsin the pg_dumpall_ouput_file.sql file. At one point after trying to load this file about 20 times with various
uninstalland re-install attempts of PostgreSQL in between to ensure that the installation was not somehow corrupt (both
with8.1.3 and 8.1.4) I eventually got the data loaded.</span></font><p class="MsoNormal"><font face="Arial"
size="2"><spanstyle="font-size:10.0pt; 
font-family:Arial"> </span></font><p class="MsoNormal"><font face="Arial" size="2"><span style="font-size:10.0pt;
font-family:Arial">Has anyone ever seen behavior like this before and does anyone have any suggestions of how to track
downwhat is causing the load process to hang. BTW, I am pretty sure nothing else is causing deadlock on any of the
tablesin question as I can repeat this behavior after a reboot of my machine followed by the issuance of the command
abovewithout running any other applications.</span></font><p class="MsoNormal"><font face="Arial" size="2"><span
style="font-size:10.0pt;
font-family:Arial"> </span></font><p class="MsoNormal"><font face="Arial" size="2"><span style="font-size:10.0pt;
font-family:Arial">I can still connect to the database using pgAdmin III after the script of commands hangs so the
databaseseems to still be ‘alive’ after the psql process hangs.</span></font><p class="MsoNormal"><font face="Arial"
size="2"><spanstyle="font-size:10.0pt; 
font-family:Arial"> </span></font><p class="MsoNormal"><font face="Arial" size="2"><span style="font-size:10.0pt;
font-family:Arial">Any ideas of how to proceed would be greatly appreciated.</span></font><p class="MsoNormal"><font
face="Arial"size="2"><span style="font-size:10.0pt; 
font-family:Arial"> </span></font><p class="MsoNormal"><font face="Arial" size="2"><span style="font-size:10.0pt;
font-family:Arial">Thanks,</span></font><p class="MsoNormal"><font face="Arial" size="2"><span style="font-size:10.0pt;
font-family:Arial"> </span></font><p class="MsoNormal"><font face="Arial" size="2"><span style="font-size:10.0pt;
font-family:Arial">James</span></font><p class="MsoNormal"><font face="Arial" size="2"><span style="font-size:10.0pt;
font-family:Arial"> </span></font><p class="MsoNormal"><font face="Arial" size="2"><span style="font-size:10.0pt;
font-family:Arial"> </span></font><p class="MsoNormal"><font face="Times New Roman" size="3"><span style="font-size:
12.0pt"> </span></font><p class="MsoNormal"><font face="Times New Roman" size="3"><span style="font-size:
12.0pt"> </span></font></div>