Re: Trying to pg_restore a 7.1.3 db into 7.3.4 - stalling
От | Shane Wright |
---|---|
Тема | Re: Trying to pg_restore a 7.1.3 db into 7.3.4 - stalling |
Дата | |
Msg-id | 2B822AF8-14F0-11D8-86D7-000393A5890E@shanewright.co.uk обсуждение исходный текст |
Ответ на | Re: Trying to pg_restore a 7.1.3 db into 7.3.4 - stalling (Jeff <threshar@torgo.978.org>) |
Список | 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 по дате отправления: