Re: Execute commands in single-user mode
På søndag 10. januar 2016 kl. 15:52:12, skrev Melvin Davidson <melvin6925@gmail.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 startupsleep 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
Вложения
В списке pgsql-general по дате отправления: