Problem with starting Postgres

From: "Reinhard Hnat" <hnat(at)logotronic(dot)co(dot)at>
To: "Postgres Novice" <pgsql-novice(at)postgresql(dot)org>
Subject: Problem with starting Postgres
Date: 2005-07-18 09:49:30
Message-ID: 001201c58b7e$00beeda0$0163a8c0@hnat
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

I am using PG 7.4 I was creating a new Databasecluster. after a first
successful start of postmaster i wanted to stop and start again. pg_ctl
teminated with a message that posmaster won't stop, so i stopped it with -m
immediate. Since then it is not possible to start again. I see the
following:

2005-07-18 11:37:56 LOG: database system shutdown was interrupted at
2005-07-18 11:32:00 CEST
2005-07-18 11:37:56 LOG: checkpoint record is at 0/10
2005-07-18 11:37:56 LOG: redo record is at 0/10; undo record is at 0/10;
shutdown TRUE
2005-07-18 11:37:56 LOG: next transaction ID: 3; next OID: 16384
2005-07-18 11:37:56 LOG: database system was not properly shut down;
automatic recovery in progress
postmaster successfully started
hn(at)mozart:/mnt/ha1/postgresql> 2005-07-18 11:37:56 LOG: redo starts at 0/50
2005-07-18 11:37:56 LOG: record with zero length at 0/74
2005-07-18 11:37:56 LOG: redo done at 0/50

at this point the program stalls.

When i start pgsql i receive the followin message:
FATAL: the database system is starting up
psql: FATAL: the database system is starting up

I have tried many things even deleted the whole database and tried to
recreate it but the result stays the same.
Has anyone any suggestions?

Thanks in advance
r.hnat

Responses

Browse pgsql-novice by date

  From Date Subject
Next Message Tom Lane 2005-07-18 13:29:10 Re: ADD COLUMN damage control
Previous Message Diana Nemirovsky 2005-07-18 06:44:46 ADD COLUMN damage control