Skip site navigation (1) Skip section navigation (2)

Re: Big problem

From: Gaetano Mendola <mendola(at)bigfoot(dot)com>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Subject: Re: Big problem
Date: 2004-05-24 18:37:11
Message-ID: 40B240D7.2070205@bigfoot.com (view raw or flat)
Thread:
Lists: pgsql-hackers
Tom Lane wrote:

> Christopher Kings-Lynne <chriskl(at)familyhealth(dot)com(dot)au> writes:
> 
>>Hmmm - I agree it's difficult, but somehow I think it's something we 
>>should do.  Just imagine if some major user of postgres did it - they'd 
>>be screaming blue murder...
> 
> 
> Shrug.  Superusers can *always* shoot themselves in the foot in Postgres.
> Try "delete from pg_proc", for instance.  This sounds right up there
> with the notion of preventing a Unix superuser from doing "rm -rf /".

Why not simply add a flag "undeleteable" applicable only to super user?
In this way is enough in the initdb fase create the postgres user as
undeleateable.

I think this is resonable.


Regards
Gaetano Mendola



In response to

pgsql-hackers by date

Next:From: Gaetano MendolaDate: 2004-05-24 18:40:52
Subject: Re: Optimizer bug??
Previous:From: Alvaro HerreraDate: 2004-05-24 18:23:31
Subject: Re: Optimizer bug??

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group