I have entered postgres' single-user mode
$ sudo -u postgres postgres --single -D /var/db/postgresql/
PostgreSQL stand-alone backend 9.4.11
backend>
What command can I use to close single-user mode and exit back to a normal $
command prompt?
The command \q
works to exit from the psql
repl, but that same command does not appear to work for postgres single-user mode, i.e.
$ sudo -u postgres postgres --single -D /var/db/postgresql/
PostgreSQL stand-alone backend 9.4.11
backend> \q
ERROR: syntax error at or near "\" at character 1
STATEMENT: \q
backend>
The answer is on the Postgresql Docs page at Single-User mode. Regarding the exit it states:
To quit the session, type EOF (Control+D, usually). If you've entered any text since the last command entry terminator, then EOF will be taken as a command entry terminator, and another EOF will be needed to exit.
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With