Re: Cannot start DB system - Mailing list pgsql-general

From Magnus Hagander
Subject Re: Cannot start DB system
Date
Msg-id 6BCB9D8A16AC4241919521715F4D8BCE6C77AA@algol.sollentuna.se
Whole thread Raw
In response to Cannot start DB system  ("Tan Chen Yee" <tancy@gussmanntech.com>)
List 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

pgsql-general by date:

Previous
From: Jamie Deppeler
Date:
Subject: Re: [HACKERS] No user being created during initdb for OS X
Next
From: "vinita bansal"
Date:
Subject: Re: RAMFS with Postgres