Re: Trying to pg_restore a 7.1.3 db into 7.3.4 - stalling - Mailing list pgsql-admin

From Shane Wright
Subject Re: Trying to pg_restore a 7.1.3 db into 7.3.4 - stalling
Date
Msg-id 2B822AF8-14F0-11D8-86D7-000393A5890E@shanewright.co.uk
Whole thread Raw
In response to Re: Trying to pg_restore a 7.1.3 db into 7.3.4 - stalling  (Jeff <threshar@torgo.978.org>)
List 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@jefftrout.com>
> http://www.jefftrout.com/
> http://www.stuarthamm.net/
>
> ---------------------------(end of
> broadcast)---------------------------
> TIP 8: explain analyze is your friend
>


pgsql-admin by date:

Previous
From: Andrew Rawnsley
Date:
Subject: Re: backup restore
Next
From: "Sander Steffann"
Date:
Subject: Re: RHEL