Skip site navigation (1) Skip section navigation (2)

Re: BUG #2386: pg_restore doesn't restore large objects

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "Patrick Headley" <linxconsulting(at)comcast(dot)net>
Cc: "'Andreas Pflug'" <pgadmin(at)pse-consulting(dot)de>, "'Dave Page'" <dpage(at)vale-housing(dot)co(dot)uk>, "'Bruce Momjian'" <pgman(at)candle(dot)pha(dot)pa(dot)us>, pgsql-bugs(at)postgresql(dot)org
Subject: Re: BUG #2386: pg_restore doesn't restore large objects
Date: 2006-04-17 02:52:18
Message-ID: 20584.1145242338@sss.pgh.pa.us (view raw or flat)
Thread:
Lists: pgsql-bugs
"Patrick Headley" <linxconsulting(at)comcast(dot)net> writes:
> I then switched over to a Windows Server 2003 machine with PostgreSQL 8.0.4
> installed and used pg_restore from the PostgreSQL bin folder. The version
> for pg_restore on that machine is v8.0.4.5277. On the Windows 2003 machine
> the restore worked. Only thing is that I lost a lot of the output from
> pg_restore that appeared in the command window because the lines scrolled
> out of the display buffer. However, at the point where the error occurred on
> the Windows XP machine the Windows 2003 machine prompted me for the password
> a second time.

Hm, that's interesting.  IIRC, pre-8.1 pg_restore uses a second
connection while trying to restore blobs.  It sounds like you're
describing some sort of failure to establish that second connection.
Do the two servers have identical pg_hba.conf setups?

			regards, tom lane

In response to

pgsql-bugs by date

Next:From: LuckysDate: 2006-04-17 04:58:02
Subject: Re: connection problem in postgresql
Previous:From: Patrick HeadleyDate: 2006-04-17 02:37:32
Subject: Re: BUG #2386: pg_restore doesn't restore large objects

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group