> Full Neon documentation index: https://neon.com/docs/llms.txt

# How do I check which PostgreSQL version my Neon database is running?

Run SELECT version() in SQL, check the Project Dashboard, or use the Neon CLI.

Every Neon project is tied to a specific Postgres major version that you picked at project creation. To check which one you're on, run `SELECT version();` from any SQL client, or read it from the **Settings** widget on the **Project Dashboard** in the [Neon Console](https://console.neon.tech). The CLI command `neon projects get` shows the same value. Neon supports Postgres 14, 15, 16, 17, and 18. See [Upgrading your Postgres version](https://neon.com/docs/postgresql/postgres-upgrade) for details.

## Three ways to check

**SQL**

Run this from the [Neon SQL Editor](https://neon.com/docs/get-started/query-with-neon-sql-editor), psql, or any Postgres client:

```sql
SELECT version();
```

You'll get a string like:

```text
PostgreSQL 17.2 on x86_64-pc-linux-gnu, compiled by gcc ...
```

The first number is the major version. The second is the minor version, which Neon upgrades automatically.

**Console**

1. Sign in to the [Neon Console](https://console.neon.tech) and select your project.
2. On the **Project Dashboard**, find the **Settings** widget.
3. The Postgres version is listed there alongside region and creation date.

**CLI**

With [neonctl](https://neon.com/docs/cli) installed and authenticated:

```bash
neon projects get <project_id>
```

The output includes a `pg_version` field with the major version your project is running.

## Major vs minor versions

Neon manages **minor** version upgrades for you under the [Postgres version support policy](https://neon.com/docs/postgresql/postgres-version-policy). Minor versions are deployed soon after release and typically don't require any action on your part.

**Major** versions (16 to 17, 17 to 18, and so on) are not upgraded automatically because they can introduce incompatibilities. You upgrade by creating a new Neon project with the target major version and migrating your data with the [Import Data Assistant](https://neon.com/docs/import/import-data-assistant), `pg_dump` / `pg_restore`, or [logical replication](https://neon.com/docs/guides/logical-replication-neon-to-neon).

**Warning: Major versions cannot be downgraded**

Once a Neon project is created with a given major version, you cannot move it backward. You also can't change the major version on an existing project. To run a different major version, create a new project and migrate. Pick carefully if you have strict compatibility requirements.

> **Plan an upgrade to a newer Postgres version**
>
> Walk through creating a new project, migrating data, and cutting traffic over to the new version.
>
> [Upgrade guide](https://neon.com/docs/postgresql/postgres-upgrade)