force shutdown of the database

[brendon987]

How do I do a force shutdown of the database ?. I.e Just incase I cannot kill the user session

[JimKnicely]

Use the SHUTDOWN function logged in as a superuser...

From the docs:

Issuing the SHUTDOWN('true') command forces the database to shut down whether users are connected or not.

Code: Select all

dbadmin=> SELECT SHUTDOWN('true');
          SHUTDOWN
----------------------------
 Shutdown: moveout complete
(1 row)

But make sure you really want to do that! Passing in true will shut down the database no matter how many users are logged on!

[Josh]

You can also pull the plug on the servers! That will force a database shutdown

[JimKnicely]

Hi,

Another option to stop your database is using the admintools command line option stop_db()...

Example:

Code: Select all

[dbadmin ~]$ /opt/vertica/bin/admintools -t stop_db -d vertica_db
Info: no password specified, using none
Issuing shutdown command to database
Database vertica_db stopped successfully

Note that the database can only be stopped by the user who (as part of the verticadba UNIX user group) initially created the database or who has root or su privileges.

[billykopecki]

Hello,

Is there an option available on the command line admintools utility that will allow me to force a database shutdown even though there are folks logged on?

Code: Select all

bash$ admintools -t stop_db -d salesforce
Info: no password specified, using none
        Issuing shutdown command to database
Database salesforce not stopped successfully
 Error: NOTICE 2519:  Cannot shut down while users are connected

[JimKnicely]

Hi,

I don't think admintools can do it, but you can do this from the command line:

Code: Select all

bash-shell$ vsql -c "SELECT SHUTDOWN('true');"
SET
          SHUTDOWN
----------------------------
 Shutdown: moveout complete
(1 row)

Make sure you really want to do that

[NorbertKrupa]

I was not able to forcefully shut down using admintools:

Code: Select all

$ /opt/vertica/bin/admintools -t stop_db -d dbname
        Issuing shutdown command to database
Database dbname not stopped successfully
 Error: NOTICE 2519:  Cannot shut down while users are connected

You would need the -f option to force the databases to shutdown, even if users are connected (which I didn't know until after I just ran SHUTDOWN() from vsql).

I just used SELECT SHUTDOWN('true');