Re: Execute commands in single-user mode

På søndag 10. januar 2016 kl. 15:52:12, skrev Melvin Davidson <
melvin6925(at)gmail(dot)com <mailto:melvin6925(at)gmail(dot)com>>:
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

 
How can that work?
 
Starting in single-mode gives you a prompt, so there's no way to issue another
command. Even if it was, PG is not accepting connections, so using psql won't
work, unless I'm misstaken...
 
BTW, it's always good form to state the exact O/S and version of PostgreSQL,
regardless of whether you think it may apply.
 

Yea, sorry, it's 9.5.0
 
-- Andreas Joseph Krogh
CTO / Partner - Visena AS
Mobile: +47 909 56 963
andreas(at)visena(dot)com <mailto:andreas(at)visena(dot)com>
www.visena.com <https://www.visena.com>
<https://www.visena.com>