From: | Shane Wright <me(at)shanewright(dot)co(dot)uk> |
---|---|
To: | Jeff <threshar(at)torgo(dot)978(dot)org> |
Cc: | pgsql-admin(at)postgresql(dot)org, Gaetano Mendola <mendola(at)bigfoot(dot)com> |
Subject: | Re: Trying to pg_restore a 7.1.3 db into 7.3.4 - stalling at 100% |
Date: | 2003-11-14 22:44:12 |
Message-ID: | 1115108F-16F4-11D8-803A-000393A5890E@shanewright.co.uk |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-admin |
Hi,
I've used this command to dump just the table concerned, and I get a
zero length file!?! No errors or anything, just a silent exit.
pg_dump -U xx-S xx -F t -a -t tablename mydatabase > ~/backup/mytable
Any ideas? I'm thinking the zero-sized file could be what was causing
the read()s to fail, but as to why it's happening in the first place I
can't think..
Cheers
Shane
On 11 Nov 2003, at 19:52, Jeff wrote:
>> read(0, "", 4096) = 0
>> read(0, "", 4096) = 0
>> read(0, "", 4096) = 0
>> read(0, "", 4096) = 0
>> read(0, "", 4096) = 0
>> read(0, "", 4096) = 0
>> read(0, "", 4096) = 0
>> read(0, "", 4096) = 0
>>
>
> fd 0 is usually stdin, unless the program disconnects stdin.
> Maybe pg_restore is waiting for input, perhaps a password?
>
> --
> Jeff Trout <jeff(at)jefftrout(dot)com>
> http://www.jefftrout.com/
> http://www.stuarthamm.net/
>
From | Date | Subject | |
---|---|---|---|
Next Message | James Rogers | 2003-11-14 22:47:09 | Re: Which hardware/filesystem for postgresql? |
Previous Message | Glenn Wiorek | 2003-11-14 22:04:59 | Re: YOUR SITES SEARCH FEATURE DOES NOT WORK! |