Re: Dropping Old Databases

I'm trying to set up TinyERP which uses postgres as a back end (the first
CRM I've found that does so). The docs are non-existent, so I'm working
trial-and-error.

Anyway, I have a few empty databases that were created long ago and I
cannot drop them. When I try to I see this:

[rshepard(at)salmo ~]$ dropdb contacts
dropdb: database removal failed: ERROR: database "contacts" is being
accessed by other users
[rshepard(at)salmo ~]$ dropdb eiabusiness
dropdb: database removal failed: ERROR: database "eiabusiness" is being
accessed by other users

Since I'm the only human user on this system, I've no idea what "other
users" are currently accessing those dbs.

What do I need to do to drop them?

Thanks,

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

On Mon, Feb 2, 2009 at 5:05 PM, Rich Shepard <rshepard(at)appl-ecosys(dot)com> wrote:
> I'm trying to set up TinyERP which uses postgres as a back end (the first
> CRM I've found that does so). The docs are non-existent, so I'm working
> trial-and-error.
>
> Anyway, I have a few empty databases that were created long ago and I
> cannot drop them. When I try to I see this:
>
> [rshepard(at)salmo ~]$ dropdb contacts
> dropdb: database removal failed: ERROR: database "contacts" is being
> accessed by other users
> [rshepard(at)salmo ~]$ dropdb eiabusiness
> dropdb: database removal failed: ERROR: database "eiabusiness" is being
> accessed by other users
>
> Since I'm the only human user on this system, I've no idea what "other
> users" are currently accessing those dbs.
>
> What do I need to do to drop them?

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.

-selena

--
Selena Deckelmann
Open Source Bridge - http://www.opensourcebridge.org
PDXPUG - http://pugs.postgresql.org/pdx
Me - http://www.chesnok.com/daily

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

Have you looked at Xtuple which also runs on Postgres? http://www.xtuple.com/postbooks

I haven't used the software, I just grabbed some brochures at OSCON last year.

>-----Original Message-----
>From: pdxpug-owner(at)postgresql(dot)org
>[mailto:pdxpug-owner(at)postgresql(dot)org] On Behalf Of Rich Shepard
>Sent: Monday, February 02, 2009 5:06 PM
>To: pdxpug(at)postgresql(dot)org
>Subject: [pdxpug] Dropping Old Databases
>
>
> I'm trying to set up TinyERP which uses postgres as a back
>end (the first
>CRM I've found that does so). The docs are non-existent, so I'm working
>trial-and-error.
>

On Mon, 2 Feb 2009, Ewan, Michael wrote:

> Have you looked at Xtuple which also runs on Postgres?
> http://www.xtuple.com/postbooks

No, but I will. Regardless of whose software it is, I need only the CRM
part to track my selling efforts and I want to use the existing postgres or
sqlite installations and not add mysql.

Thanks for the pointer.

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

On Tue, Feb 3, 2009 at 6:14 AM, Rich Shepard <rshepard(at)appl-ecosys(dot)com> wrote:
> On Mon, 2 Feb 2009, Ewan, Michael wrote:
>
>> Have you looked at Xtuple which also runs on Postgres?
>> http://www.xtuple.com/postbooks
>
> No, but I will. Regardless of whose software it is, I need only the CRM
> part to track my selling efforts and I want to use the existing postgres or
> sqlite installations and not add mysql.

They have a CRM module. It is about 1.5 years old, and was ok last
time I looked at it. May be better now. They refactored their
customer data tables around that same time, and made things a bit
nicer for plugging into other systems.

Their primary strength is MRP and a crazy complex, but flexible
accounting module. They've got their own reporting tool which is
reasonable and uses XML, so you can parse your own stuff if the GUI
drives you nuts.

And, generally speaking, the UI is actually pretty nice.

You don't get MRP with the open source version, but maybe someday
they'll fix that :)

-selena

--
Selena Deckelmann
Open Source Bridge - http://www.opensourcebridge.org
PDXPUG - http://pugs.postgresql.org/pdx
Me - http://www.chesnok.com/daily

On Tue, 3 Feb 2009, Selena Deckelmann wrote:

> They have a CRM module. It is about 1.5 years old, and was ok last time I
> looked at it. May be better now. They refactored their customer data
> tables around that same time, and made things a bit nicer for plugging
> into other systems.

Selena,

Thank you. I created the database from the command line, then opened it
within TinyERP; it has a 'database create' menu option but I've no idea what
that's for if they want the db created externally. Now to see how to
populate it with tables so I can actually try using it.

> Their primary strength is MRP ...

I assume that's Manufacturing related. All I'm trying to manufacture is
sales of our permitting services. :-)

Thank you for the input,

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

On Tue, 3 Feb 2009, Rich Shepard wrote:

> Now to see how to populate it with tables so I can actually try using it.

Hoo-ha! If the created db is named 'terp' (not to be confused with the
federal government's 'tarp'), and the tinyerp-server is stopped, then all
tables are created when the server is restarted.

Progress,

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