Single User Mode

[Jbaskin]

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

[JimKnicely]

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:

• SELECT SET_CONFIG_PARAMETER ('MaxClientSessions', 0);

And here is a link to a post that explains how to use the CLOSE_SESSION function:

• viewtopic.php?f=3&t=95&p=135&hilit=close_sessions#p135

I hope this helps!

[DataWhisperer]

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';

[Jbaskin]

Thanks, guys.