Received: from localhost (wm.hub.org [200.46.204.128])
	by postgresql.org (Postfix) with ESMTP id C8B989FA4E0
	for <pgsql-sql-postgresql.org@postgresql.org>;
	Thu,  5 Oct 2006 01:40:24 -0300 (ADT)
Received: from postgresql.org ([200.46.204.71])
	by localhost (mx1.hub.org [200.46.204.128]) (amavisd-new, port 10024)
	with ESMTP id 47599-09 for <pgsql-sql-postgresql.org@postgresql.org>;
	Thu,  5 Oct 2006 04:40:20 +0000 (UTC)
X-Greylist: from auto-whitelisted by SQLgrey-
Received: from smtp107.plus.mail.re2.yahoo.com
	(smtp107.plus.mail.re2.yahoo.com [206.190.53.32])
	by postgresql.org (Postfix) with SMTP id 7F7299FB207
	for <pgsql-sql@postgresql.org>; Thu,  5 Oct 2006 01:40:17 -0300 (ADT)
Received: (qmail 83272 invoked from network); 5 Oct 2006 04:33:35 -0000
DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=s1024; d=yahoo.com;
	h=Received:From:To:Subject:Date:MIME-Version:Content-Type:X-Mailer:X-MimeOLE:Thread-Index;
	b=M17JgyWwhBme/yvMaZ5K78L2WqJRART4i4UnEtHYepM/Ly8go40TDOXgE0mdgkrnEl6DakIbQNRElvmKZa8GWiG9IGL6a+4XOgO2cFXiEhHxjRa1SwKi6a3X0yMW/nCDilLbqWLRxL0qZIWGNx1/XmajHbGQOQrSQubonmTbv2U=
	;
Received: from unknown (HELO synaptic1) (jrpbax@216.15.32.152 with login)
	by smtp107.plus.mail.re2.yahoo.com with SMTP; 5 Oct 2006 04:33:34 -0000
From: "James Baxendale" <jrpbax@yahoo.com>
To: <pgsql-sql@postgresql.org>
Subject: psql hangs during load of pg_dumpall file
Date: Thu, 5 Oct 2006 00:33:50 -0400
MIME-Version: 1.0
Content-Type: multipart/alternative;
	boundary="----=_NextPart_000_01B3_01C6E815.EDD84A10"
X-Mailer: Microsoft Office Outlook, Build 11.0.6353
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.2962
Thread-Index: AcboN3RmEuYkmEorS3qRp0CzL3xjTA==
Message-Id: <20061005044020.7F7299FB207@postgresql.org>
X-Virus-Scanned: Maia Mailguard 1.0.1
X-Spam-Status: No, hits=4.749 tagged_above=0 required=5
	tests=DNS_FROM_RFC_ABUSE, DNS_FROM_RFC_POST, DNS_FROM_RFC_WHOIS,
	HTML_MESSAGE, MSGID_FROM_MTA_ID
X-Spam-Level: ****
X-Archive-Number: 200610/55
X-Sequence-Number: 26444

This is a multi-part message in MIME format.

------=_NextPart_000_01B3_01C6E815.EDD84A10
Content-Type: text/plain;
	charset="us-ascii"
Content-Transfer-Encoding: 7bit

Hi,

 

I am using version 8.1.3 on Windows XP professional (I have also tested this
under 8.1.4). I have created a pg_dumpall file from my database after
loading a couple of megabytes of data (approximately 2 Mbytes) into a schema
containing roughly 30 tables and 20 sequences. 

 

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:

 

"C:\Program Files\PostgreSQL\8.1\bin\psql.exe" -h localhost -p <non standard
port> -U postgres -f pg_dumpall_ouput_file.sql

 

After about 5 to 10 seconds the scripted commands in
pg_dumpall_ouput_file.sql hangs forever without producing any error
messages. The interesting and annoying from the point of view of trying to
debug what is going on is that after I kill the psql process and retry the
script will hang at different points in the process of running the commands
in the pg_dumpall_ouput_file.sql file. At one point after trying to load
this file about 20 times with various uninstall and re-install attempts of
PostgreSQL in between to ensure that the installation was not somehow
corrupt (both with 8.1.3 and 8.1.4) I eventually got the data loaded.

 

Has anyone ever seen behavior like this before and does anyone have any
suggestions of how to track down what is causing the load process to hang.
BTW, I am pretty sure nothing else is causing deadlock on any of the tables
in question as I can repeat this behavior after a reboot of my machine
followed by the issuance of the command above without running any other
applications.

 

I can still connect to the database using pgAdmin III after the script of
commands hangs so the database seems to still be 'alive' after the psql
process hangs.

 

Any ideas of how to proceed would be greatly appreciated.

 

Thanks,

 

James

 

 

 

 


------=_NextPart_000_01B3_01C6E815.EDD84A10
Content-Type: text/html;
	charset="us-ascii"
Content-Transfer-Encoding: quoted-printable

<html xmlns:o=3D"urn:schemas-microsoft-com:office:office" =
xmlns:w=3D"urn:schemas-microsoft-com:office:word" =
xmlns=3D"http://www.w3.org/TR/REC-html40">

<head>
<META HTTP-EQUIV=3D"Content-Type" CONTENT=3D"text/html; =
charset=3Dus-ascii">
<meta name=3DGenerator content=3D"Microsoft Word 11 (filtered medium)">
<style>
<!--
 /* Style Definitions */
 p.MsoNormal, li.MsoNormal, div.MsoNormal
	{margin:0in;
	margin-bottom:.0001pt;
	font-size:12.0pt;
	font-family:"Times New Roman";}
a:link, span.MsoHyperlink
	{color:blue;
	text-decoration:underline;}
a:visited, span.MsoHyperlinkFollowed
	{color:purple;
	text-decoration:underline;}
span.EmailStyle17
	{mso-style-type:personal-compose;
	font-family:Arial;
	color:windowtext;}
@page Section1
	{size:8.5in 11.0in;
	margin:1.0in 1.25in 1.0in 1.25in;}
div.Section1
	{page:Section1;}
-->
</style>

</head>

<body lang=3DEN-US link=3Dblue vlink=3Dpurple>

<div class=3DSection1>

<p class=3DMsoNormal><font size=3D2 face=3DArial><span =
style=3D'font-size:10.0pt;
font-family:Arial'>Hi,<o:p></o:p></span></font></p>

<p class=3DMsoNormal><font size=3D2 face=3DArial><span =
style=3D'font-size:10.0pt;
font-family:Arial'><o:p>&nbsp;</o:p></span></font></p>

<p class=3DMsoNormal><font size=3D2 face=3DArial><span =
style=3D'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 created a pg_dumpall file from my
database after loading a couple of megabytes of data (approximately 2 =
Mbytes)
into a schema containing roughly 30 tables and 20 sequences. =
<o:p></o:p></span></font></p>

<p class=3DMsoNormal><font size=3D2 face=3DArial><span =
style=3D'font-size:10.0pt;
font-family:Arial'><o:p>&nbsp;</o:p></span></font></p>

<p class=3DMsoNormal><font size=3D2 face=3DArial><span =
style=3D'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:<o:p></o:p></span></font></p>

<p class=3DMsoNormal><font size=3D2 face=3DArial><span =
style=3D'font-size:10.0pt;
font-family:Arial'><o:p>&nbsp;</o:p></span></font></p>

<p class=3DMsoNormal><font size=3D2 face=3DArial><span =
style=3D'font-size:10.0pt;
font-family:Arial'>&quot;C:\Program =
Files\PostgreSQL\8.1\bin\psql.exe&quot; -h
localhost -p &lt;non standard port&gt; -U postgres -f =
pg_dumpall_ouput_file.sql<o:p></o:p></span></font></p>

<p class=3DMsoNormal><font size=3D2 face=3DArial><span =
style=3D'font-size:10.0pt;
font-family:Arial'><o:p>&nbsp;</o:p></span></font></p>

<p class=3DMsoNormal><font size=3D2 face=3DArial><span =
style=3D'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 producing any error =
messages.
The interesting and annoying from the point of view of trying to debug =
what is
going on is that after I kill the psql process and retry the script will =
hang
at different points in the process of running the commands in the
pg_dumpall_ouput_file.sql file. At one point after trying to load this =
file
about 20 times with various uninstall and re-install attempts of =
PostgreSQL in
between to ensure that the installation was not somehow corrupt (both =
with
8.1.3 and 8.1.4) I eventually got the data =
loaded.<o:p></o:p></span></font></p>

<p class=3DMsoNormal><font size=3D2 face=3DArial><span =
style=3D'font-size:10.0pt;
font-family:Arial'><o:p>&nbsp;</o:p></span></font></p>

<p class=3DMsoNormal><font size=3D2 face=3DArial><span =
style=3D'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 down what is causing the load =
process to
hang. BTW, I am pretty sure nothing else is causing deadlock on any of =
the
tables in question as I can repeat this behavior after a reboot of my =
machine
followed by the issuance of the command above without running any other
applications.<o:p></o:p></span></font></p>

<p class=3DMsoNormal><font size=3D2 face=3DArial><span =
style=3D'font-size:10.0pt;
font-family:Arial'><o:p>&nbsp;</o:p></span></font></p>

<p class=3DMsoNormal><font size=3D2 face=3DArial><span =
style=3D'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 database seems to still be
&#8216;alive&#8217; after the psql process =
hangs.<o:p></o:p></span></font></p>

<p class=3DMsoNormal><font size=3D2 face=3DArial><span =
style=3D'font-size:10.0pt;
font-family:Arial'><o:p>&nbsp;</o:p></span></font></p>

<p class=3DMsoNormal><font size=3D2 face=3DArial><span =
style=3D'font-size:10.0pt;
font-family:Arial'>Any ideas of how to proceed would be greatly =
appreciated.<o:p></o:p></span></font></p>

<p class=3DMsoNormal><font size=3D2 face=3DArial><span =
style=3D'font-size:10.0pt;
font-family:Arial'><o:p>&nbsp;</o:p></span></font></p>

<p class=3DMsoNormal><font size=3D2 face=3DArial><span =
style=3D'font-size:10.0pt;
font-family:Arial'>Thanks,<o:p></o:p></span></font></p>

<p class=3DMsoNormal><font size=3D2 face=3DArial><span =
style=3D'font-size:10.0pt;
font-family:Arial'><o:p>&nbsp;</o:p></span></font></p>

<p class=3DMsoNormal><font size=3D2 face=3DArial><span =
style=3D'font-size:10.0pt;
font-family:Arial'>James<o:p></o:p></span></font></p>

<p class=3DMsoNormal><font size=3D2 face=3DArial><span =
style=3D'font-size:10.0pt;
font-family:Arial'><o:p>&nbsp;</o:p></span></font></p>

<p class=3DMsoNormal><font size=3D2 face=3DArial><span =
style=3D'font-size:10.0pt;
font-family:Arial'><o:p>&nbsp;</o:p></span></font></p>

<p class=3DMsoNormal><font size=3D3 face=3D"Times New Roman"><span =
style=3D'font-size:
12.0pt'><o:p>&nbsp;</o:p></span></font></p>

<p class=3DMsoNormal><font size=3D3 face=3D"Times New Roman"><span =
style=3D'font-size:
12.0pt'><o:p>&nbsp;</o:p></span></font></p>

</div>

</body>

</html>

------=_NextPart_000_01B3_01C6E815.EDD84A10--