Re: error connecting to postgresql by pgadmin

On Fri, Jun 8, 2012 at 5:06 AM, Renji Babu <renjibabu(at)ymail(dot)com> wrote:
> I have installed PostgreSQL 9.1 on windows 7 and I am unable to connect
> to the database after I restart the machine.
>
> When I first installed postgres from pgadmin III, Service started and
> database also got connected.
>
> But when I shutdown and tried to start the service again, it is showing as
> the service is connected and if I try to connect to database it's giving the
> following message:
>
> "could not connect to server: Connection refused (0x0000274D/10061) Is the
> server running on host "127.0.0.1" and accepting TCP/IP connections on port
> 5432?"

I'd check the PostgreSQL log files, if any, and the Windows event log
for errors.

--
Robert Haas
EnterpriseDB: http://www.enterprisedb.com
The Enterprise PostgreSQL Company