NAME

gerrit gsql - Administrative interface to active database

SYNOPSIS

ssh -p <port> <host> gerrit gsql

DESCRIPTION

Provides interactive query support directly against the underlying SQL database used by the host Gerrit server. All SQL statements are supported, including SELECT, UPDATE, INSERT, DELETE and ALTER.

ACCESS

Caller must be a member of the privileged Administrators group.

SCRIPTING

Intended for interactive use only.

EXAMPLES

To manually correct a user's SSH user name:

$ ssh -p 29418 review.example.com gerrit gsql
Welcome to Gerrit Code Review v2.0.25
(PostgreSQL 8.3.8)
Type '\h' for help.  Type '\r' to clear the buffer.
gerrit> update accounts set ssh_user_name = 'alice' where account_id=1;
UPDATE 1; 1 ms
gerrit> \q
Bye
$ ssh -p 29418 review.example.com gerrit flush-caches --cache sshkeys --cache accounts

Part of Gerrit Code Review