Repository navigation
Local dev: PostgreSQL not reachable on localhost:5433, so the first tenant admin can't be created (priority, 27 Oct) #116
Description
Priority: to be looked at on 27 Oct 2026. Raised by the product owner on 26 Oct.
What happened
On the dev machine, at main 9c8bc9b, this command:
cd "C:\Users\User\OneDrive\Desktop\Migration using ai\PostgreDataMigrationAppWithCSVLoader"
python scripts\create_tenant_admin.py --tenant dev --name "Dev tenant" --username adminfailed with:
Postgres not reachable (attempt 1/30): connection to server at "localhost" (::1), port 5433 failed: Connection refused (0x0000274D/10061).
Nothing was created. The script stops before writing anything.
Why it matters
Since #96 / #115, the frontend requires sign-in. Until a tenant admin exists locally, the app can't be used on the dev machine.
Steps to work through
- Find the PostgreSQL service and its state:
cd "C:\Users\User\OneDrive\Desktop\Migration using ai\PostgreDataMigrationAppWithCSVLoader" Get-Service *postgres* | Format-Table Name, Status, DisplayName -AutoSize $env:PGPORT
- If it's stopped, start it from an Administrator PowerShell with
Start-Service <name>. - If it's running, check its port against
PGPORT. PostgreSQL 18 usually uses 5433; older versions use 5432. - Rerun
create_tenant_admin.py. Success printsCreated tenant 'dev' (schema tenant_dev) with tenant admin 'admin'. - Sign in to the frontend with tenant
dev, usernameadminand the chosen password.
Done when
Steps 4 and 5 both succeed, and that output is attached here (closure rule: clean evidence before closing).
Generated by Claude Code
Activity
amar-python commentedon Oct 26, 2026
Evidence for #116 - local PostgreSQL and first sign-in
Date: 2026-10-27 02:01 +11:00
Repo: main at 9c8bc9b Merge pull request #115 from amar-python/feat/m2e-frontend-sign-in
PostgreSQL service: postgresql-x64-18 Running
Connection: postgres@localhost:5433/te_mgmt_dev
Connection test: select 1 -> 1
Tenant admin: Created tenant 'dev' (schema tenant_dev) with tenant admin 'admin'.
API health: {"status":"ok","database":"te_mgmt_dev","host":"localhost:5433","postgres":"PostgreSQL 18.3","uploads_schema":"csv_uploads"}
Browser check: You landed on 'Sign in to CSV Migrator' (not the upload page) - PASS
Browser check: Signing in with tenant 'dev', user 'admin' and your new password worked - PASS
Browser check: The top right shows 'admin · dev' - PASS
Browser check: Uploading a small CSV worked and it appears under 'Migrated files' - PASS
Browser check: The sign-out icon took you back to the sign-in page - PASS
Screenshots: attached separately on the issue.
amar-python commentedon Oct 26, 2026
Evidence for #116: local PostgreSQL and first sign-in (2026-10-27 02:20 +11:00)
Cause: Windows service postgresql-x64-18 was Stopped. The wizard (scripts\wizard-local-signin.ps1) started it; port 5433.
Repo: main at 9c8bc9b Merge pull request #115 from amar-python/feat/m2e-frontend-sign-in
First sign-in: tenant 'dev', user 'admin', created with scripts\create_tenant_admin.py.
Browser run against the local API (API log, all 200 OK):
POST /api/auth/login 200 OK (signed in; header showed 'admin · dev')
GET /api/csv/files 200 OK
POST /api/csv/preview 200 OK
POST /api/csv/upload 200 OK (smoke-116.csv: imported 2 of 2 rows)
POST /api/auth/logout 200 OK (back to the sign-in page)
Found along the way (to be logged separately):
Screenshots: attached below.
amar-python commentedon Oct 26, 2026
amar-python commentedon Oct 26, 2026
Screenshots for the evidence in the two comments above.
1. Signed in on the upload page (
admin · main)2. smoke-116.csv imported, 2 of 2 rows
3. API log window, all requests 200 OK