Answer the question
In order to leave comments, you need to log in
Why is Postgresql downgrading?
Colleagues, good afternoon.
Explain to me what kind of magic?) I installed postgresql for 1C on ubuntu server 18.04 via apt-get. It turned out that you need postgresql from the 1C site. Removed postgresql with apt=get remove. Installed Postgresql from the 1C site - everything works.
But every night the version is reset to the old one!)) What the hell is this? Some sort of scheduling task? The error appears at 3:30 at night.
Below is the output in the evening, and in the morning.
[email protected]:~# dpkg -l | grep postgres
ii postgresql-10 10.5-24.1C amd64 object-relational SQL database, version 10 server
ii postgresql-client-10 10.5-24.1C amd64 front-end programs for PostgreSQL 10
ii postgresql-client-common 190 all manager for multiple PostgreSQL client versions
ii postgresql-common 190 all PostgreSQL database-cluster manager ii postgresql-doc
-
10 10.5-24.1C
10.5-24.1C amd64 development files for PostgreSQL 10 server-side pro
[email protected]:~# dpkg -l | grep postgres
ii postgresql-10 10.8-0ubuntu0.18.04.1 amd64 object-relational SQL database, version 10 server
ii postgresql-client-10 10.8-0ubuntu0.18.04.1 amd64 front-end programs for PostgreSQL 10
ii postgresql-client-common 190 all manager for multiple PostgreSQL client versions
ii postgresql-common 190 all PostgreSQL database-cluster manager
ii postgresql-doc-10 10.8-0ubuntu0.18.04.1 all documentation for the PostgreSQL database managemen
ii postgresql-server-dev-10 10.8-0ubuntu0.18.04.1
Answer the question
In order to leave comments, you need to log in
So this is not a downgrade, this is an upgrade of packages to a newer version, which is quite standard.
Solved by disabling update for the relevant packages:
echo "postgresql-10 hold" | sudo dpkg --set-selections
echo "postgresql-client-10 hold" | sudo dpkg --set-selections
echo "postgresql-client-common hold" | sudo dpkg --set-selections
echo "postgresql-common hold" | sudo dpkg --set-selections
echo "postgresql-doc-10 hold" | sudo dpkg --set-selections
echo "postgresql-server-dev-10 hold" | sudo dpkg --set-selections
sudo apt-mark hold postgresql-10
sudo apt-mark hold postgresql-client-10
sudo apt-mark hold postgresql-client-common
sudo apt-mark hold postgresql-common
sudo apt-mark hold postgresql-doc-10
sudo apt-mark hold postgresql-server-dev-10
Didn't find what you were looking for?
Ask your questionAsk a Question
731 491 924 answers to any question