On starting the server using pg_ctl command the following message is shown.
server starting
C:\Program Files\PostgreSQL\8.4\bin>2010-09-30 14:36:07 ISTLOG: could not create file "postmaster.opts": Permission denied.
Thanks & Regards,
Vishnu S
From: Sachin Srivastava [mailto:sachin.srivastava@enterprisedb.com] Sent: Thursday, September 30, 2010 2:30 PM To: Vishnu S. Cc: pgsql-general@postgresql.org Subject: Re: PostgreSQL server not starting.
[Please keep the thread on the mailing list]
From the logs, the initdb is successful but there were some error while creating the postgres service. I believe you are not using the latest 8.4.4 installer as that installer has some detailed logging which is helpful in realizing where exactly is the problem.
Please find the attached PostgreSQL installation log file.
I have used Uninstaller to uninstall the PostgreSQL and then the data directory is removed manually.
Thanks & Regards,
Vishnu S
From:Sachin Srivastava [mailto:sachin.srivastava@enterprisedb.com] Sent:Thursday, September 30, 2010 1:41 PM To:Vishnu S. Cc:pgsql-general@postgresql.org Subject:Re: PostgreSQL server not starting.
Can you send the installation log (%TEMP%\install-postgresql.log)?
In case, Have you used the uninstaller to uninstall the previous instance or manually removed the directories?
On Sep 30, 2010, at 12:53 PM, Vishnu S. wrote:
Hi,
I have uninstalled the PostgreSQL 8.4 and removed the related directories from the system. Again I have installed the PostgreSQL 8.4 on the same folder. Now the PostgreSQL server is not starting. When I tried to start the postgreSQL service from the Windows Service manager, the following message is shown.
“The PostgreSQL Server 8.4 service on Local Computer started and then stopped. Some services stop automatically if they have no work to do, for example, the Performance Logs and Alerts service”.