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

Re: BUG #4172: postgres stops working after restart

From: "Heikki Linnakangas" <heikki(at)enterprisedb(dot)com>
To: "alex" <shaselai(at)yahoo(dot)com>
Cc: <pgsql-bugs(at)postgresql(dot)org>
Subject: Re: BUG #4172: postgres stops working after restart
Date: 2008-05-15 15:21:50
Message-ID: (view raw, whole thread or download thread mbox)
Lists: pgsql-bugs
alex wrote:
> The following bug has been logged online:
> Bug reference:      4172
> Logged by:          alex
> Email address:      shaselai(at)yahoo(dot)com
> PostgreSQL version: 8.3.1
> Operating system:   windows xp
> Description:        postgres stops working after restart
> Details: 
> I installed 8.3.1 fine and the service starts and works fine. However, after
> I restart the computer and opens up pgAdmin3.exe and try to start the
> service again i get error message:
> "Failed to start server pgsql-8.3:Errcode=1069. Check event log for
> details."
> The log folder doesn't show any error problems. When I run the psql.exe on
> the command line i get:
> "psql: 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 using netstat -an and 5432 is not even listed being in
> use/listening. I also tried changing the port in pgadmin to something else
> like 5050  but same error.

Google suggests that errcode 1069 means login problems. Make sure the 
postgres user account is set up properly, the "change password at next 
login" checkbox is not checked etc.

   Heikki Linnakangas

In response to


pgsql-bugs by date

Next:From: John R PierceDate: 2008-05-15 15:32:29
Subject: Re: BUG #4172: postgres stops working after restart
Previous:From: Bob RossiDate: 2008-05-15 15:18:18
Subject: mingw compile error

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