Hi, Is there a way to put Vertica into a single user mode so that no one can log on except for admins? If I need to do maintenance I don't want anyone logging in, which now they do...
-baskin
Single User Mode
Moderator: NorbertKrupa
- JimKnicely
- Site Admin
- Posts: 1825
- Joined: Sat Jan 21, 2012 4:58 am
- Contact:
Re: Single User Mode
Hi jbaskin,
You can set the MaxClientSessions parameter to 0 to disable any new connections and close any current sessions with the CLOSE_SESSION function.
Use this statement in vsql to set the MaxClientSessions parameter to 0:
I hope this helps!
You can set the MaxClientSessions parameter to 0 to disable any new connections and close any current sessions with the CLOSE_SESSION function.
Use this statement in vsql to set the MaxClientSessions parameter to 0:
- SELECT SET_CONFIG_PARAMETER ('MaxClientSessions', 0);
I hope this helps!
Jim Knicely
Note: I work for Vertica. My views, opinions, and thoughts expressed here do not represent those of my employer.
Note: I work for Vertica. My views, opinions, and thoughts expressed here do not represent those of my employer.
-
- Newbie
- Posts: 16
- Joined: Fri May 11, 2012 12:25 pm
Re: Single User Mode
Just remember to set to number back to what you had before. Default MaxClientSessions is 50, but if you've changed it:
Code: Select all
SELECT current_value FROM configuration_parameters WHERE parameter_name = 'MaxClientSessions';
Re: Single User Mode
Thanks, guys.