Bug 4939

Summary: Postgresql won't start (unless apache2 is also installed).
Product: Mageia Reporter: Richard Neill <mageia>
Component: RPM PackagesAssignee: Olivier Thauvin <nanardon>
Status: RESOLVED FIXED QA Contact:
Severity: major    
Priority: Normal Keywords: NEEDINFO
Version: Cauldron   
Target Milestone: ---   
Hardware: x86_64   
OS: Linux   
Whiteboard:
Source RPM: postgresql9.1 CVE:
Status comment:

Description Richard Neill 2012-03-14 01:37:53 CET
Description of problem:

This one is a bit weird, but I have seen it twice and can reproduce it. It seems that postgresql 9.1 can only start once some extra thing is installed, and that extra component is part of the apache2 dependencies, not the postgresql ones.

How reproducible:

Always


Steps to Reproduce:

1. 
Remove apache, postgresql to start with a clean system:

urpme apache-mpm-prefork ; urpme postgresql9.1; urpme  postgresql9.1-server ; urpme postgresql9.1-plpgsql ; urpme postgresql9.1-contrib;  urpme --auto-orphans
rm -rf /var/lib/pgsql/


2. Install JUST postgres:

urpmi postgresql9.1 postgresql9.1-server postgresql9.1-plpgsql postgresql9.1-contrib

3. The installer complains:

Failed to issue method call: Unit postgresql.service failed to load: No such file or directory. See system logs and 'systemctl status postgresql.service' for details.
warning: %posttrans(postgresql9.1-server-9.1.3-1.mga2.x86_64) scriptlet failed, exit status 1


4. Manually starting it complains:

# service postgresql start
Starting postgresql (via systemctl):  Failed to issue method call: Unit postgresql.service failed to load: No such file or directory. See system logs and 'systemctl status postgresql.service' for details.  [FAILED]

                                              
# systemctl status postgresql.service
postgresql.service
          Loaded: error (Reason: No such file or directory)
          Active: inactive (dead) since Wed, 14 Mar 2012 00:22:12 +0000; 1min 45s ago
        Main PID: 6056 (code=exited, status=0/SUCCESS)


I also noticed that /var/lib/pgsql/data is rather empty.


5. Now install apache2:  urpmi apache-mpm-prefork-2.2.22-3  (and all 47 dependencies)


6. It is now possible to start postgresql.


Sorry this report only explains what happens and not why!
Manuel Hiebel 2012-03-14 02:24:06 CET

Assignee: bugsquad => nanardon
Source RPM: postgresql9.1-server-9.1.3-1.mga2 => postgresql9.1

Comment 1 Marja Van Waes 2012-05-26 13:07:22 CEST
Hi,

This bug was filed against cauldron, but we do not have cauldron at the moment.

Please report whether this bug is still valid for Mageia 2.

Thanks :)

Cheers,
marja

Keywords: (none) => NEEDINFO

Comment 2 Richard Neill 2012-05-26 21:42:17 CEST
This one seems to be OK now. At any rate, I can't reproduce it according to my original instructions.

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