Re: how much left for restore? - Mailing list pgsql-general

From Ivan Sergio Borgonovo
Subject Re: how much left for restore?
Date
Msg-id 20100111211402.6301d044@dawn.webthatworks.it
Whole thread Raw
In response to Re: how much left for restore?  (Sam Mason <sam@samason.me.uk>)
List pgsql-general
On Mon, 11 Jan 2010 18:36:18 +0000
Sam Mason <sam@samason.me.uk> 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

Nice. Start to look more as what I was looking for... and yeah...
I'm aware it could be misleading.

It would be nice to have it integrated in pg_restore/dump.
If the file is compressed pg_* may make a better work to give an
estimate.

thanks

--
Ivan Sergio Borgonovo
http://www.webthatworks.it


pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: does autovacuum in postgres-8.1.2 use prepared transactions ??
Next
From: Andy Colson
Date:
Subject: Re: migration: parameterized statement and cursor