På søndag 10. januar 2016 kl. 16:40:23, skrev Tom Lane <t...@sss.pgh.pa.us <mailto:t...@sss.pgh.pa.us>>: Andreas Joseph Krogh <andr...@visena.com> writes: > I'm planning to move all my pg_largeobject tables to separate tablespaces and > to be able to do that I need to shuddown PG and start in single-user mode, like > this: > postgres --single -O -D $PGDATA $DB_NAME > Then I have to execute the command: > alter table pg_largeobject set tablespace some_tablespace;
Why do you think you need single-user mode for that? Because of this? ERROR: permission denied: "pg_largeobject" is a system catalog -- Andreas Joseph Krogh CTO / Partner - Visena AS Mobile: +47 909 56 963 andr...@visena.com <mailto:andr...@visena.com> www.visena.com <https://www.visena.com> <https://www.visena.com>
