Bug 14975 - Installing PostgreSQL-server 9.4 fails silently because of old version database tree
Summary: Installing PostgreSQL-server 9.4 fails silently because of old version databa...
Status: RESOLVED OLD
Alias: None
Product: Mageia
Classification: Unclassified
Component: RPM Packages (show other bugs)
Version: 5
Hardware: All Linux
Priority: Normal major
Target Milestone: ---
Assignee: Christiaan Welvaart
QA Contact:
URL:
Whiteboard:
Keywords: NEEDINFO
Depends on:
Blocks:
 
Reported: 2015-01-07 10:58 CET by Henri de Solages
Modified: 2018-10-07 17:38 CEST (History)
1 user (show)

See Also:
Source RPM: postgresql9.4-server-9.4.4-1.mga5.i586.rpm
CVE:
Status comment:


Attachments

Description Henri de Solages 2015-01-07 10:58:03 CET
Description of problem:
If PostgreSQL 9.2 (or, probably, any old version of PostgreSQL) had been installed then deleted but the database tree is still there, then installing PostgreSQL 9.3 with drakrpm (Software management) fails SILENTLY.

Doing it by hand, I get:

# urpmi postgresql9.3-server 

p11-kit: couldn't load module: /usr/lib64/pkcs11/p11-kit-trust.so: /usr/lib64/pkcs11/p11-kit-trust.so: cannot open shared object file: No such file or directory
    $MIRRORLIST: media/core/updates/postgresql9.3-server-9.3.4-1.mga4.x86_64.rpm
installing postgresql9.3-server-9.3.4-1.mga4.x86_64.rpm from /var/cache/urpmi/rpms                                                                  
Preparing...                     ##################################################################################################################

You currently have database tree for Postgresql 9.2
You must use postgresql9.2-server
To update you Postgresql server, dump your databases
delete /var/lib/pgsql/data/ content, upgrade the server, then
restore your databases from your backup

error: %pre(postgresql9.3-server-9.3.4-1.mga4.x86_64) scriptlet failed, exit status 1
ERROR: 'script' failed for postgresql9.3-server-9.3.4-1.mga4.x86_64: 
error: postgresql9.3-server-9.3.4-1.mga4.x86_64: install failed
----------------------------------------------------------------------
More information on package postgresql9.3-server-9.3.4-1.mga4.x86_64

----------------------------------------------------------------------

But this explanation is not displayed by drakrpm, which displays an empty window. A clear message failure, with explanation, should be displayed.

Version-Release number of selected component (if applicable):
postgresql9.3-server-9.3.4-1.mga4

How reproducible:
Always

Steps to Reproduce:
1. Install PostgreSQL-server 9.2 and add a database.
2. Remove PostgreSQL-server 9.2.
3. Try to install PostgreSQL-server 9.3 with drakrpm.


Reproducible: 

Steps to Reproduce:
Comment 1 Frédéric "LpSolit" Buclin 2015-07-16 16:25:08 CEST
Trying to install postgresql9.4-server-9.4.4-1.mga5.i586.rpm on Mageia 5 returns the same error when using urpmi. And drakrpm fails silently. No error is thrown, nothing is installed. I had no idea what was going on till I found this bug. So please at least display an error message explaining the user what to do before installing a newer version of Pg.

CC: (none) => LpSolit
Hardware: x86_64 => All
Version: 4 => 5
Source RPM: postgresql9.3-server-9.3.4-1.mga4-x86-64 => postgresql9.4-server-9.4.4-1.mga5.i586.rpm

Frédéric "LpSolit" Buclin 2015-07-16 16:25:29 CEST

Summary: Installing PostgreSQL-server 9.3 with drakrpm fails silently because of old version database tree => Installing PostgreSQL-server 9.4 with drakrpm fails silently because of old version database tree

Comment 2 Frédéric "LpSolit" Buclin 2016-05-14 13:20:35 CEST
Could we get some traction on this bug, please?
Samuel Verschelde 2016-11-01 11:46:17 CET

Assignee: bugsquad => cjw
Summary: Installing PostgreSQL-server 9.4 with drakrpm fails silently because of old version database tree => Installing PostgreSQL-server 9.4 fails silently because of old version database tree

Frédéric "LpSolit" Buclin 2017-10-08 15:27:59 CEST

CC: LpSolit => (none)

Comment 3 Marja Van Waes 2018-10-02 09:57:32 CEST
@ Frédéric

Does this report need to stay open for Mageia 6 and/or cauldron and/or newer postgresl (9.5, 9.6)?

Note that there are different registered maintainers:

postgresql9.4 cjw
postgresql9.5 oden
postgresql9.6 joequant

Keywords: (none) => NEEDINFO
CC: (none) => marja11

Comment 4 Frédéric "LpSolit" Buclin 2018-10-02 15:59:02 CEST
No idea. I didn't try to upgrade an older version of PostgreSQL on Mageia 6.
Comment 5 Marja Van Waes 2018-10-07 17:38:21 CEST
(In reply to Frédéric Buclin from comment #4)
> No idea. I didn't try to upgrade an older version of PostgreSQL on Mageia 6.

Thanks for replying and no problem, I'll close this report as OLD, then.

It can be reopened if it appears to still be valid for a maintained Mageia version.

Resolution: (none) => OLD
Status: NEW => RESOLVED


Note You need to log in before you can comment on or make changes to this bug.