You are not logged in.

Announcement

*** NOTICE: forum.openstreetmap.org is being retired. Please request a category for your community in the new ones as soon as possible using this process, which will allow you to propose your community moderators.
Please create new topics on the new site at community.openstreetmap.org. We expect the migration of data will take a few weeks, you can follow its progress here.***

Pages: 1

#1 2012-08-11 21:09:19

SunCobalt
Member
From: Eislingen
Registered: 2010-01-09
Posts: 3,810

Postgres DB failure

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

Last edited by SunCobalt (2012-08-11 21:11:33)

Thomas

Offline

#2 2012-08-11 21:29:35

SunCobalt
Member
From: Eislingen
Registered: 2010-01-09
Posts: 3,810

Re: Postgres DB failure

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

Thomas

Offline

#3 2012-08-11 22:19:30

maxbe
Member
Registered: 2010-01-19
Posts: 3,255
Website

Re: Postgres DB failure

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

Offline

Pages: 1

Board footer

Powered by FluxBB