SOLVED XiVO Upgrade problem. (postgresql)

[VaHam]

Any ideas on best way to fix this? Xivo continues to work except that no new data base functions can be performed.
I have attempted to upgrade from 16.10 to 16.11 and had a problem with 4 of the packages which I suspect are all related to the postgresql package version. After having tried command line method which only told me I had a problem with the four packages I tried the upgrade using webmin which provided a little more information as follows:

Now updating xivo-dbms xivo-dird xivo-libdird xivo-manage-db ..
Installing package(s) with command apt-get -y install xivo-dbms xivo-dird xivo-libdird xivo-manage-db ..
Reading package lists...
Building dependency tree...
Reading state information...
Some packages could not be installed. This may mean that you have
requested an impossible situation or if you are using the unstable
distribution that some required packages have not yet been created
or been moved out of Incoming.
The following information may help to resolve the situation:

The following packages have unmet dependencies:
xivo-dbms : Depends: postgresql-9.4 (>= 9.4.9-0+deb8u1) but 9.4.8-0+deb8u1 is to be installed

I did run
dpkg --get-selections | grep hold
which returned nothing indicating there are no packages on hold. Otherwise the upgrade appears to have worked fine.

​

The following is my sources.list:

#deb http://non-us.debian.org/debian-non-US stable/non-US main contrib non-free
deb http://http.us.debian.org/debian stable main contrib non-free
deb http://security.debian.org/ squeeze/updates main
deb-src http://security.debian.org/ squeeze/updates main
deb http://download.webmin.com/download/repository sarge contrib

 

[wardmundy]

Please post this on the XiVO forum and report back. Thanks.

 

[VaHam]

Please post this on the XiVO forum and report back. Thanks.

I did as you suggested and in 9 minutes I was handed the solution. As I kind of suspected my sources.list was wrong. The following is how it now looks after making the changes needed:

deb http://http.us.debian.org/debian jessie main contrib non-free
deb http://security.debian.org/ jessie/updates main
deb-src http://security.debian.org/ jessie/updates main
deb http://download.webmin.com/download/repository sarge contrib

I then simply performed the package update using webmin and it identified 59 new packages which were needed. All of them downloaded and installed perfectly.
I then checked and XiVO databases are working fine now.

 

[wardmundy]

 

[VaHam]

UPDATE:
I should mention that the exact advice given me on the XiVO forum was more correct than that which I posted above. First the advice was that we should always use the command upgrade tool to perform upgrades.
xivo-upgrade

Second the recommendation for the /etc/apt/sources.list use different mirrors as below:

deb http://ftp.ca.debian.org/debian/ jessie main
deb-src http://ftp.ca.debian.org/debian/ jessie main

deb http://security.debian.org/ jessie/updates main
deb-src http://security.debian.org/ jessie/updates main

# jessie-updates, previously known as 'volatile'
deb http://ftp.ca.debian.org/debian/ jessie-updates main
deb-src http://ftp.ca.debian.org/debian/ jessie-updates main