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