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 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@lists.kamailio.org On Behalf Of Giovanni Tommasini - timenet srl Sent: Wednesday, September 29, 2021 10:06 AM To: sr-users@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
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@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@lists.kamailio.org *On Behalf Of *Giovanni Tommasini - timenet srl *Sent:* Wednesday, September 29, 2021 10:06 AM *To:* sr-users@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:
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/#create...
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.comhttps://gilawa.com/
From: Giovanni Tommasini - timenet srl giovanni.tommasini@timenet.it Sent: Thursday, September 30, 2021 4:46 PM To: Kamailio (SER) - Users Mailing List sr-users@lists.kamailio.org Cc: Henning Westerholt hw@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@skalatan.demailto:hw@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@lists.kamailio.orgmailto:sr-users-bounces@lists.kamailio.org> On Behalf Of Giovanni Tommasini - timenet srl Sent: Wednesday, September 29, 2021 10:06 AM To: sr-users@lists.kamailio.orgmailto:sr-users@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 Giovanni,
You can check the postgres db scripts for each kamailio version under utils/kamctl/postgres. There you have the scripts for creating the postgress db tables. You can see the exact differences between versions by comparing the relevant files. This is how I double check the db changes between upgrades :)
Hope this helps, Ovidiu
On Thu, Sep 30, 2021 at 2:00 PM Henning Westerholt hw@skalatan.de wrote:
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/#create...
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@timenet.it Sent: Thursday, September 30, 2021 4:46 PM To: Kamailio (SER) - Users Mailing List sr-users@lists.kamailio.org Cc: Henning Westerholt hw@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@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@lists.kamailio.org On Behalf Of Giovanni Tommasini - timenet srl Sent: Wednesday, September 29, 2021 10:06 AM To: sr-users@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:
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@lists.kamailio.org
Important: keep the mailing list in the recipients, do not reply only to the sender! Edit mailing list options or unsubscribe:
Thank you all. I have almost finished testing the update with all the Database migrations. As soon as it's done, I'll share the various migrations I've done here (if there's not a more suitable place in the wiki).
Cheers, Giovanni
Il giorno ven 1 ott 2021 alle ore 15:04 Ovidiu Sas osas@voipembedded.com ha scritto:
Hello Giovanni,
You can check the postgres db scripts for each kamailio version under utils/kamctl/postgres. There you have the scripts for creating the postgress db tables. You can see the exact differences between versions by comparing the relevant files. This is how I double check the db changes between upgrades :)
Hope this helps, Ovidiu
On Thu, Sep 30, 2021 at 2:00 PM Henning Westerholt hw@skalatan.de wrote:
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/#create...
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@timenet.it Sent: Thursday, September 30, 2021 4:46 PM To: Kamailio (SER) - Users Mailing List sr-users@lists.kamailio.org Cc: Henning Westerholt hw@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@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@lists.kamailio.org On Behalf Of
Giovanni Tommasini - timenet srl
Sent: Wednesday, September 29, 2021 10:06 AM To: sr-users@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:
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@lists.kamailio.org
Important: keep the mailing list in the recipients, do not reply only to
the sender!
Edit mailing list options or unsubscribe:
-- VoIP Embedded, Inc. http://www.voipembedded.com
-
Giovanni Tommasini - timenet srl -
Henning Westerholt -
Ovidiu Sas