# PostgreSQL 15 update

**URL:** <https://meta.discourse.org/t/postgresql-15-update/349515>\
**Category:** Announcements\
**Created:** [January 29, 2025, 7:20am UTC](https://meta.discourse.org/t/postgresql-15-update/349515 "2025-01-29T07:20:00Z")\
**Posts on this page:** 1\
**Showing post:** 135

<div class="post-metadata">

**Author:** ![hellekin](https://sea3.discourse-cdn.com/meta/user_avatar/meta.discourse.org/hellekin/32/51636_2.png) [@hellekin](https://meta.discourse.org/u/hellekin)\
**Post date:** [February 24, 2025, 5:27pm UTC](https://meta.discourse.org/t/postgresql-15-update/349515/135 "2025-02-24T17:27:33Z")

</div>

## Upgrade on ARM (`aarch64`) with non default locale

> [@volas](#):
>
> `tianon/postgres-upgrade:13-to-15`

I just spent some time fixing a faulty upgrade on a single server with two container setup.

1. Its CPU is ARM
2. Discourse was configured with `en_UK.UTF-8` locale

Step by step, I figured that:

1. `tianon/postgres-upgrade:13-to-15` does not work on ARM
2. locale configuration is stored in the `share/${CONTAINER}/postgres_data/postgresql.conf`

I started with commenting out the `env:` part of the data container, to ensure it uses default locales.

So, to get out of the upgrade mess, I took a _dangerous_ step, assuming collation differences between `en_GB` and `en_US` were negligible, and I ruthlessly updated the whole cluster to `en_US`:

```plaintext
UPDATE pg_database SET datctype='en_US.UTF-8', datcollate='en_US.UTF-8';

```

I’m _not sure_ this step is required, YMMV. I leave it here for others more knowledgeable to comment, and I do _not_ recommend it at all for different languages!

Then I replaced the locale in `postgresql.conf`:

```plaintext
sed -i -e 's/en_GB/en_US/g' shared/data/postgres_data/postgresql.conf
sudo -H -u discourse ./launcher rebuild data
...
UPGRADE OF POSTGRES COMPLETE

```

🎉

Do not think it was easy: I’m not mentioning the long path of exploring options, especially as when I intervened, the admin interface was unavailable, and the last backup was made 6 days ago. I _had_ to fiddle around before I could get to a proper – or at least, working – resolution.

I hope this will save some people some time.

---

_[View the full topic](https://meta.discourse.org/t/postgresql-15-update/349515)._