Received: from maia.hub.org (maia-2.hub.org [200.46.204.251]) by mail.postgresql.org (Postfix) with ESMTP id 88517B5DBDA for ; Thu, 11 Aug 2011 09:38:12 -0300 (ADT) Received: from mail.postgresql.org ([200.46.204.86]) by maia.hub.org (mx1.hub.org [200.46.204.251]) (amavisd-maia, port 10024) with ESMTP id 19932-07 for ; Thu, 11 Aug 2011 12:38:06 +0000 (UTC) X-Greylist: from auto-whitelisted by SQLgrey-1.7.6 Received: from mail-vx0-f174.google.com (mail-vx0-f174.google.com [209.85.220.174]) by mail.postgresql.org (Postfix) with ESMTP id 85081B5DBD6 for ; Thu, 11 Aug 2011 09:38:04 -0300 (ADT) Received: by vxi9 with SMTP id 9so1563352vxi.19 for ; Thu, 11 Aug 2011 05:38:05 -0700 (PDT) Received: by 10.52.29.42 with SMTP id g10mr9892437vdh.36.1313066284790; Thu, 11 Aug 2011 05:38:04 -0700 (PDT) Received: from [10.1.1.8] (124-169-181-228.dyn.iinet.net.au [124.169.181.228]) by mx.google.com with ESMTPS id o18sm891658vcu.4.2011.08.11.05.38.01 (version=SSLv3 cipher=OTHER); Thu, 11 Aug 2011 05:38:04 -0700 (PDT) Message-ID: <4E43CD24.1070905@ringerc.id.au> Date: Thu, 11 Aug 2011 20:37:56 +0800 From: Craig Ringer User-Agent: Mozilla/5.0 (Windows NT 6.1; WOW64; rv:5.0) Gecko/20110624 Thunderbird/5.0 MIME-Version: 1.0 To: "Sofer, Yuval" CC: "pgsql-admin@postgresql.org" , "Zucker, Yehudit" Subject: Re: Postgres service starts and then stops immediatly References: <2C0926ABD16BB641A8E2F11A5492004229842AFA1F@PHXCCRPRD01.adprod.bmc.com> In-Reply-To: <2C0926ABD16BB641A8E2F11A5492004229842AFA1F@PHXCCRPRD01.adprod.bmc.com> Content-Type: multipart/alternative; boundary="------------000703040505020000020801" X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=-1.899 tagged_above=-10 required=5 tests=BAYES_00=-1.9, HTML_MESSAGE=0.001 X-Spam-Level: X-Archive-Number: 201108/98 X-Sequence-Number: 38085 This is a multi-part message in MIME format. --------------000703040505020000020801 Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit 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 --------------000703040505020000020801 Content-Type: text/html; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit 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
--------------000703040505020000020801--