{
  "$type": "site.standard.document",
  "canonicalUrl": "https://isabelroses.com/blog/nixos-and-postgresql",
  "coverImage": {
    "$type": "blob",
    "ref": {
      "$link": "bafkreiacwojifuueppmt6doedf66qybfse7mhtojppktceul7wbowvijy4"
    },
    "mimeType": "image/png",
    "size": 10565
  },
  "description": "Migrating from PostgreSQL 14 to 15",
  "path": "/blog/nixos-and-postgresql",
  "publishedAt": "2023-11-28T00:00:00.000Z",
  "site": "at://did:plc:qxichs7jsycphrsmbujwqbfb/site.standard.publication/3mn5hmwkcmb22",
  "tags": [
    "nix",
    "postgresql"
  ],
  "textContent": "When upgrading to version 15 from 14, there was an issue. None of my data was\ntransferred. To fix this issue I swapped to the postgres user who is a\nsuperuser on the PostgreSQL databases.\n\nThen to preform the migration I ran:\n\nthen when I had the sqldump file, the following command was run from the command\nline to get use the sqldump file to recover the previous data",
  "title": "NixOS and PostgreSQL"
}