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 Deckelmann | Date: 2012-10-01 20:37:11 |
| Subject: Re: setting per-database/role parameters checks them
against wrong context |
| Previous: | From: scc | Date: 2012-10-01 20:08:57 |
| Subject: Re: moving system catalogs to another tablespace |