HR & Payroll Trial - PostgreSQL Database Preparation
Project: HRPAY-BMD-20260911-01
Version: v0.39.4-dev Consolidated

Recommended database for this trial: PostgreSQL.
The current HR & Payroll architecture is Django/Python + PostgreSQL. It does NOT use Microsoft SQL Server.

Option A - pgAdmin (easiest for Windows team)
1. Install PostgreSQL and pgAdmin.
2. In pgAdmin create a Login/Group Role: hrpay_uat
3. Give it a strong password and permission to login.
4. Create Database: hrpay_uat
5. Set Owner of database hrpay_uat to hrpay_uat.
6. Note Host (usually 127.0.0.1) and Port (usually 5432).
7. Run 01-SETUP-LOCAL-UAT-WINDOWS.bat and select PostgreSQL.
8. Enter the database name, user, password, host and port.

Option B - psql example (replace the password before running)
  CREATE ROLE hrpay_uat WITH LOGIN PASSWORD 'CHANGE-THIS-STRONG-PASSWORD';
  CREATE DATABASE hrpay_uat OWNER hrpay_uat ENCODING 'UTF8';

Important
- Do not reuse the sample password in a real environment.
- Do not expose PostgreSQL port 5432 to the public internet.
- For Local UAT, keep database access restricted to the local server/private LAN.