I want to setup postgresql database

I started with sudo pacman -S postgresql , it ran after that postgres --version postgres: error while loading shared libraries: libicui18n.so.73: cannot open shared object file: No such file or directory . I am unable to go forward from this step. Is there another step i am missing or something wrong with my pc? Can someone help?

It looks like the PostgreSQL version you installed uses ICU collations, which is an option. However, the package depends on icu:

[dromundkaas@Pure ~]$ pacman -Si extra/postgresql
[...]
Hängt ab von             : postgresql-libs>=16.2  krb5  libxml2  readline  openssl  pam  icu  systemd-libs  libldap  llvm-libs  libxslt  lz4  zstd

Can you check if the file you the error message mentioned is available on your system somewhere? And you could make sure the package is actually installed on your system:

pacman -Qi extra/postgresql

Please show us the output of this.

pacman -Qi extra/postgresql Output : error: package 'extra/postgresql' was not found

Try just:

pacman -Qi postgresql

pacman -Qi postgresql Name : postgresql Version : 15.4-2 Description : Sophisticated object-relational DBMS Architecture : x86_64 URL : https://www.postgresql.org/ Licenses : custom:PostgreSQL Groups : None Provides : None Depends On : postgresql-libs>=15.4 krb5 libxml2 readline>=6.0 openssl>=1.0.0 pam icu systemd-libs libldap llvm15-libs libxslt lz4 zstd Optional Deps : python: for PL/Python 3 support [installed] perl: for PL/Perl support [installed] tcl: for PL/Tcl support [installed] postgresql-old-upgrade: upgrade from previous major version using pg_upgrade logrotate: rotates system logs automatically [installed] Required By : None Optional For : None Conflicts With : None Replaces : None Installed Size : 58.55 MiB Packager : Evangelos Foutras <foutrelis@archlinux.org> Build Date : Saturday 19 August 2023 11:45:19 PM Install Date : Thursday 14 March 2024 01:39:40 PM Install Reason : Explicitly installed Install Script : Yes

Tip: to make the output more readable here, add a line of three backtics ```
before and after the output.

And while at it, do
sudo pacman -Syu

It looks to me like something is up with the repos. When I query/info for postgresql, I get version 16.2-1, which is the current one. hungre2k seems to be getting a much older version (about a year ago).

Yeah, maybe refreshing the mirrors is a good idea too.

Name            : postgresql
Version         : 15.4-2
Description     : Sophisticated object-relational DBMS
Architecture    : x86_64
URL             : https://www.postgresql.org/
Licenses        : custom:PostgreSQL
Groups          : None
Provides        : None
Depends On      : postgresql-libs>=15.4  krb5  libxml2  readline>=6.0  openssl>=1.0.0  pam  icu  systemd-libs  libldap  llvm15-libs  libxslt  lz4  zstd
Optional Deps   : python: for PL/Python 3 support [installed]
                  perl: for PL/Perl support [installed]
                  tcl: for PL/Tcl support [installed]
                  postgresql-old-upgrade: upgrade from previous major version using pg_upgrade
                  logrotate: rotates system logs automatically [installed]
Required By     : None
Optional For    : None
Conflicts With  : None
Replaces        : None
Installed Size  : 58.55 MiB
Packager        : Evangelos Foutras <foutrelis@archlinux.org>
Build Date      : Saturday 19 August 2023 11:45:19 PM
Install Date    : Thursday 14 March 2024 01:39:40 PM
Install Reason  : Explicitly installed
Install Script  : Yes
Validated By    : Signature```
1 Like

Refresh your mirrorlist and update your system.

Can you please tell me how to do it. I am new

Launch the welcome app from your application menu.
There are a couple of buttons for refreshing mirrors.

  • Run: eos-welcome --once
  • Click button: Update Mirrors (Arch, rate-mirrors) (or the other one for Arch)
  • Afterwards click: Update System (eos-update --aur)

postgres --version is working now. Thanks everyone. postgres --version postgres (PostgreSQL) 16.2

1 Like

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