Re: Execute commands in single-user mode

Well, you can't combine psql with the postgres startup, but you can issue
subsequent commands from bash with the -c option:

EG:

postgres --single -O -D $PGDATA $DB_NAME
# give postgres a few seconds to complete startup
sleep 30
psql -U postgres -d your_database -c "alter table pg_largeobject set
tablespace some_tablespace;"

pg_ctl stop -d $PGDATA -m fast

BTW, it's always good form to state the exact O/S and version of
PostgreSQL, regardless of whether you think it may apply.

On Sun, Jan 10, 2016 at 8:53 AM, Andreas Joseph Krogh <andreas(at)visena(dot)com>
wrote:

> Hi all.
>
> 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;
>
> Is it possible to issue the above ALTER-statement from the command-line so
> I can start PG in single-user mode AND execute the ALTER-statement from the
> command-line i a bash-loop?
>
> Thanks.
>
> --
> *Andreas Joseph Krogh*
> CTO / Partner - Visena AS
> Mobile: +47 909 56 963
> andreas(at)visena(dot)com
> www.visena.com
> <https://www.visena.com>
>

--
*Melvin Davidson*
I reserve the right to fantasize. Whether or not you
wish to share my fantasy is entirely up to you.