Re: template1 database... - Mailing list pgsql-admin

From Chris M
Subject Re: template1 database...
Date
Msg-id bi85cj$2lid$1@news.hub.org
Whole thread Raw
In response to template1 database...  ("Thomas LeBlanc" <thomasatiem@hotmail.com>)
Responses Re: template1 database...
List pgsql-admin
The link is very good. But another question.
In PostgreSQL, a superuser can modify almost everything in the
databases. But I don't think that should be the default. Maybe
adding an option is better. When a superuser want to change
something owned by the system, he or she can turn the option
on, then do what he want. After that, the option should be turned
back to off.

"Devrim GUNDUZ" <devrim@gunduz.org>
news:Pine.LNX.4.44.0308202243580.10233-100000@emo.org.tr...
>
> Hi,
>
> On Wed, 20 Aug 2003, Thomas LeBlanc wrote:
>
> > We have accidentally added tables and other objects to this database.
> >
> > How do we return template1 back to the default setup?
>
> I think this will help you:
>
> http://techdocs.postgresql.org/techdocs/pgsqladventuresep1.php
> Written by Josh Berkus.
>
> Regards,
> --
> Devrim GUNDUZ
> devrim@gunduz.org devrim.gunduz@linux.org.tr
> http://www.tdmsoft.com
> http://www.gunduz.org
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 2: you can get off all lists at once with the unregister command
>     (send "unregister YourEmailAddressHere" to majordomo@postgresql.org)
>



pgsql-admin by date:

Previous
From: "Vikram D. Gaitonde"
Date:
Subject: Disk Utilization Increases And Time for Vacuum Increases.
Next
From: sharvari N
Date:
Subject: a problem