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

Re: Tablespace permissions issue

From: Fabien COELHO <coelho(at)cri(dot)ensmp(dot)fr>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: Gavin Sherry <swm(at)linuxworld(dot)com(dot)au>,PostgreSQL Developers <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: Tablespace permissions issue
Date: 2004-06-29 13:45:32
Message-ID: Pine.LNX.4.58.0406291535250.24805@sablons.cri.ensmp.fr (view raw or flat)
Thread:
Lists: pgsql-hackers
Dear Tom,

> Fabien COELHO <coelho(at)cri(dot)ensmp(dot)fr> writes:
> > It's more a "fix-me later" approach, but it does not look that bad, IMHO.
>
> It seems a bit risky to me.  The worst possible consequence of the
> ownership stuff not happening is that objects have wrong ownership (and
> even there it's not so much "wrong" as "we decided we'd like this other
> behavior better").

Well, if the ownership-switch transaction would fail, then I think the
login would also fail and the connection would be broken... No data is
lost because none where put in the database, as it has just been created.
But the system would be blocked anyway.

> But the consequence of not fixing reltablespace is that the database is
> broken...

If it is simply broken, that is it does not work at all, as it is a newly
created database hency mostly empty database, it is not that bad as no
data is lost. If it is broken but the fact appears much later on, that's
another issue. My intuition is that a failure of such transactions would
just show that there is a big underlying problem, thus having a early-on
failure would be a rather good thing as it would prevent the user to go
on with an instable installation.

> so I'd prefer not to need to.

I cannot see how it could fail under normal condition (i.e. apart disk
full or hardware/os failure), but you're sure a better juge of that than
me!!

-- 
Fabien Coelho - coelho(at)cri(dot)ensmp(dot)fr

In response to

pgsql-hackers by date

Next:From: Tom LaneDate: 2004-06-29 14:18:54
Subject: Re: INSERT rule
Previous:From: Tom LaneDate: 2004-06-29 13:43:55
Subject: Re: client_min_messages in dumps?

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