Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

[postgresql_server] Could do with some upgrade documentation #2414

Open
Alphix opened this issue Sep 11, 2023 · 0 comments
Open

[postgresql_server] Could do with some upgrade documentation #2414

Alphix opened this issue Sep 11, 2023 · 0 comments

Comments

@Alphix
Copy link
Contributor

Alphix commented Sep 11, 2023

The postgresql_server role could do with some information about how to do an upgrade...e.g. from bullseye (version 13) to bookworm (version 15).

In essence, the steps I had to were (writing this down so I don't forget it):

  1. Do a normal distro upgrade
  2. apt install postgresql-contrib
  3. pg_dropcluster 15 main --stop
  4. pg_upgradecluster 13 main
  5. apt purge postgresql-13 postgresql-client-13
  6. edit /etc/ansible/facts.d/postgres.fact and manually change the version (13 -> 15)
  7. re-run the role on the controller

I'll see if I get around to adding something like this to the docs...

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

1 participant