From: Craig Ringer <ringerc@ringerc.id.au>
To: Sofer, Yuval <Yuval_Sofer@bmc.com>
Cc: pgsql-admin@postgresql.org <pgsql-admin@postgresql.org>
Cc: Zucker, Yehudit <Yehudit_Zucker@bmc.com>
Subject: Re: Postgres service starts and then stops immediatly
Date: Thu, 11 Aug 2011 20:37:56 +0800
Message-ID: <4E43CD24.1070905@ringerc.id.au> (raw)
In-Reply-To: <2C0926ABD16BB641A8E2F11A5492004229842AFA1F@PHXCCRPRD01.adprod.bmc.com>
References: <2C0926ABD16BB641A8E2F11A5492004229842AFA1F@PHXCCRPRD01.adprod.bmc.com>
On 11/08/2011 6:00 PM, Sofer, Yuval wrote:
>
> Hi,
>
> -We are using Postgres 8.3.7 on Windows
>
> -We cannot start the Postgres service. The windows OS error message is:
>
> "The PostgreSQL Server 8.3 service on Local Computer started then
> stopped.
> Some services stop automatically if they have no work to do, for example,
> the Performance Logs and Alerts service."
>
> -No logs in the postgres log file
>
> -When using pg_ctl, the postgres.exe is starting OK
>
This sounds like permissions. Check and make sure that the "postgres"
user has the rights to write to the data directory, including the log files.
Has anything been changed lately? Restored/deleted/updated? System users
modified? Domain policy changed?
Check the Event Viewer for more information about the failure, see if
there's anything there.
What Windows version are you using?
Why PostgreSQL 8.3.7 when the latest release is 8.3.15? You're missing a
lot of bug fixes.
--
Craig Ringer
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: ringerc@ringerc.id.au, Yuval_Sofer@bmc.com, Yehudit_Zucker@bmc.com
Subject: Re: Postgres service starts and then stops immediatly
In-Reply-To: <4E43CD24.1070905@ringerc.id.au>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox