Manage user roles
AlloyDB Omni uses the following roles:
AlloyDB Omni includes a superuser role named
alloydbadmin, and a non-superuser role namedalloydbmetadata.The default
postgresuser has a superuser role.All other predefined user roles have no privileges. They are reserved for potential uses in the future.
Set up an AlloyDB Omni database
We recommend following these steps when setting up an AlloyDB Omni database:
Define or import your databases using the
postgresuser role. In a new installation, this role has superuser privileges.Create new user roles that have the correct level of access to your application's tables, again using the
postgresuser role.Configure your application to connect to the database using these new, limited-access roles.
You can create and define as many new user roles as you need. Don't modify or delete any of the user roles that comes with AlloyDB Omni.
For more information, see Manage AlloyDB Omni users and roles.
Monitor AlloyDB Omni
Monitoring your AlloyDB Omni installation includes fetching and analyzing AlloyDB Omni metrics.
Single-server
By default, to retrieve AlloyDB Omni logs, run:
Docker
docker logs CONTAINER_NAMEReplace CONTAINER_NAME with the name of your AlloyDB Omni container.
To configure the logging behavior of AlloyDB Omni, see Customize your AlloyDB Omni installation.
Podman
podman logs CONTAINER_NAMEReplace CONTAINER_NAME with the name of your AlloyDB Omni container.
To configure the logging behavior of AlloyDB Omni, see Customize your AlloyDB Omni installation.
Uninstall AlloyDB Omni
Single-server
To uninstall AlloyDB Omni, stop and delete the AlloyDB Omni container using the following command:
Docker
docker container stop CONTAINER_NAME
docker container rm CONTAINER_NAMEReplace CONTAINER_NAME with the name of your AlloyDB Omni container.
Podman
podman container stop CONTAINER_NAME
podman container rm CONTAINER_NAMEReplace CONTAINER_NAME with the name of your AlloyDB Omni container.
Podman
podman container stop CONTAINER_NAME
podman container rm CONTAINER_NAMEReplace CONTAINER_NAME with the name of your AlloyDB Omni container.
You can move, archive, or delete an external data directory depending on whether and how you want to preserve your data after uninstalling AlloyDB Omni.