postgresql 10 -> 15

[uRhaineWork]

As of netbox 3.4 requires postgresql to be in minimal version of 11. Probably many users just install netbox with standard options, not knowing default is 10, or was not that long time ago. At least I think it is, because my fresh alma/netbox installl was from march 2022.
Does anyone have a decent tried out on netbox tutorial on how to upgrade sql from 10 to 14 or 15? or 13? I've read that v above 13 need some depositories added.
Version of linux is Alma 8.5.

[mtinberg]

I don't know offhand but I believe the PostgreSQL website has extensive documentation including upgrade procedures, they used to require you to pg_dump and pg_restore the database to migrate between versions (which shouldn't take long, even the largest Netbox databases are pretty small, and it's good to have the backup in case something goes awry) but I think newer versions can upgrade the database files on disk so upgrades are even easier. — Mark Tinberg ***@***.***> Division of Information Technology-Network Services University of Wisconsin-Madison

…

________________________________ From: uRhaineWork ***@***.***> Sent: Tuesday, January 3, 2023 8:34 AM To: netbox-community/netbox ***@***.***> Cc: Subscribed ***@***.***> Subject: [netbox-community/netbox] postgresql 10 -> 15 (Discussion #11369) As of netbox 3.4 requires postgresql to be in minimal version of 11. Probably many users just install netbox with standard options, not knowing default is 10, or was not that long time ago. At least I think it is, because my fresh alma/netbox installl was from march 2022. Does anyone have a decent tried out on netbox tutorial on how to upgrade sql from 10 to 14 or 15? or 13? I've read that v above 13 need some depositories added. Version of linux is Alma 8.5. — Reply to this email directly, view it on GitHub<#11369>, or unsubscribe<https://github.com/notifications/unsubscribe-auth/AAS7UM7EJKATYXTNJV25EXTWQQ2IPANCNFSM6AAAAAATPYCGWQ>. You are receiving this because you are subscribed to this thread.Message ID: ***@***.***>

[NaClnPepper]

I went from 3.3.0 to 3.4.1 on our test VM (Oracle Linux Server 8.3). PostgreSQL 10 to 13 with no problems following their pg_upgrade procedure.