postgresql.conf & postgresql.conf.sample

I installed postgres on my Win 7 machine using the distribution provided by EnterpriseDB. I am trying to run it with pgAdminIII on the same machine (connecting to localhost).

When trying to connect from pgAdminIII, an error message says:
"Server doesn't listen
The server doesn't accept connections: the connection library reports 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? "

Other documentation says that the listen connection is specified in a postgresql.conf file. There is a postgresql.conf.sample file but no postgresql.conf file. Should there be one, and in what folder does it belong? The Postgresql.org documentation describes locations only in Linux.

Thanks for your help,

Phil

Was the installation completed successfully?
postgresql.conf should be exists in data directory you selected..

No, there was an error message about something not having proper permissions. Sorry, I had forgotten about that.

Should I repeat the installation, or just edit postgresql.conf.sample and copy to postgresql.conf in the same directory?

This message was edited 1 time. Last update was at 12 May 2010 10:05:50

Can you please provide the log file generated by the installer?
It can be found under %TEMP% directory with the name - install-postgres.log.

Which version of PostgreSQL are you trying to install?

Version 8.4.3-1

Log file is attached. Thanks for your help!

Logs suggest that, it installed well, but the server did not start for some reason.

Would you give us some more details?
- Is any anti-virus installed on your system?
- Is postgresql-8.4 service running?
i.e. sc query postgresql-8.4 (Use this command on the command-prompt)

The Service State is STOPPED

For AntiVirus I have AVG Free Edition version 9.0.819

I went to the Windows Control Panel > Component Services

The postgresql service is listed for Automatic startup.

I attempted to start it manually and failed with error 1053 saying Windows failed to start the service

the Windows logon for this service is now set to .\postgres (password unknown)

I am thinking of checking the button to make it the "Local User Account" instead. The only client I want to use is pgAdminIII on the same machine.

PG is now running and connecting to pgAdminIII

I took the step described earlier and set the Win 7 login to "Local User Account"

Case closed.

Thanks for your help!