---
title: NixOS and PostgreSQL
description: Migrating from PostgreSQL 14 to 15
date: 2023-11-28
tags:
  - nix
  - postgresql
archived: true
image: nixos-and-postgresql.png
atUri: "at://did:plc:qxichs7jsycphrsmbujwqbfb/site.standard.document/3mn5hpdg7uq22"
---

When upgrading to version 15 from 14, there was an issue. None of my data was
transferred. To fix this issue I swapped to the `postgres` user who is a
superuser on the PostgreSQL databases.

Then to preform the migration I ran:

```sql
-- to do this without swapping user you can use the flag -U
pg_dumpall > sqldump
```

then when I had the sqldump file, the following command was run from the command
line to get use the sqldump file to recover the previous data

```bash
psql -f sqldump
```