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

From Euler Taveira de Oliveira
Subject Re: moving system catalogs to another tablespace
Date
Msg-id 4ACA8C1E.9060408@timbira.com
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 escreveu:
> 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
> 
> but pg_largeobject seems sensible to move to another table space for
> space considerations, no? are there any reasons for this?
> i guess i still could this with symlinks, no?
> 
This was discussed some time ago [1]. A possible solution was proposed in [2]
(it's in pt-br but you can check the commands to accomplish your goal).

[1] http://archives.postgresql.org/pgsql-hackers/2004-06/msg00835.php
[2] http://listas.postgresql.org.br/pipermail/pgbr-geral/2009-March/014374.html

--  Euler Taveira de Oliveira http://www.timbira.com/


pgsql-hackers by date:

Previous
From: Brendan Jurd
Date:
Subject: Re: [PATCH] DefaultACLs
Next
From: Robert Haas
Date:
Subject: Re: dblink memory leak