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 <andr...@visena.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 > andr...@visena.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.
