Re: PostgreSQL server not starting.

Hi,

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(dot)srivastava(at)enterprisedb(dot)com]
Sent: Thursday, September 30, 2010 2:30 PM
To: Vishnu S.
Cc: pgsql-general(at)postgresql(dot)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.

Though since you have the initdb successful, you can manually create the
service using pg_ctl command (See:
http://www.postgresql.org/docs/8.4/static/app-pg-ctl.html
<http://www.postgresql.org/docs/8.4/static/app-pg-ctl.html> )

On Sep 30, 2010, at 2:10 PM, Vishnu S. wrote:

Hi,

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(dot)srivastava(at)enterprisedb(dot)com]
Sent: Thursday, September 30, 2010 1:41 PM
To: Vishnu S.
Cc: pgsql-general(at)postgresql(dot)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".

Host :- localhost

Port :- 5432

Database :- postgres

Thanks & Regards,

Vishnu S

--

Regards,

Sachin Srivastava

EnterpriseDB <http://www.enterprisedb.com> , the Enterprise Postgres
<http://www.enterprisedb.com> company.

<install-postgresql.log>

--

Regards,

Sachin Srivastava

EnterpriseDB <http://www.enterprisedb.com> , the Enterprise Postgres
<http://www.enterprisedb.com> company.