I
I
Ivan2019-06-03 10:16:03
linux
Ivan, 2019-06-03 10:16:03

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

1 answer(s)
A
AUser0, 2019-06-03
@Amigo83

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 question

Ask a Question

731 491 924 answers to any question