error connecting to postgresql by pgadmin
Hi, 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?"
Renji Babu
Import Notes
Reply to msg id not found: badb664a93e01ea41afbebc2fb6a715a2a283b71@postgresql.orgReference msg id not found: badb664a93e01ea41afbebc2fb6a715a2a283b71@postgresql.org
On Fri, Jun 8, 2012 at 5:06 AM, Renji Babu <renjibabu@ymail.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