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-mysql-database
>
>
>
> 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:
> - 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@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



--
VoIP Embedded, Inc.
http://www.voipembedded.com