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 |
Subject: | Re: Trying to pg_restore a 7.1.3 db into 7.3.4 - stalling |
Date: | 2003-11-12 09:11:16 |
Message-ID: | 2B822AF8-14F0-11D8-86D7-000393A5890E@shanewright.co.uk |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-admin |
Hi,
> fd 0 is usually stdin, unless the program disconnects stdin.
> Maybe pg_restore is waiting for input, perhaps a password?
certainly shouldn't be - the table where the problem happens is no
different to any of the others, but I will try doing just that table
later today and see if that makes any difference.
Wouldn't it have outputted something though; like a prompt for input or
something?
Regards
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/
>
> ---------------------------(end of
> broadcast)---------------------------
> TIP 8: explain analyze is your friend
>
From | Date | Subject | |
---|---|---|---|
Next Message | Sander Steffann | 2003-11-12 09:29:30 | Re: RHEL |
Previous Message | pginfo | 2003-11-12 05:19:13 | Re: vacuum full problem |