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 <[email protected]> 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 <[email protected]> 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 <[email protected]> > > Sent: Thursday, September 30, 2021 4:46 PM > > To: Kamailio (SER) - Users Mailing List <[email protected]> > > Cc: Henning Westerholt <[email protected]> > > 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 < > [email protected]> 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 <[email protected]> On Behalf Of > Giovanni Tommasini - timenet srl > > Sent: Wednesday, September 29, 2021 10:06 AM > > To: [email protected] > > 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 > > * [email protected] > > 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 >
__________________________________________________________ Kamailio - Users Mailing List - Non Commercial Discussions * [email protected] 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
