Re: Execute commands in single-user mode

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Andreas Joseph Krogh <andreas(at)visena(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Execute commands in single-user mode
Date: 2016-01-10 15:40:23
Message-ID: 31006.1452440423@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Andreas Joseph Krogh <andreas(at)visena(dot)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

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Andreas Joseph Krogh 2016-01-10 15:45:29 Re: Execute commands in single-user mode
Previous Message Joshua D. Drake 2016-01-10 15:36:23 Re: Code of Conduct: Is it time?