Cannot start DB system

Started by Tan Chen Yeeover 20 years ago2 messagesgeneral
Jump to latest
#1Tan Chen Yee
tancy@gussmanntech.com

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.
Thus, I think the db system might be crashed or cannot funtion at all. I
tried two things:

1. Go to command prompt, typed net start -pgsql8.0, I saw :

The PostgreSQL Database Server 8.0 service is starting.
The PostgreSQL Database Server 8.0 service could not be started.

The service did not report an error.

More help is available by typing NET HELPMSG 3534.

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.

Thanks !

Tan Chen Yee

#2Magnus Hagander
magnus@hagander.net
In reply to: Tan Chen Yee (#1)
Re: Cannot start DB system

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