PostgreSQL startet nicht mehr

[WillhelmTell]

Hallo zusammen

Ich habe einen SuSE Openexchange Server 4 in Betrieb.
Heute musste ich die Kiste neu booten.

Nun startet PostgreSQL beim booten nicht mehr.
Wenn ich die PostgreSQL von Hand starten will (/etc/init.d/postgresql start ), bekomme ich folgende Fehlermeldung:

Starting PostgreSQLstartproc: exit status of parent of /usr/bin/postmaster: 1

Wenn ich mich nun per Browser auf meinen Server einloggen will, erscheint die
folgende Meldung:

Connection to LDAP Server failed! at /srv/www/start/index.pl line 45

Was heisst das?
Und was kann ich nun tun, um das Ding wieder zum laufen zu bekommen?

Besten Dank für eure Hilfe.

[himbeere]

Und was kann ich nun tun, um das Ding wieder zum laufen zu bekommen?

Du könntest Dir mal die Logfiles etwas näher anschauen und bei Nichtverstehen hier posten.

Thomas

[WillhelmTell]

Hallo

welche Logfiles brauchst du?
Wäre Dir mega dankbar für Deine Hilfe.

CU
WillhelmTell

[himbeere]

Hm. Keine Ahnung wo der Openexchange Server hinloggt. Was ist denn mit den üblichen Files in /var/log? Grep doch mal drüber mit grep postmaster /var/log/* oder so.

Thomas

[WillhelmTell]

Das hier hat meine Kiste ausgespuckt:

/var/log/localmessages:Mar 23 18:02:01 monster startproc: startproc: exit statu
s of parent of /usr/bin/postmaster: 1
/var/log/localmessages:Mar 23 18:02:36 monster startproc: startproc: exit statu
s of parent of /usr/bin/postmaster: 1
/var/log/localmessages:Mar 23 19:59:38 monster startproc: startproc: exit statu
s of parent of /usr/bin/postmaster: 1
/var/log/localmessages:Mar 23 20:00:50 monster startproc: startproc: exit statu
s of parent of /usr/bin/postmaster: 1
/var/log/localmessages:Mar 23 20:10:39 monster startproc: startproc: exit statu
s of parent of /usr/bin/postmaster: 1
/var/log/localmessages:Mar 23 20:19:52 monster startproc: startproc: exit statu
s of parent of /usr/bin/postmaster: 1
/var/log/localmessages:Mar 23 20:21:26 monster startproc: startproc: exit statu
s of parent of /usr/bin/postmaster: 1
/var/log/localmessages:Mar 23 20:35:26 monster startproc: startproc: exit statu
s of parent of /usr/bin/postmaster: 1
/var/log/messages:Mar 23 18:02:01 monster startproc: startproc: exit status of
parent of /usr/bin/postmaster: 1
/var/log/messages:Mar 23 18:02:36 monster startproc: startproc: exit status of
parent of /usr/bin/postmaster: 1
/var/log/messages:Mar 23 19:59:38 monster startproc: startproc: exit status of
parent of /usr/bin/postmaster: 1
/var/log/messages:Mar 23 20:00:50 monster startproc: startproc: exit status of
parent of /usr/bin/postmaster: 1
/var/log/messages:Mar 23 20:10:39 monster startproc: startproc: exit status of
parent of /usr/bin/postmaster: 1
/var/log/messages:Mar 23 20:19:52 monster startproc: startproc: exit status of
parent of /usr/bin/postmaster: 1
/var/log/messages:Mar 23 20:21:26 monster startproc: startproc: exit status of
parent of /usr/bin/postmaster: 1
/var/log/messages:Mar 23 20:35:26 monster startproc: startproc: exit status of
parent of /usr/bin/postmaster: 1
/var/log/postgresql:Lock file "/var/lib/pgsql/data/postmaster.pid" already exist
s.
/var/log/postgresql:Is another postmaster (pid 652) running in "/var/lib/pgsql/d
ata"?
/var/log/postgresql:Lock file "/var/lib/pgsql/data/postmaster.pid" already exist
s.
/var/log/postgresql:Is another postmaster (pid 652) running in "/var/lib/pgsql/d
ata"?
/var/log/postgresql:Lock file "/var/lib/pgsql/data/postmaster.pid" already exist
s.
/var/log/postgresql:Is another postmaster (pid 652) running in "/var/lib/pgsql/d
ata"?
/var/log/postgresql:Lock file "/var/lib/pgsql/data/postmaster.pid" already exist
s.
/var/log/postgresql:Is another postmaster (pid 652) running in "/var/lib/pgsql/d
ata"?
/var/log/postgresql:Lock file "/var/lib/pgsql/data/postmaster.pid" already exist
s.
/var/log/postgresql:Is another postmaster (pid 652) running in "/var/lib/pgsql/d
ata"?
/var/log/postgresql:Lock file "/var/lib/pgsql/data/postmaster.pid" already exist
s.
/var/log/postgresql:Is another postmaster (pid 652) running in "/var/lib/pgsql/d
ata"?
/var/log/postgresql:Lock file "/var/lib/pgsql/data/postmaster.pid" already exist
s.
/var/log/postgresql:Is another postmaster (pid 652) running in "/var/lib/pgsql/d
ata"?
/var/log/postgresql:Lock file "/var/lib/pgsql/data/postmaster.pid" already exist
s.
/var/log/postgresql:Is another postmaster (pid 652) running in "/var/lib/pgsql/d
ata"?
/var/log/postgresql:Lock file "/var/lib/pgsql/data/postmaster.pid" already exist
s.
/var/log/postgresql:Is another postmaster (pid 652) running in "/var/lib/pgsql/d
ata"?
/var/log/postgresql:Lock file "/var/lib/pgsql/data/postmaster.pid" already exist
s.
/var/log/postgresql:Is another postmaster (pid 652) running in "/var/lib/pgsql/d
ata"?
/var/log/postgresql:Lock file "/var/lib/pgsql/data/postmaster.pid" already exist
s.
/var/log/postgresql:Is another postmaster (pid 652) running in "/var/lib/pgsql/d
ata"?
/var/log/postgresql:Lock file "/var/lib/pgsql/data/postmaster.pid" already exist
s.
/var/log/postgresql:Is another postmaster (pid 652) running in "/var/lib/pgsql/d
ata"?
/var/log/postgresql:Lock file "/var/lib/pgsql/data/postmaster.pid" already exist
s.
/var/log/postgresql:Is another postmaster (pid 652) running in "/var/lib/pgsql/d
ata"?
/var/log/postgresql:Lock file "/var/lib/pgsql/data/postmaster.pid" already exist
s.
/var/log/postgresql:Is another postmaster (pid 652) running in "/var/lib/pgsql/d
ata"?
/var/log/postgresql:Lock file "/var/lib/pgsql/data/postmaster.pid" already exist
s.
/var/log/postgresql:Is another postmaster (pid 652) running in "/var/lib/pgsql/d
ata"?
/var/log/postgresql:Lock file "/var/lib/pgsql/data/postmaster.pid" already exist
s.
/var/log/postgresql:Is another postmaster (pid 652) running in "/var/lib/pgsql/d
ata"?
/var/log/postgresql:Lock file "/var/lib/pgsql/data/postmaster.pid" already exist
s.
/var/log/postgresql:Is another postmaster (pid 652) running in "/var/lib/pgsql/d
ata"?
/var/log/postgresql:Lock file "/var/lib/pgsql/data/postmaster.pid" already exist
s.
/var/log/postgresql:Is another postmaster (pid 652) running in "/var/lib/pgsql/d
ata"?
/var/log/postgresql:Lock file "/var/lib/pgsql/data/postmaster.pid" already exist
s.
/var/log/postgresql:Is another postmaster (pid 652) running in "/var/lib/pgsql/d
ata"?
/var/log/postgresql:Lock file "/var/lib/pgsql/data/postmaster.pid" already exist
s.
/var/log/postgresql:Is another postmaster (pid 652) running in "/var/lib/pgsql/d
ata"?
/var/log/postgresql:Lock file "/var/lib/pgsql/data/postmaster.pid" already exist
s.
/var/log/postgresql:Is another postmaster (pid 652) running in "/var/lib/pgsql/d
ata"?
/var/log/postgresql:Lock file "/var/lib/pgsql/data/postmaster.pid" already exist
s.
/var/log/postgresql:Is another postmaster (pid 652) running in "/var/lib/pgsql/d
ata"?
/var/log/postgresql:Lock file "/var/lib/pgsql/data/postmaster.pid" already exist
s.
/var/log/postgresql:Is another postmaster (pid 652) running in "/var/lib/pgsql/d
ata"?
/var/log/postgresql:Lock file "/var/lib/pgsql/data/postmaster.pid" already exist
s.
/var/log/postgresql:Is another postmaster (pid 652) running in "/var/lib/pgsql/d
ata"?
/var/log/postgresql:Lock file "/var/lib/pgsql/data/postmaster.pid" already exist
s.
/var/log/postgresql:Is another postmaster (pid 652) running in "/var/lib/pgsql/d
ata"?
/var/log/postgresql:Lock file "/var/lib/pgsql/data/postmaster.pid" already exist
s.
/var/log/postgresql:Is another postmaster (pid 652) running in "/var/lib/pgsql/d
ata"?
/var/log/postgresql:Lock file "/var/lib/pgsql/data/postmaster.pid" already exist
s.
/var/log/postgresql:Is another postmaster (pid 652) running in "/var/lib/pgsql/d
ata"?
/var/log/postgresql:Lock file "/var/lib/pgsql/data/postmaster.pid" already exist
s.
/var/log/postgresql:Is another postmaster (pid 652) running in "/var/lib/pgsql/d ata"?
/var/log/postgresql:Lock file "/var/lib/pgsql/data/postmaster.pid" already exist s.
/var/log/postgresql:Is another postmaster (pid 652) running in "/var/lib/pgsql/d ata"?
/var/log/warn:Mar 23 18:02:01 monster startproc: startproc: exit status of pare nt of /usr/bin/postmaster: 1
/var/log/warn:Mar 23 18:02:36 monster startproc: startproc: exit status of pare nt of /usr/bin/postmaster: 1
/var/log/warn:Mar 23 19:59:38 monster startproc: startproc: exit status of pare nt of /usr/bin/postmaster: 1
/var/log/warn:Mar 23 20:00:50 monster startproc: startproc: exit status of pare nt of /usr/bin/postmaster: 1
/var/log/warn:Mar 23 20:10:39 monster startproc: startproc: exit status of pare nt of /usr/bin/postmaster: 1
/var/log/warn:Mar 23 20:19:52 monster startproc: startproc: exit status of pare nt of /usr/bin/postmaster: 1
/var/log/warn:Mar 23 20:21:26 monster startproc: startproc: exit status of pare nt of /usr/bin/postmaster: 1
/var/log/warn:Mar 23 20:35:26 monster startproc: startproc: exit status of pare nt of /usr/bin/postmaster: 1
monster:~ # grep postmaster /var/log/*
/var/log/localmessages:Mar 23 18:02:01 monster startproc: startproc: exit status of parent of /usr/bin/postmaster: 1
/var/log/localmessages:Mar 23 18:02:36 monster startproc: startproc: exit status of parent of /usr/bin/postmaster: 1
/var/log/localmessages:Mar 23 19:59:38 monster startproc: startproc: exit status of parent of /usr/bin/postmaster: 1
/var/log/localmessages:Mar 23 20:00:50 monster startproc: startproc: exit status of parent of /usr/bin/postmaster: 1
/var/log/localmessages:Mar 23 20:10:39 monster startproc: startproc: exit status of parent of /usr/bin/postmaster: 1
/var/log/localmessages:Mar 23 20:19:52 monster startproc: startproc: exit status of parent of /usr/bin/postmaster: 1
/var/log/localmessages:Mar 23 20:21:26 monster startproc: startproc: exit status of parent of /usr/bin/postmaster: 1
/var/log/localmessages:Mar 23 20:35:26 monster startproc: startproc: exit status of parent of /usr/bin/postmaster: 1
/var/log/messages:Mar 23 18:02:01 monster startproc: startproc: exit status of parent of /usr/bin/postmaster: 1
/var/log/messages:Mar 23 18:02:36 monster startproc: startproc: exit status of parent of /usr/bin/postmaster: 1
/var/log/messages:Mar 23 19:59:38 monster startproc: startproc: exit status of parent of /usr/bin/postmaster: 1
/var/log/messages:Mar 23 20:00:50 monster startproc: startproc: exit status of parent of /usr/bin/postmaster: 1
/var/log/messages:Mar 23 20:10:39 monster startproc: startproc: exit status of parent of /usr/bin/postmaster: 1
/var/log/messages:Mar 23 20:19:52 monster startproc: startproc: exit status of parent of /usr/bin/postmaster: 1
/var/log/messages:Mar 23 20:21:26 monster startproc: startproc: exit status of parent of /usr/bin/postmaster: 1
/var/log/messages:Mar 23 20:35:26 monster startproc: startproc: exit status of parent of /usr/bin/postmaster: 1
/var/log/postgresql:Lock file "/var/lib/pgsql/data/postmaster.pid" already exists.
/var/log/postgresql:Is another postmaster (pid 652) running in "/var/lib/pgsql/data"?
/var/log/postgresql:Lock file "/var/lib/pgsql/data/postmaster.pid" already exists.
/var/log/postgresql:Is another postmaster (pid 652) running in "/var/lib/pgsql/data"?
/var/log/postgresql:Lock file "/var/lib/pgsql/data/postmaster.pid" already exists.
/var/log/postgresql:Is another postmaster (pid 652) running in "/var/lib/pgsql/data"?
/var/log/postgresql:Lock file "/var/lib/pgsql/data/postmaster.pid" already exists.
/var/log/postgresql:Is another postmaster (pid 652) running in "/var/lib/pgsql/data"?
/var/log/postgresql:Lock file "/var/lib/pgsql/data/postmaster.pid" already exists.
/var/log/postgresql:Is another postmaster (pid 652) running in "/var/lib/pgsql/data"?
/var/log/postgresql:Lock file "/var/lib/pgsql/data/postmaster.pid" already exists.
/var/log/postgresql:Is another postmaster (pid 652) running in "/var/lib/pgsql/data"?
/var/log/postgresql:Lock file "/var/lib/pgsql/data/postmaster.pid" already exists.
/var/log/postgresql:Is another postmaster (pid 652) running in "/var/lib/pgsql/data"?
/var/log/postgresql:Lock file "/var/lib/pgsql/data/postmaster.pid" already exists.
/var/log/postgresql:Is another postmaster (pid 652) running in "/var/lib/pgsql/data"?
/var/log/postgresql:Lock file "/var/lib/pgsql/data/postmaster.pid" already exists.
/var/log/postgresql:Is another postmaster (pid 652) running in "/var/lib/pgsql/data"?
/var/log/postgresql:Lock file "/var/lib/pgsql/data/postmaster.pid" already exists.
/var/log/postgresql:Is another postmaster (pid 652) running in "/var/lib/pgsql/data"?
/var/log/postgresql:Lock file "/var/lib/pgsql/data/postmaster.pid" already exists.
/var/log/postgresql:Is another postmaster (pid 652) running in "/var/lib/pgsql/data"?
/var/log/postgresql:Lock file "/var/lib/pgsql/data/postmaster.pid" already exists.
/var/log/postgresql:Is another postmaster (pid 652) running in "/var/lib/pgsql/data"?
/var/log/postgresql:Lock file "/var/lib/pgsql/data/postmaster.pid" already exists.
/var/log/postgresql:Is another postmaster (pid 652) running in "/var/lib/pgsql/data"?
/var/log/postgresql:Lock file "/var/lib/pgsql/data/postmaster.pid" already exists.
/var/log/postgresql:Is another postmaster (pid 652) running in "/var/lib/pgsql/data"?
/var/log/postgresql:Lock file "/var/lib/pgsql/data/postmaster.pid" already exists.
/var/log/postgresql:Is another postmaster (pid 652) running in "/var/lib/pgsql/data"?
/var/log/postgresql:Lock file "/var/lib/pgsql/data/postmaster.pid" already exists.
/var/log/postgresql:Is another postmaster (pid 652) running in "/var/lib/pgsql/data"?
/var/log/postgresql:Lock file "/var/lib/pgsql/data/postmaster.pid" already exists.
/var/log/postgresql:Is another postmaster (pid 652) running in "/var/lib/pgsql/data"?
/var/log/postgresql:Lock file "/var/lib/pgsql/data/postmaster.pid" already exists.
/var/log/postgresql:Is another postmaster (pid 652) running in "/var/lib/pgsql/data"?
/var/log/postgresql:Lock file "/var/lib/pgsql/data/postmaster.pid" already exists.
/var/log/postgresql:Is another postmaster (pid 652) running in "/var/lib/pgsql/data"?
/var/log/postgresql:Lock file "/var/lib/pgsql/data/postmaster.pid" already exists.
/var/log/postgresql:Is another postmaster (pid 652) running in "/var/lib/pgsql/data"?
/var/log/postgresql:Lock file "/var/lib/pgsql/data/postmaster.pid" already exists.
/var/log/postgresql:Is another postmaster (pid 652) running in "/var/lib/pgsql/data"?
/var/log/postgresql:Lock file "/var/lib/pgsql/data/postmaster.pid" already exists.
/var/log/postgresql:Is another postmaster (pid 652) running in "/var/lib/pgsql/data"?
/var/log/postgresql:Lock file "/var/lib/pgsql/data/postmaster.pid" already exists.
/var/log/postgresql:Is another postmaster (pid 652) running in "/var/lib/pgsql/data"?
/var/log/postgresql:Lock file "/var/lib/pgsql/data/postmaster.pid" already exists.
/var/log/postgresql:Is another postmaster (pid 652) running in "/var/lib/pgsql/data"?
/var/log/postgresql:Lock file "/var/lib/pgsql/data/postmaster.pid" already exists.
/var/log/postgresql:Is another postmaster (pid 652) running in "/var/lib/pgsql/data"?
/var/log/postgresql:Lock file "/var/lib/pgsql/data/postmaster.pid" already exists.
/var/log/postgresql:Is another postmaster (pid 652) running in "/var/lib/pgsql/data"?
/var/log/postgresql:Lock file "/var/lib/pgsql/data/postmaster.pid" already exists.
/var/log/postgresql:Is another postmaster (pid 652) running in "/var/lib/pgsql/data"?
/var/log/postgresql:Lock file "/var/lib/pgsql/data/postmaster.pid" already exists.
/var/log/postgresql:Is another postmaster (pid 652) running in "/var/lib/pgsql/data"?
/var/log/postgresql:Lock file "/var/lib/pgsql/data/postmaster.pid" already exists.
/var/log/postgresql:Is another postmaster (pid 652) running in "/var/lib/pgsql/data"?
/var/log/warn:Mar 23 18:02:01 monster startproc: startproc: exit status of parent of /usr/bin/postmaster: 1
/var/log/warn:Mar 23 18:02:36 monster startproc: startproc: exit status of parent of /usr/bin/postmaster: 1
/var/log/warn:Mar 23 19:59:38 monster startproc: startproc: exit status of parent of /usr/bin/postmaster: 1
/var/log/warn:Mar 23 20:00:50 monster startproc: startproc: exit status of parent of /usr/bin/postmaster: 1
/var/log/warn:Mar 23 20:10:39 monster startproc: startproc: exit status of parent of /usr/bin/postmaster: 1
/var/log/warn:Mar 23 20:19:52 monster startproc: startproc: exit status of parent of /usr/bin/postmaster: 1
/var/log/warn:Mar 23 20:21:26 monster startproc: startproc: exit status of parent of /usr/bin/postmaster: 1
/var/log/warn:Mar 23 20:35:26 monster startproc: startproc: exit status of parent of /usr/bin/postmaster: 1

[LKH]

Hi,

so auf die Schnelle: der häufigste Fehler ist wohl, dass es die /var/lib/pgsql/data/postmaster.pid noch gibt (mit dem Reset-Schalter runtergefahren? ;)).

Als root ein "rm /var/lib/pgsql/data/postmaster.pid" und ein Fehler wäre weniger ...

Aber zur Kontrolle danach auch mal ein "ps ax | grep postmaster" um sicher zu sein, dass der nicht läuft.

[WillhelmTell]

Also:

"rm /var/lib/pgsql/data/postmaster.pid" habe ich gemacht ..

Jetzt steht im Logfile das:

/var/log/localmessages:Mar 23 18:02:01 monster startproc: startproc: exit status of parent of /usr/bin/postmaster: 1
/var/log/localmessages:Mar 23 18:02:36 monster startproc: startproc: exit status of parent of /usr/bin/postmaster: 1
/var/log/localmessages:Mar 23 19:59:38 monster startproc: startproc: exit status of parent of /usr/bin/postmaster: 1
/var/log/localmessages:Mar 23 20:00:50 monster startproc: startproc: exit status of parent of /usr/bin/postmaster: 1
/var/log/localmessages:Mar 23 20:10:39 monster startproc: startproc: exit status of parent of /usr/bin/postmaster: 1
/var/log/localmessages:Mar 23 20:19:52 monster startproc: startproc: exit status of parent of /usr/bin/postmaster: 1
/var/log/localmessages:Mar 23 20:21:26 monster startproc: startproc: exit status of parent of /usr/bin/postmaster: 1
/var/log/localmessages:Mar 23 20:35:26 monster startproc: startproc: exit status of parent of /usr/bin/postmaster: 1
/var/log/messages:Mar 23 18:02:01 monster startproc: startproc: exit status of parent of /usr/bin/postmaster: 1
/var/log/messages:Mar 23 18:02:36 monster startproc: startproc: exit status of parent of /usr/bin/postmaster: 1
/var/log/messages:Mar 23 19:59:38 monster startproc: startproc: exit status of parent of /usr/bin/postmaster: 1
/var/log/messages:Mar 23 20:00:50 monster startproc: startproc: exit status of parent of /usr/bin/postmaster: 1
/var/log/messages:Mar 23 20:10:39 monster startproc: startproc: exit status of parent of /usr/bin/postmaster: 1
/var/log/messages:Mar 23 20:19:52 monster startproc: startproc: exit status of parent of /usr/bin/postmaster: 1
/var/log/messages:Mar 23 20:21:26 monster startproc: startproc: exit status of parent of /usr/bin/postmaster: 1
/var/log/messages:Mar 23 20:35:26 monster startproc: startproc: exit status of parent of /usr/bin/postmaster: 1
/var/log/postgresql:Lock file "/var/lib/pgsql/data/postmaster.pid" already exists.
/var/log/postgresql:Is another postmaster (pid 652) running in "/var/lib/pgsql/data"?
/var/log/postgresql:Lock file "/var/lib/pgsql/data/postmaster.pid" already exists.
/var/log/postgresql:Is another postmaster (pid 652) running in "/var/lib/pgsql/data"?
/var/log/postgresql:Lock file "/var/lib/pgsql/data/postmaster.pid" already exists.
/var/log/postgresql:Is another postmaster (pid 652) running in "/var/lib/pgsql/data"?
/var/log/postgresql:Lock file "/var/lib/pgsql/data/postmaster.pid" already exists.
/var/log/postgresql:Is another postmaster (pid 652) running in "/var/lib/pgsql/data"?
/var/log/postgresql:Lock file "/var/lib/pgsql/data/postmaster.pid" already exists.
/var/log/postgresql:Is another postmaster (pid 652) running in "/var/lib/pgsql/data"?
/var/log/postgresql:Lock file "/var/lib/pgsql/data/postmaster.pid" already exists.
/var/log/postgresql:Is another postmaster (pid 652) running in "/var/lib/pgsql/data"?
/var/log/postgresql:Lock file "/var/lib/pgsql/data/postmaster.pid" already exists.
/var/log/postgresql:Is another postmaster (pid 652) running in "/var/lib/pgsql/data"?
/var/log/postgresql:Lock file "/var/lib/pgsql/data/postmaster.pid" already exists.
/var/log/postgresql:Is another postmaster (pid 652) running in "/var/lib/pgsql/data"?
/var/log/postgresql:Lock file "/var/lib/pgsql/data/postmaster.pid" already exists.
/var/log/postgresql:Is another postmaster (pid 652) running in "/var/lib/pgsql/data"?
/var/log/postgresql:Lock file "/var/lib/pgsql/data/postmaster.pid" already exists.
/var/log/postgresql:Is another postmaster (pid 652) running in "/var/lib/pgsql/data"?
/var/log/postgresql:Lock file "/var/lib/pgsql/data/postmaster.pid" already exists.
/var/log/postgresql:Is another postmaster (pid 652) running in "/var/lib/pgsql/data"?
/var/log/postgresql:Lock file "/var/lib/pgsql/data/postmaster.pid" already exists.
/var/log/postgresql:Is another postmaster (pid 652) running in "/var/lib/pgsql/data"?
/var/log/postgresql:Lock file "/var/lib/pgsql/data/postmaster.pid" already exists.
/var/log/postgresql:Is another postmaster (pid 652) running in "/var/lib/pgsql/data"?
/var/log/postgresql:Lock file "/var/lib/pgsql/data/postmaster.pid" already exists.
/var/log/postgresql:Is another postmaster (pid 652) running in "/var/lib/pgsql/data"?
/var/log/postgresql:Lock file "/var/lib/pgsql/data/postmaster.pid" already exists.
/var/log/postgresql:Is another postmaster (pid 652) running in "/var/lib/pgsql/data"?
/var/log/postgresql:Lock file "/var/lib/pgsql/data/postmaster.pid" already exists.
/var/log/postgresql:Is another postmaster (pid 652) running in "/var/lib/pgsql/data"?
/var/log/postgresql:Lock file "/var/lib/pgsql/data/postmaster.pid" already exists.
/var/log/postgresql:Is another postmaster (pid 652) running in "/var/lib/pgsql/data"?
/var/log/postgresql:Lock file "/var/lib/pgsql/data/postmaster.pid" already exists.
/var/log/postgresql:Is another postmaster (pid 652) running in "/var/lib/pgsql/data"?
/var/log/postgresql:Lock file "/var/lib/pgsql/data/postmaster.pid" already exists.
/var/log/postgresql:Is another postmaster (pid 652) running in "/var/lib/pgsql/data"?
/var/log/postgresql:Lock file "/var/lib/pgsql/data/postmaster.pid" already exists.
/var/log/postgresql:Is another postmaster (pid 652) running in "/var/lib/pgsql/data"?
/var/log/postgresql:Lock file "/var/lib/pgsql/data/postmaster.pid" already exists.
/var/log/postgresql:Is another postmaster (pid 652) running in "/var/lib/pgsql/data"?
/var/log/postgresql:Lock file "/var/lib/pgsql/data/postmaster.pid" already exists.
/var/log/postgresql:Is another postmaster (pid 652) running in "/var/lib/pgsql/data"?
/var/log/postgresql:Lock file "/var/lib/pgsql/data/postmaster.pid" already exists.
/var/log/postgresql:Is another postmaster (pid 652) running in "/var/lib/pgsql/data"?
/var/log/postgresql:Lock file "/var/lib/pgsql/data/postmaster.pid" already exists.
/var/log/postgresql:Is another postmaster (pid 652) running in "/var/lib/pgsql/data"?
/var/log/postgresql:Lock file "/var/lib/pgsql/data/postmaster.pid" already exists.
/var/log/postgresql:Is another postmaster (pid 652) running in "/var/lib/pgsql/data"?
/var/log/postgresql:Lock file "/var/lib/pgsql/data/postmaster.pid" already exists.
/var/log/postgresql:Is another postmaster (pid 652) running in "/var/lib/pgsql/data"?
/var/log/postgresql:Lock file "/var/lib/pgsql/data/postmaster.pid" already exists.
/var/log/postgresql:Is another postmaster (pid 652) running in "/var/lib/pgsql/data"?
/var/log/postgresql:Lock file "/var/lib/pgsql/data/postmaster.pid" already exists.
/var/log/postgresql:Is another postmaster (pid 652) running in "/var/lib/pgsql/data"?
/var/log/postgresql:Lock file "/var/lib/pgsql/data/postmaster.pid" already exists.
/var/log/postgresql:Is another postmaster (pid 652) running in "/var/lib/pgsql/data"?
/var/log/postgresql:Is another postmaster (pid 652) using "/tmp/.s.PGSQL.5432"?
/var/log/postgresql:/usr/bin/postmaster: cannot create UNIX stream port
/var/log/warn:Mar 23 18:02:01 monster startproc: startproc: exit status of parent of /usr/bin/postmaster: 1
/var/log/warn:Mar 23 18:02:36 monster startproc: startproc: exit status of parent of /usr/bin/postmaster: 1
/var/log/warn:Mar 23 19:59:38 monster startproc: startproc: exit status of parent of /usr/bin/postmaster: 1
/var/log/warn:Mar 23 20:00:50 monster startproc: startproc: exit status of parent of /usr/bin/postmaster: 1
/var/log/warn:Mar 23 20:10:39 monster startproc: startproc: exit status of parent of /usr/bin/postmaster: 1
/var/log/warn:Mar 23 20:19:52 monster startproc: startproc: exit status of parent of /usr/bin/postmaster: 1
/var/log/warn:Mar 23 20:21:26 monster startproc: startproc: exit status of parent of /usr/bin/postmaster: 1
/var/log/warn:Mar 23 20:35:26 monster startproc: startproc: exit status of parent of /usr/bin/postmaster: 1

[himbeere]

Was sagt ps auxww | grep postmaster? Hast Du mal /tmp/.s.PGSQL.5432 gelöscht?

Thomas

[WillhelmTell]

Original geschrieben von himbeere
Was sagt ps auxww | grep postmaster? Hast Du mal /tmp/.s.PGSQL.5432 gelöscht?

Thomas

2538 pts/1 S 0:00 grep postmaster

Hätte ich die /tmp/.s.PGSQL.5432 löschen sollen?

[himbeere]

Hätte ich die /tmp/.s.PGSQL.5432 löschen sollen?
Mach doch mal. Jedenfalls scheint nichts zu laufen im Moment. Kuck nochmal nach ob /var/lib/pgsql/data/postmaster.pid weg ist und dann versuch nochmal zu starten. /var/log/postgresql beobachten!

Thomas

[WillhelmTell]

Original geschrieben von himbeere
Mach doch mal. Jedenfalls scheint nichts zu laufen im Moment. Kuck nochmal nach ob /var/lib/pgsql/data/postmaster.pid weg ist und dann versuch nochmal zu starten. /var/log/postgresql beobachten!

Thomas

Hallo Thomas
Es sieht schon viel besser aus! :-)
Postgresql läuft!

Hier das Logfile:

/var/log/localmessages:Mar 23 18:02:01 monster startproc: startproc: exit status of parent of /usr/bin/postmaster: 1
/var/log/localmessages:Mar 23 18:02:36 monster startproc: startproc: exit status of parent of /usr/bin/postmaster: 1
/var/log/localmessages:Mar 23 19:59:38 monster startproc: startproc: exit status of parent of /usr/bin/postmaster: 1
/var/log/localmessages:Mar 23 20:00:50 monster startproc: startproc: exit status of parent of /usr/bin/postmaster: 1
/var/log/localmessages:Mar 23 20:10:39 monster startproc: startproc: exit status of parent of /usr/bin/postmaster: 1
/var/log/localmessages:Mar 23 20:19:52 monster startproc: startproc: exit status of parent of /usr/bin/postmaster: 1
/var/log/localmessages:Mar 23 20:21:26 monster startproc: startproc: exit status of parent of /usr/bin/postmaster: 1
/var/log/localmessages:Mar 23 20:35:26 monster startproc: startproc: exit status of parent of /usr/bin/postmaster: 1
/var/log/messages:Mar 23 18:02:01 monster startproc: startproc: exit status of parent of /usr/bin/postmaster: 1
/var/log/messages:Mar 23 18:02:36 monster startproc: startproc: exit status of parent of /usr/bin/postmaster: 1
/var/log/messages:Mar 23 19:59:38 monster startproc: startproc: exit status of parent of /usr/bin/postmaster: 1
/var/log/messages:Mar 23 20:00:50 monster startproc: startproc: exit status of parent of /usr/bin/postmaster: 1
/var/log/messages:Mar 23 20:10:39 monster startproc: startproc: exit status of parent of /usr/bin/postmaster: 1
/var/log/messages:Mar 23 20:19:52 monster startproc: startproc: exit status of parent of /usr/bin/postmaster: 1
/var/log/messages:Mar 23 20:21:26 monster startproc: startproc: exit status of parent of /usr/bin/postmaster: 1
/var/log/messages:Mar 23 20:35:26 monster startproc: startproc: exit status of parent of /usr/bin/postmaster: 1
/var/log/postgresql:Lock file "/var/lib/pgsql/data/postmaster.pid" already exists.
/var/log/postgresql:Is another postmaster (pid 652) running in "/var/lib/pgsql/data"?
/var/log/postgresql:Lock file "/var/lib/pgsql/data/postmaster.pid" already exists.
/var/log/postgresql:Is another postmaster (pid 652) running in "/var/lib/pgsql/data"?
/var/log/postgresql:Lock file "/var/lib/pgsql/data/postmaster.pid" already exists.
/var/log/postgresql:Is another postmaster (pid 652) running in "/var/lib/pgsql/data"?
/var/log/postgresql:Lock file "/var/lib/pgsql/data/postmaster.pid" already exists.
/var/log/postgresql:Is another postmaster (pid 652) running in "/var/lib/pgsql/data"?
/var/log/postgresql:Lock file "/var/lib/pgsql/data/postmaster.pid" already exists.
/var/log/postgresql:Is another postmaster (pid 652) running in "/var/lib/pgsql/data"?
/var/log/postgresql:Lock file "/var/lib/pgsql/data/postmaster.pid" already exists.
/var/log/postgresql:Is another postmaster (pid 652) running in "/var/lib/pgsql/data"?
/var/log/postgresql:Lock file "/var/lib/pgsql/data/postmaster.pid" already exists.
/var/log/postgresql:Is another postmaster (pid 652) running in "/var/lib/pgsql/data"?
/var/log/postgresql:Lock file "/var/lib/pgsql/data/postmaster.pid" already exists.
/var/log/postgresql:Is another postmaster (pid 652) running in "/var/lib/pgsql/data"?
/var/log/postgresql:Lock file "/var/lib/pgsql/data/postmaster.pid" already exists.
/var/log/postgresql:Is another postmaster (pid 652) running in "/var/lib/pgsql/data"?
/var/log/postgresql:Lock file "/var/lib/pgsql/data/postmaster.pid" already exists.
/var/log/postgresql:Is another postmaster (pid 652) running in "/var/lib/pgsql/data"?
/var/log/postgresql:Lock file "/var/lib/pgsql/data/postmaster.pid" already exists.
/var/log/postgresql:Is another postmaster (pid 652) running in "/var/lib/pgsql/data"?
/var/log/postgresql:Lock file "/var/lib/pgsql/data/postmaster.pid" already exists.
/var/log/postgresql:Is another postmaster (pid 652) running in "/var/lib/pgsql/data"?
/var/log/postgresql:Lock file "/var/lib/pgsql/data/postmaster.pid" already exists.
/var/log/postgresql:Is another postmaster (pid 652) running in "/var/lib/pgsql/data"?
/var/log/postgresql:Lock file "/var/lib/pgsql/data/postmaster.pid" already exists.
/var/log/postgresql:Is another postmaster (pid 652) running in "/var/lib/pgsql/data"?
/var/log/postgresql:Lock file "/var/lib/pgsql/data/postmaster.pid" already exists.
/var/log/postgresql:Is another postmaster (pid 652) running in "/var/lib/pgsql/data"?
/var/log/postgresql:Lock file "/var/lib/pgsql/data/postmaster.pid" already exists.
/var/log/postgresql:Is another postmaster (pid 652) running in "/var/lib/pgsql/data"?
/var/log/postgresql:Lock file "/var/lib/pgsql/data/postmaster.pid" already exists.
/var/log/postgresql:Is another postmaster (pid 652) running in "/var/lib/pgsql/data"?
/var/log/postgresql:Lock file "/var/lib/pgsql/data/postmaster.pid" already exists.
/var/log/postgresql:Is another postmaster (pid 652) running in "/var/lib/pgsql/data"?
/var/log/postgresql:Lock file "/var/lib/pgsql/data/postmaster.pid" already exists.
/var/log/postgresql:Is another postmaster (pid 652) running in "/var/lib/pgsql/data"?
/var/log/postgresql:Lock file "/var/lib/pgsql/data/postmaster.pid" already exists.
/var/log/postgresql:Is another postmaster (pid 652) running in "/var/lib/pgsql/data"?
/var/log/postgresql:Lock file "/var/lib/pgsql/data/postmaster.pid" already exists.
/var/log/postgresql:Is another postmaster (pid 652) running in "/var/lib/pgsql/data"?
/var/log/postgresql:Lock file "/var/lib/pgsql/data/postmaster.pid" already exists.
/var/log/postgresql:Is another postmaster (pid 652) running in "/var/lib/pgsql/data"?
/var/log/postgresql:Lock file "/var/lib/pgsql/data/postmaster.pid" already exists.
/var/log/postgresql:Is another postmaster (pid 652) running in "/var/lib/pgsql/data"?
/var/log/postgresql:Lock file "/var/lib/pgsql/data/postmaster.pid" already exists.
/var/log/postgresql:Is another postmaster (pid 652) running in "/var/lib/pgsql/data"?
/var/log/postgresql:Lock file "/var/lib/pgsql/data/postmaster.pid" already exists.
/var/log/postgresql:Is another postmaster (pid 652) running in "/var/lib/pgsql/data"?
/var/log/postgresql:Lock file "/var/lib/pgsql/data/postmaster.pid" already exists.
/var/log/postgresql:Is another postmaster (pid 652) running in "/var/lib/pgsql/data"?
/var/log/postgresql:Lock file "/var/lib/pgsql/data/postmaster.pid" already exists.
/var/log/postgresql:Is another postmaster (pid 652) running in "/var/lib/pgsql/data"?
/var/log/postgresql:Lock file "/var/lib/pgsql/data/postmaster.pid" already exists.
/var/log/postgresql:Is another postmaster (pid 652) running in "/var/lib/pgsql/data"?
/var/log/postgresql:Lock file "/var/lib/pgsql/data/postmaster.pid" already exists.
/var/log/postgresql:Is another postmaster (pid 652) running in "/var/lib/pgsql/data"?
/var/log/postgresql:Is another postmaster (pid 652) using "/tmp/.s.PGSQL.5432"?
/var/log/postgresql:/usr/bin/postmaster: cannot create UNIX stream port
/var/log/postgresql:Is another postmaster (pid 652) using "/tmp/.s.PGSQL.5432"?
/var/log/postgresql:/usr/bin/postmaster: cannot create UNIX stream port
/var/log/warn:Mar 23 18:02:01 monster startproc: startproc: exit status of parent of /usr/bin/postmaster: 1
/var/log/warn:Mar 23 18:02:36 monster startproc: startproc: exit status of parent of /usr/bin/postmaster: 1
/var/log/warn:Mar 23 19:59:38 monster startproc: startproc: exit status of parent of /usr/bin/postmaster: 1
/var/log/warn:Mar 23 20:00:50 monster startproc: startproc: exit status of parent of /usr/bin/postmaster: 1
/var/log/warn:Mar 23 20:10:39 monster startproc: startproc: exit status of parent of /usr/bin/postmaster: 1
/var/log/warn:Mar 23 20:19:52 monster startproc: startproc: exit status of parent of /usr/bin/postmaster: 1
/var/log/warn:Mar 23 20:21:26 monster startproc: startproc: exit status of parent of /usr/bin/postmaster: 1
/var/log/warn:Mar 23 20:35:26 monster startproc: startproc: exit status of parent of /usr/bin/postmaster: 1

Nun habe ich noch das Problem, das ich mich nicht per Browser in den Server
einloggen kann.
Es erscheint immer noch die Meldung:
Connection to LDAP Server failed! at /srv/www/start/index.pl line 45

Der LDAP Server läuft jedoch?
Was ist jetzt noch das Problem?

Besten Dank!

[WillhelmTell]

Hier noch zur Kontrolle das:

LDAP Logfile:

/var/log/boot.msg:Unable to contact LDAP Server at localhost: Connection refused
/var/log/boot.omsg:Unable to contact LDAP Server at localhost: Connection refuse d
/var/log/mail:Mar 23 17:19:07 monster postfix/smtpd[4088]: warning: dict_ldap_lo okup: Search error 81: Can't contact LDAP server
/var/log/messages:Mar 21 15:20:25 exchange fetchd.pl[1046]: rebind: error bindin g to LDAP Server: Server encountered an internal error
/var/log/messages:Mar 21 18:21:39 monster fetchd.pl[1142]: rebind: error binding to LDAP Server: Server encountered an internal error
/var/log/warn:Mar 23 17:19:07 monster postfix/smtpd[4088]: warning: dict_ldap_lo okup: Search error 81: Can't contact LDAP server

[himbeere]

Woraus schließt Du denn das postgres läuft? Achso, Du mußt nicht immer das ganze logfile posten. :-)
Mach doch mal tail -f /var/log/postgresql & (dann biste wieder auf der Konsole)
Dann sach mal /etc/init.d/postgresql restart. Was spuckt logfile aus?

Thomas

[WillhelmTell]

Also nun spuck das Logfile folgendes aus:

monster:~ # tail -f /var/log/postgresql &
[1] 4416
monster:~ # DEBUG: shutting down
DEBUG: database system is shut down
DEBUG: database system was shut down at 2004-03-23 22:51:24 CET
DEBUG: checkpoint record is at 0/557A98
DEBUG: redo record is at 0/557A98; undo record is at 0/0; shutdown TRUE
DEBUG: next transaction id: 14113; next oid: 25274
DEBUG: database system is ready
DEBUG: fast shutdown request
DEBUG: shutting down
DEBUG: database system is shut down

[himbeere]

Sieht doch gut aus. Starten tut postgres auch? Hast Du restart gesagt? Reboote doch einfach mal neu (*duck*).

Thomas

[WillhelmTell]

Original geschrieben von himbeere
Sieht doch gut aus. Starten tut postgres auch? Hast Du restart gesagt? Reboote doch einfach mal neu (*duck*).

Thomas

Jepp, sieht wirklich schon viel besser aus .. *Freu*

Reboot, hab ich zwar schon gemacht, aber ich mach es gerne wieder.

Was könnte es sonst noch sein, dass ich mich nicht einloggen kann?

[himbeere]

Naja wenn der ldap server nicht läuft, kannste das, was wir jetzt mit postgres gemacht haben, gleich gut auf ldap anwenden. Ich hau mich jetzt erstmal hin.

bis dann
Thomas

[WillhelmTell]

Original geschrieben von himbeere
Naja wenn der ldap server nicht läuft, kannste das, was wir jetzt mit postgres gemacht haben, gleich gut auf ldap anwenden. Ich hau mich jetzt erstmal hin.

bis dann
Thomas

Besten Dank für Deine Hilfe!

Der LDAP Server meldet beim aufstarten: localhost Connection refused??
Irgendwie läuft er ja doch .. ??

Vieliecht findet sich ja noch jemad der mir dabei helfen kann ..

Auf jedenfall besten Dank für Deine Hilfe.

CU
WillhelmTell