How to start PostgreSQL Server in single user mode

Why single user mode?

Any current connections to the database are dropped without warning
One and only one connection is then allowed into that database
The CHECKPOINT process is not started

How to start PostgreSQL Server in single user mode?

Run the below query from command line.

sudo -u postgres postgres --single -D /var/db/postgresql/

or

postgres --single -D /opt/msp/pkg/postgres/data/ postgres

To come out from single user mode, quit using \q command and login again.

Related Posts

CheapSexCams
Responses are currently closed, but you can trackback from your own site.

Comments are closed.

Powered by k2schools
%d bloggers like this: