På søndag 10. januar 2016 kl. 15:52:12, skrev Melvin Davidson < [email protected] <mailto:[email protected]>>: 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 [email protected] <mailto:[email protected]> www.visena.com <https://www.visena.com> <https://www.visena.com>
