# PostgreSQL Services

> PostgreSQL architecture, deployment, migration, performance engineering and support from PGSTY PTE. LTD., Singapore.

LLMS index: [llms.txt](/llms.txt)

## Services and typical deliverables

### Architecture & deployment

Plan and implement production PostgreSQL environments with Pigsty, matched to your workload.

Typical deliverables: Architecture review, deployment configuration, backup and monitoring setup, and handover.

### Database migration

Assess migration paths from cloud databases, verifying compatibility and controlled cutover.

Typical deliverables: Compatibility report, migration plan, rehearsal results, validation, and rollback runbooks.

### Performance & tuning

Resolve slow queries, lock contention, and recurring incidents using database diagnostics.

Typical deliverables: Diagnostic report, prioritized recommendations, parameter adjustments, and validation.

### Support & subscriptions

Arrange ongoing technical assistance and SLA response for production PostgreSQL environments.

Typical deliverables: Documented support scope, direct contact channels, regular health checks, and issue logs.

### Incident assistance

Provide emergency incident rescue, disaster recovery planning, and restore exercises.

Typical deliverables: Initial assessment, agreed response plan, incident activity log, and post-mortem review.

### Training & engineering

Equip your engineering team with operational expertise and custom automation tooling.

Typical deliverables: Training materials, standard operating procedures, automation scripts, and handover.

## How we work

1. **Discuss requirements** — Outline your environment, goals, and timeline to evaluate the right service fit.
2. **Agree on scope** — Review a written proposal detailing scope, deliverables, fees, and acceptance.
3. **Deliver and validate** — Execute the plan with coordinated access, change windows, and thorough testing.
4. **Handover and support** — Inspect deliverables, receive operational documentation, and arrange support.

[View plans and pricing](/price/)

---

## Scope you can review before committing

Services are delivered as consulting and software engineering engagements. The written quotation or service agreement specifies the contracting entity, currency, fees, billing milestones, deliverables and any support commitments. An enquiry does not create an order or a service-level commitment.

Your team retains responsibility for its infrastructure and business decisions. Access to systems, production changes, backup requirements and handling of confidential material are agreed for each engagement. Please do not send credentials or production data with an initial enquiry.

## Open-source software and commercial work

Open-source software can be evaluated from the project documentation. Each project and dependency has its own licence; a service purchase does not replace those terms. Our fees cover the engineering, support and other deliverables agreed for your engagement.