Hello Giovanni, You are doing a bigger step in one upgrade. I would suggest the following approach to get the DB differences: - Do a pg_dump -s for the database schema on the existing 4.4.x DB - Install the new 5.4.x kamailio postgres DB on a test server etc.. - Do a pg_dump -s for the new database schema on the test server - Compare the two schemas e.g. with diff or similar tool - Use this to create an ALTER TABLE to (a copy) of the old database on a test server and test - Alternatively you can of course also use other SQL techniques to insert the old data into the new one Cheers, Henning *From:* sr-users <sr-users-bounces(a)lists.kamailio.org> *On Behalf Of *Giovanni Tommasini - timenet srl *Sent:* Wednesday, September 29, 2021 10:06 AM *To:* sr-users(a)lists.kamailio.org *Subject:* [SR-Users] upgrade kamailio 4.4.x-to-5.0.0 - PostgreSQL migrations Hi Dears, I'm working on upgrading Kamailio from 4.4.6 to 5.4.0 in an installation where I use PostgreSQL I understand that I have to upgrade in steps by following these links: - http://www.kamailio.org/wiki/install/upgrade/4.4.x-to-5.0.0 - http://www.kamailio.org/wiki/install/upgrade/5.0.x-to-5.1.0 - https://www.kamailio.org/wiki/install/upgrade/5.1.x-to-5.2.0 - https://www.kamailio.org/wiki/install/upgrade/5.2.x-to-5.3.0 - https://www.kamailio.org/wiki/install/upgrade/5.3.x-to-5.4.0 in most of these links, in the section "Database", I find only the subsection "MySQL Database Structure", but I don't find the indications for DB migrations for PostgreSQL Database. Only here https://www.kamailio.org/wiki/install/upgrade/5.2.x-to-5.3.0 I found both the subsection "MySQL Database Structure" and "PostgreSQL Database Structure". What does this mean? - that I'm getting lost in a glass of water? - or that I don't have to make any changes to PostgreSQL? - or that the queries to be launched on PostgreSQL are the same as those for MySQL? I would discard this hypothesis - or that the wiki sections for PostgreSQL are missing? If this were the case, I could proceed with the update and then share the queries I launched to update the wiki. thanks a lot Giovanni Tommasini

Hello, have a look to the docs e.g., here, and replace mysql with postgres: https://kamailio.org/docs/tutorials/5.4.x/kamailio-install-guide-git/#creat… There is a tool “kamdbctl” for it, you can also just use the plain scheme files in the kamailio source. Cheers, Henning -- Henning Westerholt – https://skalatan.de/blog/ Kamailio services – https://gilawa.com From: Giovanni Tommasini - timenet srl <giovanni.tommasini(a)timenet.it> Sent: Thursday, September 30, 2021 4:46 PM To: Kamailio (SER) - Users Mailing List <sr-users(a)lists.kamailio.org> Cc: Henning Westerholt <hw(a)skalatan.de> Subject: Re: [SR-Users] upgrade kamailio 4.4.x-to-5.0.0 - PostgreSQL migrations Hi Henning, thank you for your reply. Interesting approach. Can you tell me where I can find information on how to "Install the new 5.4.x kamailio postgres DB"? Cheers, Giovanni Il giorno gio 30 set 2021 alle ore 09:03 Henning Westerholt <hw(a)skalatan.de> ha scritto: Hello Giovanni, You are doing a bigger step in one upgrade. I would suggest the following approach to get the DB differences: · Do a pg_dump -s for the database schema on the existing 4.4.x DB · Install the new 5.4.x kamailio postgres DB on a test server etc.. · Do a pg_dump -s for the new database schema on the test server · Compare the two schemas e.g. with diff or similar tool · Use this to create an ALTER TABLE to (a copy) of the old database on a test server and test · Alternatively you can of course also use other SQL techniques to insert the old data into the new one Cheers, Henning From: sr-users <sr-users-bounces(a)lists.kamailio.org> On Behalf Of Giovanni Tommasini - timenet srl Sent: Wednesday, September 29, 2021 10:06 AM To: sr-users(a)lists.kamailio.org Subject: [SR-Users] upgrade kamailio 4.4.x-to-5.0.0 - PostgreSQL migrations Hi Dears, I'm working on upgrading Kamailio from 4.4.6 to 5.4.0 in an installation where I use PostgreSQL I understand that I have to upgrade in steps by following these links: - http://www.kamailio.org/wiki/install/upgrade/4.4.x-to-5.0.0 - http://www.kamailio.org/wiki/install/upgrade/5.0.x-to-5.1.0 - https://www.kamailio.org/wiki/install/upgrade/5.1.x-to-5.2.0 - https://www.kamailio.org/wiki/install/upgrade/5.2.x-to-5.3.0 - https://www.kamailio.org/wiki/install/upgrade/5.3.x-to-5.4.0 in most of these links, in the section "Database", I find only the subsection "MySQL Database Structure", but I don't find the indications for DB migrations for PostgreSQL Database. Only here https://www.kamailio.org/wiki/install/upgrade/5.2.x-to-5.3.0 I found both the subsection "MySQL Database Structure" and "PostgreSQL Database Structure". What does this mean? - that I'm getting lost in a glass of water? - or that I don't have to make any changes to PostgreSQL? - or that the queries to be launched on PostgreSQL are the same as those for MySQL? I would discard this hypothesis - or that the wiki sections for PostgreSQL are missing? If this were the case, I could proceed with the update and then share the queries I launched to update the wiki. thanks a lot Giovanni Tommasini __________________________________________________________ Kamailio - Users Mailing List - Non Commercial Discussions * sr-users(a)lists.kamailio.org Important: keep the mailing list in the recipients, do not reply only to the sender! Edit mailing list options or unsubscribe: * https://lists.kamailio.org/cgi-bin/mailman/listinfo/sr-users