BUG #17315: Postgresql needs reinstall after restore

From: PG Bug reporting form <noreply(at)postgresql(dot)org>
To: pgsql-bugs(at)lists(dot)postgresql(dot)org
Cc: markus(dot)weyermann(at)gmx(dot)net
Subject: BUG #17315: Postgresql needs reinstall after restore
Date: 2021-12-04 22:19:52
Message-ID: 17315-cefb698e069aa044@postgresql.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

The following bug has been logged on the website:

Bug reference: 17315
Logged by: Markus Weyermann
Email address: markus(dot)weyermann(at)gmx(dot)net
PostgreSQL version: 14.1
Operating system: Linux 5.10.63-v8+ aarch64 (Bullseye)
Description:

For recovery purposes i do backup the system at filesystem level. I'm
using
a script that starts rsync to save the default Raspberry Pi OS Partitions
"/" (vfat) and "/boot" (ext4) to nfs target on a nas. Before starting the
script postgresql is shut down by "systemctl stop postgres".
After restore, when trying to start postgres by "systemctl start postgres"
errors are logged:

"
2021-11-21 11:15:11.838 CET [842] LOG: received fast shutdown request
2021-11-21 11:15:11.842 CET [842] LOG: aborting any active transactions
2021-11-21 11:15:11.843 CET [2735] <user>@<server> FATAL: terminating
connection due to administrator command
2021-11-21 11:15:11.849 CET [842] LOG: background worker "logical
replication launcher" (PID 884) exited with exit code 1
2021-11-21 11:15:11.866 CET [879] LOG: shutting down
2021-11-21 11:15:11.970 CET [842] LOG: database system is shut down
/usr/lib/postgresql/14/bin/postgres: error while loading shared libraries:
libicui18n.so.63: cannot open shared object file: No such file or
directory
no data was returned by command ""/usr/lib/postgresql/14/bin/postgres" -V"
The program "postgres" is needed by pg_ctl but was not found in the
same directory as "/usr/lib/postgresql/14/bin/pg_ctl".
Check your installation.
"

When doing "apt --reinstall install postgresql-14" everything is working
again as expected.

This has been working before when running on Buster without the need of
reinstalling postgresql.

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Tom Lane 2021-12-05 16:10:29 Re: BUG #17315: Postgresql needs reinstall after restore
Previous Message HPC Researcher 2021-12-04 03:10:34 Re: BUG #17307: Performance deviation between the multiple iterations (NOPM & TPM values).