Re: Execute commands in single-user mode - Mailing list pgsql-general
På søndag 10. januar 2016 kl. 16:40:23, skrev Tom Lane <tgl@sss.pgh.pa.us>:
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?
Because of this?
ERROR: permission denied: "pg_largeobject" is a system catalog
-- 
Andreas Joseph Krogh
CTO / Partner - Visena AS
Mobile: +47 909 56 963
Attachment
pgsql-general by date: