Admin Interface¶
This section describes how to enable AkasicDB features through the admin interface and manage user accounts.
Enable AkasicDB¶
After starting the PostgreSQL server, connect as a superuser to enable AkasicDB. This process only needs to be performed once per PostgreSQL database.
-- Enable the AkasicDB extension
CREATE EXTENSION IF NOT EXISTS akasicdb;
-- Initialize graph and vector modules of AkasicDB
SELECT akasicdb_admin.initialize();
Manage Regular User Accounts¶
As in PostgreSQL, you can add user accounts in AkasicDB using the CREATE ROLE statement. Newly added user accounts are automatically granted the permissions required to use AkasicDB features.
User account management requires superuser privileges.
-- Create a user account named "user" with the login password user_password
CREATE ROLE "user" WITH LOGIN PASSWORD 'user_password';
You can also delete unused accounts using the DROP ROLE statement.