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

Re: moving system catalogs to another tablespace

From: Jaime Casanova <jaime(at)2ndquadrant(dot)com>
To: scc <scott(at)corscadden(dot)ca>
Cc: pgsql-hackers(at)postgresql(dot)org
Subject: Re: moving system catalogs to another tablespace
Date: 2012-10-01 20:35:57
Message-ID: CAJKUy5iUuWobtW2Bc-TXJg_V+nnfkk3fTVm5ZpLCZd4Cp9XN3Q@mail.gmail.com (view raw or flat)
Thread:
Lists: pgsql-hackers
On Mon, Oct 1, 2012 at 3:08 PM, scc <scott(at)corscadden(dot)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


In response to

Responses

pgsql-hackers by date

Next:From: Selena DeckelmannDate: 2012-10-01 20:37:11
Subject: Re: setting per-database/role parameters checks them against wrong context
Previous:From: sccDate: 2012-10-01 20:08:57
Subject: Re: moving system catalogs to another tablespace

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