Re: Trying to pg_restore a 7.1.3 db into 7.3.4 - stalling

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
>

In response to

Browse pgsql-admin by date

  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