Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-novice by date

Next:From: Tom LaneDate: 2005-07-18 13:29:10
Subject: Re: ADD COLUMN damage control
Previous:From: Diana NemirovskyDate: 2005-07-18 06:44:46
Subject: ADD COLUMN damage control

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group