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

Re: Can't start Postgres anymore

From: "Gevik Babakhani" <pgdev(at)xs4all(dot)nl>
To: "'George Younan'" <georgesamb(at)hotmail(dot)com>, <pgsql-general(at)postgresql(dot)org>
Subject: Re: Can't start Postgres anymore
Date: 2008-02-28 00:29:43
Message-ID: 003f01c879a1$03c29b00$0a01a8c0@gevmus (view raw or flat)
Thread:
Lists: pgsql-general
IIRC, you cannot state runservice runservice -N "....." from commandline.
just try pg_ctl -D ....


  _____  

From: pgsql-general-owner(at)postgresql(dot)org
[mailto:pgsql-general-owner(at)postgresql(dot)org] On Behalf Of George Younan
Sent: Wednesday, February 27, 2008 10:08 PM
To: pgsql-general(at)postgresql(dot)org
Subject: [GENERAL] Can't start Postgres anymore


Hallo,
 
I have Postgres installed as a service on Windows xp pro. It has been
working fine but suddenly i couldn't start it anymore. I looked in different
forums for a similar problem but didn't find any solution sofar. So any help
is very appreciated. one more thing to say is that i am a beginner with
Postgres and don't have much administrative experience...
As i said above, i can't start my Postgres anymore. I always get the error
message "could not connect to server: Connection refused
(0x0000274D/10061)Is the server running on host "???" and accepting TCP/IP
connections on port 5432?". 
I checked if the service is running, but it wasn't running. I tried to start
ist but i couldn't. Doing this from the console i got the following error:
"C:\Programme\PostgreSQL\8.1\bin>pg_ctl.exe runservice -N "pgsql-8.1" -D
"C:\Programme\PostgreSQL\8.1\data\"
pg_ctl: could not start service "pgsql-8.1": error code 1063"
 
 I chekced postgres.conf and the configuration is as follows:
    # - Connection Settings -
    listen_addresses = 'localhost'        
    port = 5432
    max_connections = 100
 
The last log file is:
2008-02-08 07:40:38 LOG:  could not connect socket for statistics collector:
Es konnte keine Verbindung hergestellt werden, da der Zielcomputer die
Verbindung verweigerte.
 

2008-02-08 07:40:38 LOG:  disabling statistics collector for lack of working
socket
2008-02-08 07:40:38 WARNING:  autovacuum not started because of
misconfiguration
2008-02-08 07:40:38 HINT:  Enable options "stats_start_collector" and
"stats_row_level".
2008-02-08 07:40:40 LOG:  database system was shut down at 2008-02-08
07:37:57 Westeuropäische Normalzeit
2008-02-08 07:40:40 LOG:  checkpoint record is at 0/45AE50
2008-02-08 07:40:40 LOG:  redo record is at 0/45AE50; undo record is at 0/0;
shutdown TRUE
2008-02-08 07:40:40 LOG:  next transaction ID: 5100; next OID: 16515
2008-02-08 07:40:40 LOG:  next MultiXactId: 1; next MultiXactOffset: 0
2008-02-08 07:40:41 LOG:  database system is ready
2008-02-08 07:40:41 LOG:  transaction ID wrap limit is 2147484148, limited
by database "postgres"



 I'm using Zonealarm firewall but Postgres is authorized on 127.0.0.1:5432.
It's been working fine for the last month since installtion and i didn't
change any configuration. I stopped both zonealarm and the windows firewall
but still success, so i guess it's not a firewall problem.

 I tried to ping the server using "ping 127.0.0.1" which was successful.

 I tried to connect to the host with telnet using "telnet 127.0.0.1 5432"
but i couldn't connect.
 
anyone has a suggestion what can i do to get it working again. I dont want
to lose the data stored on it!
 
thanks in advance
 
George
 

In response to

pgsql-general by date

Next:From: shadrackDate: 2008-02-28 00:59:07
Subject: beginner postgis question lat/lon
Previous:From: Klint GoreDate: 2008-02-28 00:12:18
Subject: Re: How to monitor the progress of a stored procedure?

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