Re: How to drop a database cluster?

Lists: pgsql-admin
From: Slobodan <slobodan(at)freemail(dot)hu>
To: pgsql-admin(at)postgresql(dot)org
Subject: How to drop a database cluster?
Date: 2004-10-21 14:43:01
Message-ID: freemail.20040921164301.54619@fm5.freemail.hu
Views: Raw Message | Whole Thread | Download mbox | Resend email
Lists: pgsql-admin

Hi!

I cannot find the way of dropping a database cluster in the
documentation. Should I simply remove the directory associated with
the cluster?

Slobodan


From: Robert Treat <xzilla(at)users(dot)sourceforge(dot)net>
To: Slobodan <slobodan(at)freemail(dot)hu>
Cc: pgsql-admin(at)postgresql(dot)org
Subject: Re: How to drop a database cluster?
Date: 2004-10-21 18:36:15
Message-ID: 1098383775.15573.7.camel@camel
Views: Raw Message | Whole Thread | Download mbox | Resend email
Lists: pgsql-admin

On Thu, 2004-10-21 at 10:43, Slobodan wrote:
> Hi!
>
> I cannot find the way of dropping a database cluster in the
> documentation. Should I simply remove the directory associated with
> the cluster?
>

I take you don't want to use the DROP DATABASE command, but instead are
trying to drop all databases from a system? If so, remove whatever
directory PGDATA is set to and then run initdb on the new PGDATA
directory. Be aware that this is basically like starting from scratch,
you will lose all of your information.

Robert Treat
--
Build A Brighter Lamp :: Linux Apache {middleware} PostgreSQL