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
