The following bug has been logged online:
Bug reference: 4924
Logged by: Jim Michaels
Email address: jmichae3(at)yahoo(dot)com
PostgreSQL version: 8.4.0
Operating system: Windows XP Pro SP3
Description: pg_restore hangs, does nothing
I am on Windows XP Pro SP3.
1. could somebody rewrite pg_dumpall and pg_dump so that it makes editable
programmer's text editors can't handle more than 2000 characters per line.
and I want to be able to edit my dumps.
2. pg_restore doesn't seem to do anything but hang when I try to restore.
I did a pg_dumpall from 8.3.7:
pg_dumpall --file=c:\pg-jmichae3-7-13-2009.sql --role=postgres
then I did a pg_restore to 8.4:
pg_restore --file=c:\pg-jmichae3-7-13-2009.sql --role=postgres --verbose
and it printed nothing. it just sat there with the cursor blinking. I
expected a lot of output.
there is binary data in blobs I think.
I don't know why this is. but can you fix it?
the workaround is to use psql. it works.
I have some log files, but I am not sure which ones to look at, because I
didn't think to look at the logs after the lockups, and my database is
the database consists of part of the geoip database and the size of the log
is 144MB, so I can't post it here.
how would you like to proceed?
I have a web site I posted the sql file (10MB) and my un-verbose logs
(200MB) on, and I have a few gig of space left:
does the windows enterprisedb one-click installer allow you to change the
If it does, I can probably reproduce with verbose logs.
Jim Michaels <jmichae3(at)yahoo(dot)com>
pgsql-bugs by date
|Next:||From: Don Fox||Date: 2009-07-15 23:18:00|
|Subject: Installation problems|
|Previous:||From: Alan Pinstein||Date: 2009-07-15 15:36:01|
|Subject: Re: BUG #4921: ltree @> ltree operator shouldn't fail if
ltree is empty|