Re: PostgreSQL server not starting. - Mailing list pgsql-general

From Sachin Srivastava
Subject Re: PostgreSQL server not starting.
Date
Msg-id E676D646-B9D2-4660-A42A-166C3937D0C3@enterprisedb.com
Whole thread Raw
In response to Slony-I installation Help  ("Vishnu S." <vishnu.s@nestgroup.net>)
Responses Re: PostgreSQL server not starting.  ("Vishnu S." <vishnu.s@nestgroup.net>)
List pgsql-general
[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)

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.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”.
 
Host :- localhost
Port :- 5432
Database :- postgres
 
 
 
 
Thanks & Regards,
Vishnu S
 
 
--
Regards,
Sachin Srivastava
 
<install-postgresql.log>

--
Regards,
Sachin Srivastava

pgsql-general by date:

Previous
From: Dharmendra Goyal
Date:
Subject: Re: PostgreSQL 9.0 (x86-64) and Windows 7 (x86-64) - Unable to install
Next
From: Vincenzo Romano
Date:
Subject: [9.0] On temporary tables