Re: Trying to pg_restore a 7.1.3 db into 7.3.4 - stalling at 100% - Mailing list 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@jefftrout.com>
> http://www.jefftrout.com/
> http://www.stuarthamm.net/
>