Mageia forum

After the upgrade from Mageia 1 to Mageia 2 postgresql cannot be started any more:

Code: Select all

[root@cortex etc]# systemctl start postgresql.service
[root@cortex etc]# systemctl status postgresql.service
postgresql.service - LSB: PostgreSql server database
          Loaded: loaded (/etc/rc.d/init.d/postgresql)
          Active: failed (Result: exit-code) since Mon, 04 Jun 2012 12:51:45 +0200; 6s ago
         Process: 14327 ExecStop=/etc/rc.d/init.d/postgresql stop (code=exited, status=1/FAILURE)
         Process: 14282 ExecStart=/etc/rc.d/init.d/postgresql start (code=exited, status=0/SUCCESS)
        Main PID: 14318 (code=exited, status=1/FAILURE)
          CGroup: name=systemd:/system/postgresql.service

Jun 04 12:51:45 cortex su[14294]: pam_tcb(su-l:session): Session opened for...0)
Jun 04 12:51:45 cortex postgresql[14282]: Dienst postgresql wird gestartet: ...]
Jun 04 12:51:45 cortex su[14339]: pam_tcb(su-l:session): Session opened for...0)
Jun 04 12:51:45 cortex postgresql[14327]: Stoppen des postgresql-Dienstes: p...t
Jun 04 12:51:45 cortex postgresql[14327]: Is server running?
[root@cortex etc]#

It happened that my backup software (SEP sesam) told me that there is no postgres server running. Starting it manually failed. What can I do?

Please show the output of

Code: Select all

rpm -qa | grep postgresql

Code: Select all

[root@cortex etc]# rpm -qa | grep postgresql
postgresql8.4-devel-8.4.11-1.mga2
postgresql8.4-server-8.4.11-1.mga2
postgresql8.4-8.4.11-1.mga2
postgresql-jdbc-9.0.801-1.mga2
[root@cortex etc]#


Thank you for that hint. I reinstalled all these packages (urpmi --replacepkgs *) and now it is working.

Be aware that there are three different postgresql versions in Mageia currently. Just FYI.

That is true but the automatic upgrade does not let me choose anyway. SEP sesam requires PostgreSQL 8.3 but once PostgreSQL was running I had to change only two system settings to run sesam with the newer version.