Обсуждение: postgresql-9.0 service starting problem

Поиск
Список
Период
Сортировка

postgresql-9.0 service starting problem

От
Kalai R
Дата:
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

Re: postgresql-9.0 service starting problem

От
Raymond O'Donnell
Дата:
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

Re: postgresql-9.0 service starting problem

От
Harald Armin Massa
Дата:
Kalai,
 
"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

Re: postgresql-9.0 service starting problem

От
Kalai R
Дата:
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:
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