Re: Cannot start DB system

From: "Magnus Hagander" <mha(at)sollentuna(dot)net>
To: "Tan Chen Yee" <tancy(at)gussmanntech(dot)com>, <pgsql-general(at)postgresql(dot)org>
Subject: Re: Cannot start DB system
Date: 2005-07-21 07:36:00
Message-ID: 6BCB9D8A16AC4241919521715F4D8BCE6C77AA@algol.sollentuna.se
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

> All,
>
> I have postgreSQL 8.0 on winXP. This morning at 7:59am, the
> db system could not start.
> I looked at the pg_log. Started from yesterday 1:30pm, all
> log files have this line:
>
> database system was not properly shut down; automatic
> recovery in progress
>
> Then, I restarted the PC several times, I did not see any new
> log in pg_log folder.

Do you get anything in the eventlog?

> 2. Go to command prompt, typed psql -h 127.0.0.1 Postgres
> template1, I saw :
>
> psql: could not connect to server: Connection refused
> (0x0000274D/10061)
> Is the server running on host "127.0.0.1" and accepting
> TCP/IP connections on port 5432?
>
> If the db system is crashed, how do I fix it ? Any help is
> really appreciated.

That's pretty typical of the server not being started :-)

//Magnus

Browse pgsql-general by date

  From Date Subject
Next Message Andrus 2005-07-21 07:37:43 Postgres terminates on first connecton
Previous Message Jamie Deppeler 2005-07-21 04:38:51 Re: [HACKERS] No user being created during initdb for OS X