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

Re: Problem with multi-job pg_restore

From: "Kevin Grittner" <Kevin(dot)Grittner(at)wicourts(dot)gov>
To: "Brian Weaver" <cmdrclueless(at)gmail(dot)com>, "Tom Lane" <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: Problem with multi-job pg_restore
Date: 2012-05-01 18:15:08
Message-ID: (view raw, whole thread or download thread mbox)
Lists: pgsql-hackers
Brian Weaver <cmdrclueless(at)gmail(dot)com> wrote:
> The restore appears to have finished without a problem. The issue
> I have is a running instance of postgres is still active in a COPY
> state after the restore. The process is running full tilt, almost
> like it's in a tight loop condition.
It's probably dumping all that new data you just restored to ...
somewhere.  You'll need to review the crontab job (or maybe ps
output) to figure out where.

In response to


pgsql-hackers by date

Next:From: Tom LaneDate: 2012-05-01 18:42:58
Subject: Re: Problem with multi-job pg_restore
Previous:From: Andrew DunstanDate: 2012-05-01 18:11:52
Subject: Re: JSON in 9.2 - Could we have just one to_json() function instead of two separate versions ?

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