| From: | Dan Langille <dan(at)langille(dot)org> |
|---|---|
| To: | Shridhar Daithankar <shridhar_daithankar(at)persistent(dot)co(dot)in> |
| Cc: | pgsql-general(at)postgresql(dot)org |
| Subject: | Re: dropping template1 |
| Date: | 2003-01-09 12:05:18 |
| Message-ID: | 20030109065924.P52073-100000@m20.unixathome.org |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
On Thu, 9 Jan 2003, Shridhar Daithankar wrote:
> On 9 Jan 2003 at 1:40, Thomas T. Thai wrote:
>
> > > On 9 Jan 2003 at 1:14, Thomas T. Thai wrote:
> > >
> > >> I'm using 7.3 and accidently created unnecessary functions and such in
> > >> template1. Originally it had nothing added beyond the initial install
> > >> (initdb). I would like to return it to the clean state.
> > >
> > > How about drop function?
> >
> > there are lots of functions and datatypes etc. is there an easier way?
>
> I meant just drop the functions you created.
>
> 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?
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Shridhar Daithankar | 2003-01-09 12:28:35 | Re: dropping template1 |
| Previous Message | Manfred Koizar | 2003-01-09 08:52:35 | Re: How can I do this? |