Search Postgresql Archives

Re: how much left for restore?

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



On Friday 08 January 2010 11.28:15 Ivan Sergio Borgonovo wrote:
> It would be enough just knowing which part of the file is being
> restored (without causing too much extra IO, that will definitively
> put my notebook on its knee).

Highly platform dependent, but has helped me a lot recently with various 
(non-pg) tasks: on recent Linux, /proc/<pid>/fdinfo/ contains the current 
file pointer, so you can see how far in the dump file pg has read.  
(Assuming the restore reads the dump file just once from start to finish.)

Same problem as the other solutions with index creation etc. of course.

cheers
-- vbi

-- 
And those meanies used what we said to you and they misconstrued it to
mean what we said, and that's so unfair.
        -- SCO lawyers about IBM (paraphrased - groklaw)

Attachment: signature.asc
Description: This is a digitally signed message part.


[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux