Thread: BUG #6678: error in connecting to Pgadmin

BUG #6678: error in connecting to Pgadmin

From
renjibabu@ymail.com
Date:
The following bug has been logged on the website:

Bug reference:      6678
Logged by:          Renji
Email address:      renjibabu@ymail.com
PostgreSQL version: 9.1.0
Operating system:   windows 7
Description:=20=20=20=20=20=20=20=20

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:=20

"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

Re: BUG #6678: error in connecting to Pgadmin

From
Craig Ringer
Date:
On 06/08/2012 05:08 PM, renjibabu@ymail.com wrote:
> The following bug has been logged on the website:
>
> Bug reference:      6678
> Logged by:          Renji
> Email address:      renjibabu@ymail.com
> PostgreSQL version: 9.1.0

There's your first problem. Why use such an old release? If you're
reporting a bug, you should test with the latest version.

> Operating system:   windows 7

Windows 7 **WHAT**?

"Windows 7 Professional Service Pack 1 x64" ?

Also, is the machine joined to a corporate domain?

Is there a virus scanner or other "security" software installed?

> 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:

If you do start->run (or hold the windows key and press the R key) then
enter "services.msc", does the PostgreSQL service show up as started there?

If you examine the PostgreSQL error logs in the pg_log directory under
the PostgreSQL data directory (by default, inside the PostgreSQL program
install directory in program files) are there any messages there? If
there are, paste them.

Examine the windows Event Viewer (you can find it in the Start Menu by
searching for Event Viewer) do you see anything related to the
PostgreSQL service? Search for "postgres".

In the process list in Proces Explorer or Task Manager, does the
"postgres.exe" process appear? There should be several of them.

--
Craig Ringer