Link to home
Start Free TrialLog in
Avatar of elimesika
elimesikaFlag for Israel

asked on

running database in single-user mode

HI
I am running Postgres on Fedora 14 64 bit using the following command:
> service postresql start

I would like to know how to set database to single-user mode in order to run an upgrade process on database, and return it back to regular mode when upgrade process finish.

Thanks
Avatar of lcohan
lcohan
Flag of Canada image

One way to do this is to shut down the server and start a single-user PostgreSQL server with the -P option included on its command line.
ASKER CERTIFIED SOLUTION
Avatar of lcohan
lcohan
Flag of Canada image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of elimesika

ASKER

Thanks