x

Postgres DB failure

  1. Postgres DB failure · SunCobalt (Gast) · 11.08.2012 21:09 · [flux]

    Hallo,

    ohne das ich an Postgres rumgefummelt habe, startet Postgres nicht mehr. Kann mir jemand helfen?

    thomas@suncobalt:~$ sudo /etc/init.d/postgresql restart
    Restarting PostgreSQL 9.0 database server: mainUse of uninitialized value $logsize in numeric gt (>) at /usr/bin/pg_ctlcluster line 215. Use of uninitialized value $logsize in numeric gt (>) at /usr/bin/pg_ctlcluster line 215. Use of uninitialized value $logsize in numeric gt (>) at /usr/bin/pg_ctlcluster line 215. Use of uninitialized value $logsize in numeric gt (>) at /usr/bin/pg_ctlcluster line 215. Use of uninitialized value $logsize in numeric gt (>) at /usr/bin/pg_ctlcluster line 215. Use of uninitialized value $logsize in numeric gt (>) at /usr/bin/pg_ctlcluster line 215. Use of uninitialized value $logsize in numeric gt (>) at /usr/bin/pg_ctlcluster line 215. Use of uninitialized value $logsize in numeric gt (>) at /usr/bin/pg_ctlcluster line 215. Use of uninitialized value $logsize in numeric gt (>) at /usr/bin/pg_ctlcluster line 215. Use of uninitialized value $logsize in numeric gt (>) at /usr/bin/pg_ctlcluster line 215. Use of uninitialized value $logsize in numeric gt (>) at /usr/bin/pg_ctlcluster line 215. Use of uninitialized value $logsize in numeric gt (>) at /usr/bin/pg_ctlcluster line 215. Use of uninitialized value $logsize in numeric gt (>) at /usr/bin/pg_ctlcluster line 215. Use of uninitialized value $logsize in numeric gt (>) at /usr/bin/pg_ctlcluster line 215. Use of uninitialized value $logsize in numeric gt (>) at /usr/bin/pg_ctlcluster line 215. Use of uninitialized value $logsize in numeric gt (>) at /usr/bin/pg_ctlcluster line 215. Use of uninitialized value $logsize in numeric gt (>) at /usr/bin/pg_ctlcluster line 215. Use of uninitialized value $logsize in numeric gt (>) at /usr/bin/pg_ctlcluster line 215. Use of uninitialized value $logsize in numeric gt (>) at /usr/bin/pg_ctlcluster line 215. Use of uninitialized value $logsize in numeric gt (>) at /usr/bin/pg_ctlcluster line 215. Use of uninitialized value $logsize in numeric gt (>) at /usr/bin/pg_ctlcluster line 215. Use of uninitialized value $logsize in numeric gt (>) at /usr/bin/pg_ctlcluster line 215. Use of uninitialized value $logsize in numeric gt (>) at /usr/bin/pg_ctlcluster line 215. Use of uninitialized value $logsize in numeric gt (>) at /usr/bin/pg_ctlcluster line 215. Use of uninitialized value $logsize in numeric gt (>) at /usr/bin/pg_ctlcluster line 215. Use of uninitialized value $logsize in numeric gt (>) at /usr/bin/pg_ctlcluster line 215. Use of uninitialized value $logsize in numeric gt (>) at /usr/bin/pg_ctlcluster line 215. Use of uninitialized value $logsize in numeric gt (>) at /usr/bin/pg_ctlcluster line 215. Use of uninitialized value $logsize in numeric gt (>) at /usr/bin/pg_ctlcluster line 215. Use of uninitialized value $logsize in numeric gt (>) at /usr/bin/pg_ctlcluster line 215. Use of uninitialized value $logsize in numeric gt (>) at /usr/bin/pg_ctlcluster line 215. Use of uninitialized value $logsize in numeric gt (>) at /usr/bin/pg_ctlcluster line 215. Use of uninitialized value $logsize in numeric gt (>) at /usr/bin/pg_ctlcluster line 215. Use of uninitialized value $logsize in numeric gt (>) at /usr/bin/pg_ctlcluster line 215. Use of uninitialized value $logsize in numeric gt (>) at /usr/bin/pg_ctlcluster line 215. Use of uninitialized value $logsize in numeric gt (>) at /usr/bin/pg_ctlcluster line 215. Use of uninitialized value $logsize in numeric gt (>) at /usr/bin/pg_ctlcluster line 215. Use of uninitialized value $logsize in numeric gt (>) at /usr/bin/pg_ctlcluster line 215. Use of uninitialized value $logsize in numeric gt (>) at /usr/bin/pg_ctlcluster line 215. Use of uninitialized value $logsize in numeric gt (>) at /usr/bin/pg_ctlcluster line 215. Use of uninitialized value $logsize in numeric gt (>) at /usr/bin/pg_ctlcluster line 215. Use of uninitialized value $logsize in numeric gt (>) at /usr/bin/pg_ctlcluster line 215. Use of uninitialized value $logsize in numeric gt (>) at /usr/bin/pg_ctlcluster line 215. Use of uninitialized value $logsize in numeric gt (>) at /usr/bin/pg_ctlcluster line 215. Use of uninitialized value $logsize in numeric gt (>) at /usr/bin/pg_ctlcluster line 215. Use of uninitialized value $logsize in numeric gt (>) at /usr/bin/pg_ctlcluster line 215. Use of uninitialized value $logsize in numeric gt (>) at /usr/bin/pg_ctlcluster line 215. Use of uninitialized value $logsize in numeric gt (>) at /usr/bin/pg_ctlcluster line 215. Use of uninitialized value $logsize in numeric gt (>) at /usr/bin/pg_ctlcluster line 215. Use of uninitialized value $logsize in numeric gt (>) at /usr/bin/pg_ctlcluster line 215. Use of uninitialized value $logsize in numeric gt (>) at /usr/bin/pg_ctlcluster line 215. Use of uninitialized value $logsize in numeric gt (>) at /usr/bin/pg_ctlcluster line 215. Use of uninitialized value $logsize in numeric gt (>) at /usr/bin/pg_ctlcluster line 215. Use of uninitialized value $logsize in numeric gt (>) at /usr/bin/pg_ctlcluster line 215. Use of uninitialized value $logsize in numeric gt (>) at /usr/bin/pg_ctlcluster line 215. Use of uninitialized value $logsize in numeric gt (>) at /usr/bin/pg_ctlcluster line 215. Use of uninitialized value $logsize in numeric gt (>) at /usr/bin/pg_ctlcluster line 215. Use of uninitialized value $logsize in numeric gt (>) at /usr/bin/pg_ctlcluster line 215. Use of uninitialized value $logsize in numeric gt (>) at /usr/bin/pg_ctlcluster line 215. Use of uninitialized value $logsize in numeric gt (>) at /usr/bin/pg_ctlcluster line 215. The PostgreSQL server failed to start. Please check the log output. ... failed!
    failed!

    Im Log steht nix

    thomas@suncobalt:~$ sudo tail /var/log/postgresql/postgresql-9.0-main.log
    2012-08-11 16:19:07 CEST WARNUNG: pgstat wait timeout
    2012-08-11 16:19:12 CEST WARNUNG: pgstat wait timeout
    2012-08-11 16:19:17 CEST WARNUNG: pgstat wait timeout
    2012-08-11 16:19:17 CEST WARNUNG: pgstat wait timeout
    2012-08-11 16:19:22 CEST WARNUNG: pgstat wait timeout
    2012-08-11 18:19:32 CEST LOG: schnelles Herunterfahren verlangt
    2012-08-11 18:19:32 CEST LOG: etwaige aktive Transaktionen werden abgebrochen
    2012-08-11 18:19:32 CEST LOG: Autovacuum-Launcher f?hrt herunter
    2012-08-11 18:19:32 CEST LOG: fahre herunter
    2012-08-11 18:19:32 CEST LOG: Datenbanksystem ist heruntergefahren

    • Re: Postgres DB failure · SunCobalt (Gast) · 11.08.2012 21:29 · [flux]

      Sch.... wenn ich die DB mit sudo -u postgres /usr/lib/postgresql/9.0/bin/postmaster -D /etc/postgresql/9.0/main/ starte gehts. Ich komme mir fast vor wie bei MS Windows

    • Re: Postgres DB failure · maxbe (Gast) · 11.08.2012 22:19 · [flux]

      In der Gegend wird das Logfile angesehen, bei mir steht zumindest was von "$info{'logfile'}" (ich kann es nur auf 8.3 und 8.4 testen)

      Ich kann bei mir fast (nur die Zeile ist bei mir 235) die gleiche Fehlermeldung erzeugen, indem ich den Zugriff auf das Verzeichnis "/var/log/postgresql" verhindere. Das Schreiben zu verhindern reichte nicht, ich musste auch verhinden, dass dort gelesen werden kann.

      Schau mal nach, ob das Logverzeichnis existiert und ob der User oder die Gruppe "postgres" da drauf darf.

      Grüße, Max