IIRC, you cannot state runservice runservice -N "....." from commandline. just try pg_ctl -D ....
_____ From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of George Younan Sent: Wednesday, February 27, 2008 10:08 PM To: pgsql-general@postgresql.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
