Panel Configuration
Database Setup
Configure and initialize XyraPanel database with PostgreSQL.
XyraPanel uses Drizzle ORM with PostgreSQL as the database backend for both development and production.
Prerequisites
You need a running PostgreSQL instance (v14+) and Redis. Install them on Ubuntu:
sudo apt install -y postgresql redis-server
sudo systemctl enable --now postgresql redis-server
Then create the database and user:
sudo -u postgres psql -c "CREATE USER xyra WITH PASSWORD 'changeme';"
sudo -u postgres psql -c "CREATE DATABASE xyrapanel OWNER xyra;"
PostgreSQL Setup
Configure
Update your .env file with your PostgreSQL connection details:
.env
DATABASE_URL="postgresql://xyra:changeme@localhost:5432/xyrapanel"
Initialize
Run the Drizzle migration to create all tables:
pnpm run db:push