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
Views: Raw Message | Whole Thread | Download mbox | Resend email
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

Browse pgsql-hackers by date

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