Skip site navigation (1) Skip section navigation (2)

pg_restore stuck in a loop?

From: Rod Taylor <pg(at)rbt(dot)ca>
To: PostgreSQL Development <pgsql-hackers(at)postgresql(dot)org>
Subject: pg_restore stuck in a loop?
Date: 2005-04-26 18:52:56
Message-ID: 1114541576.77587.18.camel@home (view raw or flat)
Thread:
Lists: pgsql-hackers
I took a pg_dump -Fc from a Pg 8.0.1 installation on (Solaris / Sun)
with Slony installed and attempted to restore to 8.0.2 on Linux / x86
without Slony installed.

pg_restore skipped all of the Slony related items, but then it
immediately jumped up to 700MB of memory usage and 99% CPU, but the DB
connection was idle. Two hours later, memory usage had gradually dropped
to 500MB, but CPU was still going full still with an idle database
connection.

I eventually clued in and made a TOC and removed all of the Slony items,
but I'm still curious to know what exactly pg_restore had been doing for
the last hour or so.

-- 


Responses

pgsql-hackers by date

Next:From: Rob ButlerDate: 2005-04-26 19:01:06
Subject: Re: DO INSTEAD and conditional rules
Previous:From: Tom LaneDate: 2005-04-26 18:20:16
Subject: Re: DO INSTEAD and conditional rules

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group