> ## Content Index
> Fetch the complete content index at: https://ostreff.info/llms.txt
> Use this file to discover other available public pages before exploring further.

# Upgrade to PostgreSQL 17.0
- URL: https://ostreff.info/upgrade-to-17-0/
- Published: 2024-09-28T11:27:00.000Z
- Updated: 2025-10-06T20:35:41.000Z
- Author: Jordan Ostreff
- Tags: PostgreSQL, FreeBSD

The [postgresql 17](https://www.postgresql.org/about/news/postgresql-17-released-2936/?ref=ostreff.info) was released 2 days ago. So here is quick manual to upgrade to latest version from 16.4.

```bash
pkg create postgresql16-server 
mkdir /tmp/pg-upgrade
tar xf postgresql16-server-16.4.pkg -C /tmp/pg-upgrade
pkg delete -f databases/postgresql16-server  databases/postgresql16-client
portmaster databases/postgresql17-server databases/postgresql17-client

su -l postgres -c "/usr/local/bin/initdb --encoding=utf-8 --lc-collate=C -D /var/db/postgres/data17 -U postgres"
su -l postgres -c "pg_upgrade -b /tmp/pg-upgrade/usr/local/bin/ -d /var/db/postgres/data16/ -B /usr/local/bin/ -D /var/db/postgres/data17/ -U postgres"
service postgresql start
/usr/local/bin/vacuumdb -U postgres --all --analyze-in-stages
/var/db/postgres/delete_old_cluster.sh
```

Don't forget to check and rebuild all ports with dependency to `postgresql-client` 

Full manual for general upgrades comes from [here](https://ostreff.info/upgrade-postgresql-on-freebsd/).