Re: moving system catalogs to another tablespace

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/