| 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 |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| 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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Luckys | 2006-04-17 04:58:02 | Re: connection problem in postgresql |
| Previous Message | Patrick Headley | 2006-04-17 02:37:32 | Re: BUG #2386: pg_restore doesn't restore large objects |