På søndag 10. januar 2016 kl. 16:40:23, skrev Tom Lane <[email protected] <mailto:[email protected]>>: Andreas Joseph Krogh <[email protected]> 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 [email protected] <mailto:[email protected]> www.visena.com <https://www.visena.com> <https://www.visena.com>
