| From: | Josh Kupershmidt <schmiddy(at)gmail(dot)com> |
|---|---|
| To: | Poul Møller Hansen <freebsd(at)pbnet(dot)dk> |
| Cc: | pgsql-general(at)postgresql(dot)org |
| Subject: | Re: Why are pg_restore taking that long ? |
| Date: | 2012-05-20 17:10:52 |
| Message-ID: | CAK3UJRHY=TsWUDsYpSZ=DhxwY3EX8GM8d6b0WidqNyVmAyugDA@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
On Sun, May 20, 2012 at 8:39 AM, Poul Møller Hansen <freebsd(at)pbnet(dot)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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Ian Harding | 2012-05-20 17:38:50 | Re: Locking or Something Else? |
| Previous Message | Tom Lane | 2012-05-20 16:22:22 | Re: Why are pg_restore taking that long ? |