Thread: postgresql-9.0 service starting problem
Hi,
I am using Windows XP. When I have installed PostgreSQL 9.0.3, the service didn't start automatically. In the "Computer Management" I explicitly start "postgresql-9.0" service, the service didn't start and following message displayed
"The postgresql-9.0 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"
What is the problem and How to solve it?
Thanks and Regards
kalai
On 29/03/2011 14:59, Kalai R wrote: > Hi, > I am using Windows XP. When I have installed PostgreSQL 9.0.3, the > service didn't start automatically. In the "Computer Management" I > explicitly start "postgresql-9.0" service, the service didn't start and > following message displayed > "The postgresql-9.0 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" > What is the problem and How to solve it? Sounds like there was a problem.... look in the Postgres log, in the Windows event log, or both. Ray. -- Raymond O'Donnell :: Galway :: Ireland rod@iol.ie
Kalai,
--
Harald Armin Massa www.2ndQuadrant.com
PostgreSQL Training, Services and Support
2ndQuadrant Deutschland GmbH
GF: Harald Armin Massa
Amtsgericht Stuttgart, HRB 736399
"The postgresql-9.0 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"
most likely problem are unavailable ressources, as in:
- PostgreSQL cannot access its data directory (because of changed file/directory permissions)
- PostgreSQL cannot open its port for communication (because of other running PostgreSQL / because of zealous firewalls)
or wrong configuration files, i.e. errors in pg_hba.conf or postgresql.conf.
Start the eventview application and check for entries in the application log.
Best wishes
Harald
--
Harald Armin Massa www.2ndQuadrant.com
PostgreSQL Training, Services and Support
2ndQuadrant Deutschland GmbH
GF: Harald Armin Massa
Amtsgericht Stuttgart, HRB 736399
Thanks to all.
I found the wrong configuration in pg_hba.conf. The problem is solved.
On Tue, Mar 29, 2011 at 8:02 PM, Raymond O'Donnell <rod@iol.ie> wrote:
Sounds like there was a problem.... look in the Postgres log, in the Windows event log, or both.On 29/03/2011 14:59, Kalai R wrote:Hi,
I am using Windows XP. When I have installed PostgreSQL 9.0.3, the
service didn't start automatically. In the "Computer Management" I
explicitly start "postgresql-9.0" service, the service didn't start and
following message displayed
"The postgresql-9.0 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"
What is the problem and How to solve it?
Ray.
--
Raymond O'Donnell :: Galway :: Ireland
rod@iol.ie