[GENERAL] 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
Re: [GENERAL] postgresql-9.0 service starting problem
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 r...@iol.ie -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
Re: [GENERAL] postgresql-9.0 service starting problem
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: [GENERAL] postgresql-9.0 service starting problem
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 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 > r...@iol.ie >