How to exit from postgres' single-user mode?

Question

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>

@JorgeCampos Unlike psql utility, \q does not appear to work in this case; question edited to show that. — mherzl
– mherzl, Commented Jul 16, 2017 at 0:51

Jorge Campos · Accepted Answer · 2017-07-16 01:07:44Z

7

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.

answered Jul 16, 2017 at 1:07

Jorge Campos

23.8k7 gold badges65 silver badges95 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

How to exit from postgres' single-user mode?

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related