On Sun, May 20, 2012 at 8:39 AM, Poul Møller Hansen <free...@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 -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
