[SR-Users] upgrade kamailio 4.4.x-to-5.0.0 - PostgreSQL migrations

[Giovanni Tommasini - timenet srl]

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 at 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 at 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 at timenet.it>
> > Sent: Thursday, September 30, 2021 4:46 PM
> > To: Kamailio (SER) - Users Mailing List <sr-users at lists.kamailio.org>
> > Cc: Henning Westerholt <hw at 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 at 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 at lists.kamailio.org> On Behalf Of
> Giovanni Tommasini - timenet srl
> > Sent: Wednesday, September 29, 2021 10:06 AM
> > To: sr-users at 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 at 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
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.kamailio.org/pipermail/sr-users/attachments/20211011/a5ce896e/attachment.htm>