Thread: Can't start Postgres anymore

---

From: pgsql-general-owner@postgresql.org [mailto:pgsql-general-owner@postgresql.org] 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

 

On Wed, Feb 27, 2008 at 4:08 PM, George Younan <georgesamb@hotmail.com> wrote:
> 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 highly doubt you have any data loss.  This line makes me suspect the
firewall:
> 2008-02-08 07:40:38 LOG:  disabling statistics collector for lack of working
> socket

Also the log suggests the database is running:
> 2008-02-08 07:40:41 LOG:  database system is ready

ISTM the problem is basically a connection issue.  Try changing
listen_addresses = 'localhost'
to
listen_addresses = '*'

(this will allow postgresql to serve connections from any interface on
the box).   Also try as Gevik suggested running pg_ctl directly.

merlin

On Thu, Feb 28, 2008 at 08:38:26AM -0500, Merlin Moncure wrote:
>
> >  I'm using Zonealarm firewall but Postgres is authorized on 127.0.0.1:5432.

Sorry, I missed this in the OP.  But I've had people tell me that Zonealarm
causes them problems even if it's completely turned off.  One person told me
that he had to uninstall it to get pg_dump to work properly.  Dunno if that
helps -- I'm no windows guy.

A