Re: dropping template1

From: "Shridhar Daithankar" <shridhar_daithankar(at)persistent(dot)co(dot)in>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: dropping template1
Date: 2003-01-09 12:28:35
Message-ID: 3E1DB84B.13616.63EFEC@localhost
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On 9 Jan 2003 at 7:05, Dan Langille wrote:
> > If you absolutely instist, shutdown postmaster, go to database dir, do a rm -rf
> > there and doa initdb once again. Clean as slate..
>
> My initial concerns about the above advice where related to users and
> groups and the potential for loss of that data. After reading
> http://www.us.postgresql.org/users-lounge/docs/7.2/postgres/managing-databases.html
> I'm not as worried, but it got me wondering... Where are the user and
> group data held?

Of course in the same place. But if you are feeling lazy to drop each function
by hand, what is the alternative left?

You decide which one is labour intensive? Dropping functions or recreating
users..

Bye
Shridhar

--
Ingrate, n.: A man who bites the hand that feeds him, and then complains of
indigestion.

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Neil Conway 2003-01-09 13:06:06 Re: dropping template1
Previous Message Dan Langille 2003-01-09 12:05:18 Re: dropping template1