Re: moving system catalogs to another tablespace - Mailing list pgsql-hackers

From Tom Lane
Subject Re: moving system catalogs to another tablespace
Date
Msg-id 6885.1254785055@sss.pgh.pa.us
Whole thread Raw
In response to moving system catalogs to another tablespace  (Jaime Casanova <jcasanov@systemguards.com.ec>)
Responses Re: moving system catalogs to another tablespace
List pgsql-hackers
Jaime Casanova <jcasanov@systemguards.com.ec> writes:
> it seems like we can't do this. At least a get this error:

> db=# alter table pg_largeobject set tablespace otro;
> ERROR:  permission denied: "pg_largeobject" is a system catalog

You can move *all* of the system catalogs with ALTER DATABASE SET
TABLESPACE.  pg_largeobject might be a special case, but in general
I would think there's no use-case for moving individual catalogs.
        regards, tom lane


pgsql-hackers by date:

Previous
From: Jaime Casanova
Date:
Subject: moving system catalogs to another tablespace
Next
From: Brendan Jurd
Date:
Subject: Re: [PATCH] DefaultACLs