Postgres (AUR) cannot start after update

Hello there!
Today, I updated my software using pamac. A long time ago, I added postgresql and postgresql-libs to /etc/pacman.conf to ignore them during updates. I don’t want to update my postgres to a new major version because it was hard to migrate your data between major versions. But I did it for two times already… In other words, I dislike this process. The issue now lies with the icu package. I can’t downgrade this package because it breaks Simple Desktop Display Manager. I can’t rebuild my postgresql and postgresql-libs because pamac attempts me to force installing a new major version of postgres. If I use downgrade to try to install another minor version, it doesn’t help me. What can I do to rebuild my postgresql and force to work it well?

sudo pamac build postgresql postgresql-libs postgresql-old-upgrade
Warning: Building packages as dynamic user
Warning: Setting build directory to /var/cache/pamac
Install postgresql from extra ? [y/N] y
Install postgresql-libs from extra ? [y/N] y
Install postgresql-old-upgrade from extra ? [y/N] y
Preparing...
Synchronizing package databases...
Warning: datagrip: ignoring package upgrade (2022.1.5-1 => 2023.3.2-1)
Warning: datagrip-jre: ignoring package upgrade (2022.1.5-1 => 2023.3.2-1)
Warning: erlang-nox: ignoring package upgrade (25.3.2-1 => 26.2.1-1)
Warning: openvpn: ignoring package upgrade (2.5.7-1 => 2.6.8-1)
Warning: rabbitmq: ignoring package upgrade (3.11.9-1 => 3.12.10-1)
Resolving dependencies...
Checking inter-conflicts...

To upgrade (3):
  postgresql-libs         16.1-3  (15.4-2)  extra  1,7 MB
  postgresql              16.1-3  (15.4-2)  extra  21,0 MB
  postgresql-old-upgrade  15.5-3  (14.7-3)  extra  18,2 MB

Total download size: 40,9 MB

Apply transaction ? [y/N] N

Transaction cancelled.

If I choose “Install from extra”, pamac suggests me to install old versions:

sudo pamac build postgresql postgresql-libs
Warning: Building packages as dynamic user
Warning: Setting build directory to /var/cache/pamac
Install postgresql from extra ? [y/N] N

Install postgresql-libs from extra ? [y/N] N

Preparing...
Checking postgresql-libs-12 dependencies...
Checking postgresql13-libs dependencies...
Checking postgresql-libs-git dependencies...
Checking postgresql15-libs dependencies...
Checking postgresql-docs-git dependencies...
Checking postgresql-uint-git dependencies...
Checking postgresql-docs-12 dependencies...
Checking postgresql-devel dependencies...
Checking postgresql-devel-libs dependencies...
Checking postgresql16-libs dependencies...
Checking postgresql11-libs dependencies...
Checking postgresql15-docs dependencies...
Checking postgresql-12 dependencies...
Checking postgresql14-libs dependencies...
Checking postgresql13-docs dependencies...
Checking postgresql-plsh dependencies...
Checking postgresql-git dependencies...
Checking postgresql-zson-git dependencies...
Checking postgresql13 dependencies...
Checking postgresql15 dependencies...
Checking postgresql16 dependencies...
Checking postgresql-devel-docs dependencies...
Checking postgresql16-docs dependencies...
Checking python2 dependencies...
Checking icu-git dependencies...
Checking libicu53 dependencies...
Choose a provider for postgresql-libs:
1:  postgresql-libs-12   12.17-1                      AUR
2:  postgresql-libs-git  16.beta2.r779.g861f86beea-1  AUR
3:  postgresql13-libs    13.13-1                      AUR

Enter a number (default=1): ^C^C^C

Choose a provider for postgresql:
1:  postgresql-12          12.17-1                      AUR
2:  postgresql-devel       17devel-1                    AUR
3:  postgresql-devel-docs  17devel-1                    AUR
4:  postgresql-git         16.beta2.r779.g861f86beea-1  AUR
5:  postgresql13           13.13-1                      AUR
6:  postgresql15           15.5-4                       AUR
7:  postgresql15-docs      15.5-4                       AUR
8:  postgresql16           16.1-5                       AUR
9:  postgresql16-docs      16.1-5                       AUR

Enter a number (default=1): 
Choose a provider for postgresql-libs:
1:  postgresql-libs-12   12.17-1                      AUR
2:  postgresql-libs-git  16.beta2.r779.g861f86beea-1  AUR
3:  postgresql13-libs    13.13-1                      AUR

Theres a number of things I would do differently.

But probably … why not just use the postegresql15 packages if thats the version you want to stick to?

$ paru postgresql15

3 aur/postgresql15-libs 15.5-4 [+1 ~1.00]
    Libraries for use with PostgreSQL
2 aur/postgresql15-docs 15.5-4 [+1 ~1.00]
    HTML documentation for PostgreSQL
1 aur/postgresql15 15.5-4 [+1 ~1.00]
    Sophisticated object-relational DBMS
3 Likes

I want to stick to my installed 15 version of postgresql.

Excuse me, 15, but same thing.
(edited)

1 Like

Thank you! It is working fine. All I needed was to move all my data from /var/lib/postgres/data to /var/lib/postgres/data15.

2 Likes

This topic was automatically closed 36 hours after the last reply. New replies are no longer allowed.