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 v
On Mon, 11 Jan 2010 18:36:18 +
Sam Mason wrote:
> On Fri, Jan 08, 2010 at 11:28:15AM +0100, Ivan Sergio Borgonovo
> wrote:
> > Is there a way to know/estimate how much is left to complete a
> > restore?
> maybe something like "pv" would help?
> http://www.ivarch.com/programs/pv.shtml
Nic
Sam Mason writes:
maybe something like "pv" would help?
http://www.ivarch.com/programs/pv.shtml
I think it may help the OP, but indexes are still going to be a rough spot..
if large table has several indexes the output from pv will be missleading.
--
Sent via pgsql-general mailing list
On Fri, Jan 08, 2010 at 11:28:15AM +0100, Ivan Sergio Borgonovo wrote:
> Is there a way to know/estimate how much is left to complete a
> restore?
maybe something like "pv" would help?
http://www.ivarch.com/programs/pv.shtml
--
Sam http://samason.me.uk/
--
Sent via pgsql-general mailing
Ivan Sergio Borgonovo writes:
It get a bit better but even knowing what are the largest tables it
is hard to get an estimate of how much is missing before complete
restore.
Agree. Also building indexes can also take quite some time.
I'm really looking at rough figures... even a: I've read 40
On Mon, 11 Jan 2010 12:30:45 -0500
Francisco Reyes wrote:
> Ivan Sergio Borgonovo writes:
>
> > Is there a way to know/estimate how much is left to complete a
> > restore?
>
> Not sure on plain ASCII files but if your pg_dump used Fc then at
> restore you can pass the -v flag.
It get a bit be
Ivan Sergio Borgonovo writes:
Is there a way to know/estimate how much is left to complete a
restore?
Not sure on plain ASCII files but if your pg_dump used Fc then at restore
you can pass the -v flag.
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes t
Is there a way to know/estimate how much is left to complete a
restore?
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).
Next time I try a restore on this box is there anything I could