Bug 4939 - Postgresql won't start (unless apache2 is also installed).
Summary: Postgresql won't start (unless apache2 is also installed).
Status: RESOLVED FIXED
Alias: None
Product: Mageia
Classification: Unclassified
Component: RPM Packages (show other bugs)
Version: Cauldron
Hardware: x86_64 Linux
Priority: Normal major
Target Milestone: ---
Assignee: Olivier Thauvin
QA Contact:
URL:
Whiteboard:
Keywords: NEEDINFO
Depends on:
Blocks:
 
Reported: 2012-03-14 01:37 CET by Richard Neill
Modified: 2012-05-26 21:42 CEST (History)
0 users

See Also:
Source RPM: postgresql9.1
CVE:
Status comment:


Attachments

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


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