CODEWITHSUNDEEP
installationpostgresql-9.1
Ted1391
Ted1391

Reputation: 139

PostgreSQL first time install and attempt to connect

I just installed postgresql-9.1.4-1-windows-x64 on a Windows 7 64 bit machine. I'm having trouble starting the service and connecting to a database. After a successful installation I've tried the following based on similar postings.

1) Looked for "Start Server" under Start > All Programs > PostreSQL 9.1 and could not find it.

2) Tried starting the server from the command line

pg_ctl.exe -D "C:\Program Files\PostgreSQL\9.1\bin\data"

This gave me the error:

could not create lock file 'postmaster.pid': Permission denied

I have administrative rights, and there is not postmaster.pid file either in the bin or data directories.

3) Next I tried starting the Service from Admistrative Tools by right clicking on the postgresql-9.1.4-1-windows-x64 Service and selecting Start. I received the message:

The postgresql-9.1.4-1-windows-x64 Service on local computer started and stopped. Some services stop automatically if they are not in use by other services or programs.

The Event Viewer showed the error as Timed out waiting for server startup

4) I figured there the data in the data directory was probably and initial database, but just in case I ran "initdb" and got:

If you want to create a new database system either remove or empty the directory c:\program files\postgreSql/9.1/data or run initdb with an argument other than c:\program files\postgreSql/9.1/data

4) And just for fun I Started pgAdminIII, right clicked on "PostreSQL 9.1(localhost:5432)", selected Connect, entered password, and got:

could not connect to server: Connection refused (0x0000274D/10061) Is the server running on host "localhost" (::1) and accepting TCP/IP connections on port 5432?

Does anybody have a suggestion?

Thanks.

Upvotes: 1

Views: 3264

Answers (1)

greg
greg

Reputation: 3505

«"could not create lock file 'postmaster.pid': Permission denied"»

Do not look any further, Postgres cannot start if it can't create this temp file. If it is not created, you evidently cannot find it if you look for it on the disk. Your DATA directory has been created so no need to re run initdb again and if you try to use pgadmin it complains that it cannot connect to Pg -- which is not running.

I am not familiar with windows but found out where postmaster.pid is to be created you will probably find out why Postgres cannot create this file.

Hope it helps.

Upvotes: 2

Related Questions