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

From Jaime Casanova
Subject Re: moving system catalogs to another tablespace
Date
Msg-id CAJKUy5iUuWobtW2Bc-TXJg_V+nnfkk3fTVm5ZpLCZd4Cp9XN3Q@mail.gmail.com
Whole thread Raw
In response to Re: moving system catalogs to another tablespace  (scc <scott@corscadden.ca>)
Responses Re: moving system catalogs to another tablespace  (scc <scott@corscadden.ca>)
List pgsql-hackers
On Mon, Oct 1, 2012 at 3:08 PM, scc <scott@corscadden.ca> wrote:
> Nothing like replying to a 3 year old post, but I would like to confirm
> whether this is possible.

I haven't tried this in a long time but AFAIR this is possible by
shutting down the server, start in standalone mode with change in
catalogs allowed (postgres --single -O -D /data) and then you can make
the ALTER TABLE to move pg_largeobject to a new tablespace

--
Jaime Casanova         www.2ndQuadrant.com
Professional PostgreSQL: Soporte 24x7 y capacitación
Phone: +593 4 5107566         Cell: +593 987171157



pgsql-hackers by date:

Previous
From: scc
Date:
Subject: Re: moving system catalogs to another tablespace
Next
From: Selena Deckelmann
Date:
Subject: Re: setting per-database/role parameters checks them against wrong context