PostgreSQL

Why PostgreSQL?¶

Pros	Cons
✅ Excellent performance at scale	❌ More complex setup
✅ Advanced JSON support	❌ Requires more resources
✅ Great for complex queries	❌ Less common in Minecraft hosting
✅ Robust data integrity

Recommended for: Enterprise deployments, database experts

Requirements¶

PostgreSQL 13.0 or newer

Step 1: Create Database¶

Connect to PostgreSQL and run:

CREATE DATABASE uxmclaims;
CREATE USER uxmclaims WITH ENCRYPTED PASSWORD 'your_secure_password';
GRANT ALL PRIVILEGES ON DATABASE uxmclaims TO uxmclaims;

Also grant schema permissions:

\c uxmclaims
GRANT ALL ON SCHEMA public TO uxmclaims;

Step 2: Configure Plugin¶

In config.yml:

database:
  type: 'AUTO'
  username: 'uxmclaims'
  password: 'your_secure_password'
  url: 'jdbc:postgresql://localhost:5432/uxmclaims'

URL Format¶

jdbc:postgresql://HOST:PORT/DATABASE

Part	Default	Example
HOST	localhost	192.168.1.100
PORT	5432	5432
DATABASE	uxmclaims	uxmclaims

Step 3: Restart Server¶

Restart your Minecraft server. Check the console for:

[uxmClaims] Connected to PostgreSQL database
[uxmClaims] Migrations applied successfully

Connection Options¶

url: 'jdbc:postgresql://localhost:5432/uxmclaims?ssl=false'

Common options:

ssl=false - Disable SSL for local connections
sslmode=require - Require SSL for remote connections

Troubleshooting¶

"Password authentication failed"¶

Check username and password
Verify pg_hba.conf allows your connection method

"Connection refused"¶

Is PostgreSQL running?
Check port 5432
Verify postgresql.conf allows network connections

"Permission denied"¶

Run the GRANT commands from Step 1
Make sure user has schema permissions

Backing Up¶

pg_dump -U uxmclaims uxmclaims > backup.sql

Restore:

psql -U uxmclaims uxmclaims < backup.sql

Which Database Should You Use?¶

Server Size	Recommendation
Small (<50 players)	SQLite
Medium (50-200 players)	MySQL or SQLite
Large (200+ players)	MySQL or PostgreSQL
Network (multiple servers)	MySQL or PostgreSQL