Re: Why are pg_restore taking that long ?

On Sun, May 20, 2012 at 8:39 AM, Poul Møller Hansen <freebsd@pbnet.dk> wrote:

>> Anyway, if you are seeing no activity at the end of the restore for quite
>> a while you may want to see if large objects are the reason.
>>
>
> The dump are from a version 9.0.7 and it's being restored in a version
> 9.1.3. There are no large objects.
>
> I'm now doing another restore with the -v switch, and hopefully it will show
> what it is doing at the end.
> There are Bucardo triggers in the database. Perhaps it can be the reason,
> and it should be restored with the "--disable-triggers" switch ?

Possibly. You should be able to tell what's taking so much time by
keeping an eye on your server during the restore. You could set
log_statement = 'all' (or just 'ddl' if there is significant other
activity in other databases) during the restore, and keep an eye on
pg_stat_activity if you need to.


Josh