Re: Execute commands in single-user mode - Mailing list pgsql-general

Andreas Joseph Krogh <andreas@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?

            regards, tom lane