> For the complete documentation index, see [llms.txt](https://docs.tessell.com/tessell/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://docs.tessell.com/tessell/database-engines/tessell-for-postgresql/db-services/readme-postgresql/homepage-postgresql.md).

# Database Service home page

The database service home page is the central control plane for a single PostgreSQL database service. It displays the service status, provides quick-access action buttons, and organises management capabilities across tabs: Overview, Monitoring, Logs, Instances, Maintenance Window, Databases, Integrations, Events, Schedules, Sharing, and Settings.

<div align="center"><img src="https://3421475909-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FXNKiIctERJykfezXfUU2%2Fuploads%2Fgit-blob-fa6f374d2a194efa216c0b0e7b2d95f8d1cbe1c8%2Fhomepage-top.png?alt=media" alt=""></div>

***

## What status indicators appear next to the service name?

| Indicator                      | When it appears                                     | What to do                                                                                                                                      |
| ------------------------------ | --------------------------------------------------- | ----------------------------------------------------------------------------------------------------------------------------------------------- |
| **Snapshot icon**              | A manual or automatic snapshot is in progress       | Click the icon to see snapshot details                                                                                                          |
| **Patch Available**            | A higher patch version is available from Tessell    | Click to start patching — see [Patching](/tessell/database-engines/tessell-for-postgresql/db-services/readme-postgresql/patching-postgresql.md) |
| **Parameter Update available** | A new version of the parameter profile is available | Hover to see which profiles are available; use [Change Parameter Profile](#how-do-i-change-the-parameter-profile) to apply                      |
| **Upcoming schedules**         | A start, stop, or delete schedule is approaching    | Hover to view the scheduled action and timing                                                                                                   |

***

## What details does the More Info panel show?

Click the **More Info** icon (ⓘ) to see a full summary of the service, grouped into categories:

**Cloud details**

| Field                | Description                                          |
| -------------------- | ---------------------------------------------------- |
| Cloud                | Cloud provider                                       |
| Region               | Cloud region                                         |
| Availability Zone(s) | AZ(s) used                                           |
| Subscription         | The Tessell subscription associated with the service |
| VPC or VNet          | Virtual network the service is attached to           |
| Private subnet       | Private subnet the service is attached to            |

**Storage details**

| Field            | Description                          |
| ---------------- | ------------------------------------ |
| Storage Provider | Storage type for your cloud provider |
| Volume Size      | Storage size in GiB                  |
| Max throughput   | Maximum throughput in MiB/s          |
| IOPS             | Provisioned IOPS value               |

**Primary Server and Compute**

| Field         | Description                                                |
| ------------- | ---------------------------------------------------------- |
| Server name   | Server where your database is deployed                     |
| Compute shape | Selected compute shape (click the tooltip for shape specs) |
| vCPUs         | Number of vCPUs allocated                                  |
| Memory        | Amount of memory allocated                                 |

**Software details**

| Field             | Description                                                     |
| ----------------- | --------------------------------------------------------------- |
| Software version  | Database engine version                                         |
| Parameter Profile | Parameter profile name (click tooltip for all parameter values) |
| Option Profile    | Option profile name (click tooltip for all option values)       |
| Edition           | Database engine edition                                         |

**Owner**

| Field         | Description                                                                 |
| ------------- | --------------------------------------------------------------------------- |
| Owner         | Username of the service owner                                               |
| My Role       | Your role: Owner, Co-owner, or Read-only                                    |
| Date created  | Date and time the service was created                                       |
| Running since | Date and time the database has been continuously running                    |
| TRN           | Tessell Resource Name — a globally unique ID for use with Tessell REST APIs |

**Observability**

| Field        | Description                                        |
| ------------ | -------------------------------------------------- |
| Alert policy | The alert policy selected for the database service |

***

## What actions are available from the top-right buttons?

| Button                   | Action                                                                                                                                                                    |
| ------------------------ | ------------------------------------------------------------------------------------------------------------------------------------------------------------------------- |
| **Availability Machine** | Opens the Availability Machine home page for this service. See [Availability Machine](/tessell/database-engines/tessell-for-postgresql/db-services/am-postgresql-doc.md). |
| **Dataflix**             | Opens the Dataflix home page for this service. See [Dataflix](/tessell/database-engines/tessell-for-postgresql/db-services/dataflix-postgresql-doc.md).                   |
| **Start Service**        | Starts the service (visible only when the service is stopped).                                                                                                            |
| **Stop Service**         | Stops the service (visible only when the service is running).                                                                                                             |

***

## What is the Refresh Data feature and when should I use it?

Refresh Data is available only on cloned services. It updates the clone with the most recent snapshot from the source, without creating a new clone, maintaining data consistency. It can be triggered manually or automatically.

Key capabilities:

* Refresh from **snapshot** or **PITR** (Point-in-Time Recovery).
* Supports **pre- and post-scripts** to automate validation and configuration tasks after refresh.
* Supports **cross-region refresh** when a DAP policy is configured in the [Availability Machines app](/tessell/database-engines/tessell-for-postgresql/db-services/am-postgresql-doc.md).
* A single source can have multiple clones; refresh flows only from source → clone. Refresh between clones is not supported.

### Steps to refresh a cloned service

1. Click **Refresh Data** on the service home page.
2. Select the recovery date from the **Recovery Date** box.

   > The calendar shows only dates that have data available based on the source instance's RPO policy.
3. Select the recovery mode in the **Recovery Mode** panel:
   * **Available Snapshots** — choose a specific snapshot for the selected date.
   * **PITR** — use the clock to select an exact recovery time.
4. (Optional) In the **Custom Scripts** panel, select pre and post scripts from the dropdowns.

   > Scripts must be uploaded to the [Script Library](/tessell/database-engines/tessell-for-postgresql/db-services/script-library-postgresql.md) under **DB Services** before they appear here.
5. Click **Submit**.

***

## How do I restore a database service?

Tessell supports **out-of-place restore** — restoring the database to the selected recovery point in a new VM of the same shape as the source. Most configurations are kept unchanged in the restore operation.

### Restore from a snapshot

1. Click the ellipsis icon (︙) → **Restore** → select **Snapshot** → **Next**.
2. In the Dataflix application, browse available snapshots with their timestamps, storage sizes, and number of regions, and select one.
3. Review the snapshot details.
4. Click **Select to Restore**.
5. Choose your database, compute shape (new or existing server), master username, and password.
6. Click **Restore**. Tessell automatically:
   * Submits the restore request
   * Creates compute instance(s)
   * Configures the database
   * Sets up the Availability Machine
   * Triggers the first snapshot

### Restore using PITR

1. Click the ellipsis icon (︙) → **Restore** → select **PITR** → **Next**.
2. In the Dataflix application, pick an exact time on the Regions and Availability Zones view.
3. Click **Select to Restore**.
4. Specify master username and password.
5. Click **Restore**. The same automatic steps as snapshot restore are performed.

### Restore to Maximum Recoverability

Select this option to restore to the last committed transaction. Tessell uses WAL (Write-Ahead Log) files from the source VM if they are available and accessible.

***

## How do I edit or delete the service from the home page?

Click the ellipsis icon (︙) for these additional actions:

| Action           | Description                                                                                                                                                                                                                                                                              |
| ---------------- | ---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- |
| **Edit Service** | Rename the service, update the description, enable delete/stop protection, or enable auto minor version update. See [Edit the service](/tessell/database-engines/tessell-for-postgresql/db-services/readme-postgresql/managing-services-postgresql.md#how-do-i-edit-a-database-service). |
| **Delete**       | Delete the service. See [Delete the service](/tessell/database-engines/tessell-for-postgresql/db-services/readme-postgresql/managing-services-postgresql.md#how-do-i-delete-a-database-service).                                                                                         |

***

## How do I resize compute or storage?

| Resize type        | Downtime impact                                                             | Notes                                                                                         |
| ------------------ | --------------------------------------------------------------------------- | --------------------------------------------------------------------------------------------- |
| **Compute resize** | Downtime required; HA services use a rollover approach to minimise downtime | Ensure the new compute shape is available in the target cloud region and zone before resizing |
| **Storage resize** | No downtime                                                                 | Storage can only be increased; shrinking is not supported                                     |

> **Note:** Tessell highly recommends taking a snapshot before resizing.

### Steps to resize compute

1. Click the ellipsis icon (︙) → **Resize** → **Resize compute** tab.
2. For multi-instance services, select which instances to modify under **MODIFY COMPUTE** (primary and HA are always modified together and cannot be deselected individually). By default, all instances are selected.
3. Choose the number of vCPUs from the **No. of vCPUs** dropdown — the **Select compute shape** dropdown updates to show shapes available for that vCPU count.
4. Choose a compute shape from the **Select compute shape** dropdown.
5. Optionally change the parameter profile in the same dialog.
6. Select the **I understand the consequences, resize the compute** checkbox and click **Save**.
7. Tessell automatically stops the database, applies the new settings, and restarts it.

### Steps to resize storage

1. Click the ellipsis icon (︙) → **Resize** → **Resize storage** tab.
2. Specify the new total **Storage**, **IOPS**, and **Throughput** values under **MODIFY STORAGE**.

   > The value you enter is the total storage you need (existing storage plus any additional amount), not just the additional amount.
3. For multi-instance services, specify IOPS and Throughput per instance (storage resize applies to all instances and cannot be modified per individual instance).
4. Select the **I understand the consequences, resize the storage** checkbox and click **Save**.
5. Tessell applies the new settings non-disruptively.

***

## How do I change the parameter profile?

You can apply a new parameter profile to the service, or apply pending changes from the existing profile.

Use the timing option that matches your urgency:

| Timing option                   | Behaviour                                                                                                |
| ------------------------------- | -------------------------------------------------------------------------------------------------------- |
| **Apply in maintenance window** | Changes are applied in the next scheduled maintenance window                                             |
| **Apply later**                 | Creates a one-time custom maintenance window at your chosen time                                         |
| **Apply immediately**           | Applies all pending changes right now, regardless of the maintenance window. May cause service downtime. |

> **Note:** Tessell highly recommends taking a snapshot before changing the parameter profile.

### Steps to change the parameter profile

1. Click the ellipsis icon (︙) → **Change Parameter Profile**.
2. Choose a new parameter profile from the dropdown.
3. Select a timing option.
4. Select the **I understand the consequences, apply changes immediately** checkbox.
5. Click **Apply**.

***

## How do I use the Code button for programmatic access?

The **Code** button is available for Restore, Resize, Refresh Data, and Change Parameter Profile. It generates ready-to-run code in: **Shell, Python, Go, Java, JavaScript,** and **PowerShell**.

1. Click **Code** in the wizard dialog.
2. On the left, view the API, its type, and the payload.
3. On the right, view the generated code and copy or download it using the buttons provided.
4. Click **Close** to return to the main window.

***

## What tabs are available on the database service home page?

The following tabs provide detailed management capabilities:

| Tab                                                                                                                                                | Purpose                                                                 |
| -------------------------------------------------------------------------------------------------------------------------------------------------- | ----------------------------------------------------------------------- |
| [Overview](/tessell/database-engines/tessell-for-postgresql/db-services/readme-postgresql/homepage-postgresql/overview-postgresql.md)              | Connection details, connection pooling, SSL, private links, allowed IPs |
| [Monitoring](/tessell/database-engines/tessell-for-postgresql/db-services/readme-postgresql/homepage-postgresql/monitoring-postgresql.md)          | OS metrics, DB metrics, Performance Insights                            |
| [Logs](/tessell/database-engines/tessell-for-postgresql/db-services/readme-postgresql/homepage-postgresql/logs-postgresql.md)                      | PostgreSQL DB logs                                                      |
| [Instances](/tessell/database-engines/tessell-for-postgresql/db-services/readme-postgresql/homepage-postgresql/instances-postgresql.md)            | Instance topology, switchover, DR drills, add replica                   |
| [Maintenance Window](/tessell/database-engines/tessell-for-postgresql/db-services/readme-postgresql/homepage-postgresql/maintenance-postgresql.md) | Schedule and view maintenance activities                                |
| [Databases](/tessell/database-engines/tessell-for-postgresql/db-services/readme-postgresql/homepage-postgresql/databases-postgresql.md)            | Create and delete databases within the service                          |
| [Integrations](/tessell/database-engines/tessell-for-postgresql/db-services/readme-postgresql/homepage-postgresql/integrations-postgresql.md)      | Datadog, New Relic integrations                                         |
| [Events](/tessell/database-engines/tessell-for-postgresql/db-services/readme-postgresql/homepage-postgresql/events-postgresql.md)                  | Full audit log of service actions                                       |
| [Schedules](/tessell/database-engines/tessell-for-postgresql/db-services/readme-postgresql/homepage-postgresql/schedules-postgresql.md)            | Start/stop/delete schedules                                             |
| [Sharing](/tessell/database-engines/tessell-for-postgresql/db-services/readme-postgresql/homepage-postgresql/sharing-postgresql.md)                | Share the service with other users                                      |
| [Settings](/tessell/database-engines/tessell-for-postgresql/db-services/readme-postgresql/homepage-postgresql/settings-postgresql.md)              | Timezone, maintenance window, performance insights, observability       |

<div align="center"><img src="https://3421475909-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FXNKiIctERJykfezXfUU2%2Fuploads%2Fgit-blob-4da42ce19a473b05c594340f1e33bad255259b5f%2Fhomepage.png?alt=media" alt=""></div>

<p align="center"><em>Figure 1 — Database Service home page</em></p>


---

# Agent Instructions
This documentation is published with GitBook. GitBook is the documentation platform designed so that both humans and AI agents can read, navigate, and reason over technical content effectively. Learn more at gitbook.com.

## Querying This Documentation
If you need additional information that is not directly available in this page, you can query the documentation by asking a question.

Perform an HTTP GET request on the following URL with the `ask` and `goal` query parameters:

```
GET https://docs.tessell.com/tessell/database-engines/tessell-for-postgresql/db-services/readme-postgresql/homepage-postgresql.md?ask=<question>&goal=<user_goal>
```

`ask` is the immediate question: it should be specific, self-contained, and written in natural language.
`goal` is what the user is ultimately trying to achieve, the reason they need the answer. Sharing it helps GitBook give you a better, more relevant answer. A goal is most helpful when it describes the outcome the user wants rather than restating the question. For example, with `ask=how do I create an API token`, a goal like `automate deployments from our CI pipeline` lets GitBook tailor the answer to that use case.

The response will contain a direct answer to the question and relevant excerpts and sources from the documentation.

Use this mechanism when the answer is not explicitly present in the current page, you need clarification or additional context, or you want to retrieve related documentation sections.