FAQ
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

Please help,
Thanks,


Yuval Sofer
BMC Software
CTM&D Business Unit
DBA Team
972-52-4286-282
yuval_sofer@bmc.com

Search Discussions

  • Craig Ringer at Aug 11, 2011 at 12:38 pm

    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
  • Igor Neyman at Aug 11, 2011 at 2:06 pm
    From: Sofer, Yuval
    Sent: Thursday, August 11, 2011 6:01 AM
    To: pgsql-admin@postgresql.org
    Cc: Zucker, Yehudit
    Subject: Postgres service starts and then stops immediatly

    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

    Please help,
    Thanks,


    Yuval Sofer
    BMC Software
    CTM&D Business Unit
    DBA Team
    972-52-4286-282
    yuval_sofer@bmc.com


    Yuval,

    Using pg_ctl, did you try to start PG as a service?
    e.g.:

    C:/PostgreSQL/8.4/bin/pg_ctl.exe runservice -N "PostgreSQL" -D
    "C:/PostgreSQL/8.4/data" -w


    Could it be that account used to start PG service doesn't have
    privileges to "run as a service"?
    Check in "Local Security Settings" under "Local Policies"/"User Rights
    Assignments" - make sure that "Log on as a service" granted to the
    account specified in PG service properties.

    Regards,
    Igor Neyman

Related Discussions

Discussion Navigation
viewthread | post
Discussion Overview
grouppgsql-admin @
categoriespostgresql
postedAug 11, '11 at 10:00a
activeAug 11, '11 at 2:06p
posts3
users3
websitepostgresql.org
irc#postgresql

People

Translate

site design / logo © 2022 Grokbase