From: | Rich Shepard <rshepard(at)appl-ecosys(dot)com> |
---|---|
To: | pdxpug(at)postgresql(dot)org |
Subject: | Re: Dropping Old Databases |
Date: | 2009-02-03 01:23:24 |
Message-ID: | alpine.LNX.2.00.0902021717240.10520@salmo.appl-ecosys.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pdxpug |
On Mon, 2 Feb 2009, Selena Deckelmann wrote:
> Look at your process table (using 'ps' or the equivalent on your operating
> system) or pg_stat_activity and see if you have open connections to those
> databases. And, then you probably should kill off those processes (just
> use normal kill, not kill -9). Then you can drop the tables.
Hi, Selena!
Sonofagun! I wonder how two processes for each of those databases were
started. Perhaps by my examining them with psql?
These were created by some apps I looked at a few years ago and decided
against using for one reason or another. But, I never cleaned up after
myself.
BTW, are there any TinyERP/OpenERP users locally?
Thank you,
Rich
--
Richard B. Shepard, Ph.D. | Integrity Credibility
Applied Ecosystem Services, Inc. | Innovation
<http://www.appl-ecosys.com> Voice: 503-667-4517 Fax: 503-667-8863
From | Date | Subject | |
---|---|---|---|
Next Message | Rich Shepard | 2009-02-03 03:04:06 | Next: Encoding Issue |
Previous Message | Selena Deckelmann | 2009-02-03 01:11:21 | Re: Dropping Old Databases |