PGAdmin III v1.6.1 bug - Mailing list pgadmin-support

From Patrick Headley
Subject PGAdmin III v1.6.1 bug
Date
Msg-id 004201c717d6$74e344c0$730ba8c0@LinxConsulting.local
Whole thread Raw
Responses Re: PGAdmin III v1.6.1 bug  (Dave Page <dpage@postgresql.org>)
List pgadmin-support
<div class="Section1"><p class="MsoNormal"><font face="Arial" size="2"><span style="font-size:10.0pt;
font-family:Arial">PGAdmin III v1.6.1 binary install</span></font><p class="MsoNormal"><font face="Arial"
size="2"><spanstyle="font-size:10.0pt; 
font-family:Arial">Windows XP SP2 with all known patches</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">This was an issue in v1.4.2, as well.</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">I can backup a PostgreSQL v8.0.4 database with large objects with no problems. However, if I use
PGAdminIIIv1.6.1 to restore the database I receive an error message when pg_restore tries to restore the large objects
andthen the return code is set to 1. I have created a pgpass.conf file in the Application Data folder of the profile
thatI’m logged into when using PGAdminIII but that has no effect. If it’s supposed to then maybe I did something wrong.
Theway I successfully restore the database is to go into a command window on a different machine (Windows Server 2003
inthis case) and run pg_restore from there. At the point where PGAdminIII fails, the command prompt version of
pg_restoreprompts for the password again.</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 posted this issue before but I didn’t provide as much information because the problem is so easy
toreproduce and because I was very busy at the time. If you need more information on how to reproduce the problem,
pleaselet me know.</span></font><p class="MsoNormal"><font face="Arial" size="2"><span style="font-size:10.0pt; 
font-family:Arial"> </span></font><p class="MsoNormal"><b><i><font face="Times New Roman" size="2"><span
style="font-size:10.0pt;font-weight:bold;font-style:italic">PatrickHeadley<br /></span></font></i></b><font
size="2"><spanstyle="font-size:10.0pt">Linx Consulting, Inc.<br /> (303) 916-5522<br /><a
href="mailto:LinxConsulting@comcast.net">LinxConsulting@comcast.net</a><br/><a
href="http://www.linxco-inc.com">www.linxco-inc.com</a></span></font><pclass="MsoNormal"><font face="Times New Roman"
size="3"><spanstyle="font-size: 
12.0pt"> </span></font></div>

pgadmin-support by date:

Previous
From: "Patrick Headley"
Date:
Subject: Bug in PGAdmin III v1.6.1
Next
From: "Raymond O'Donnell"
Date:
Subject: Re: Bug in PGAdmin III v1.6.1