pg.ddx.io pgsql-admin@postgresql.org mailing list archive
help / color / mirror / Atom feedPostgres service starts and then stops immediatly
3+ messages / 3 participants
[nested] [flat]
* Postgres service starts and then stops immediatly
@ 2011-08-11 10:00 Sofer, Yuval <Yuval_Sofer@bmc.com>
2011-08-11 12:37 ` Re: Postgres service starts and then stops immediatly Craig Ringer <ringerc@ringerc.id.au>
2011-08-11 14:06 ` Re: Postgres service starts and then stops immediatly Igor Neyman <ineyman@perceptron.com>
0 siblings, 2 replies; 3+ messages in thread
From: Sofer, Yuval @ 2011-08-11 10:00 UTC (permalink / raw)
To: pgsql-admin; +Cc: Zucker, Yehudit <Yehudit_Zucker@bmc.com>
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<mailto:yuval_sofer@bmc.com>
^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: Postgres service starts and then stops immediatly
2011-08-11 10:00 Postgres service starts and then stops immediatly Sofer, Yuval <Yuval_Sofer@bmc.com>
@ 2011-08-11 12:37 ` Craig Ringer <ringerc@ringerc.id.au>
1 sibling, 0 replies; 3+ messages in thread
From: Craig Ringer @ 2011-08-11 12:37 UTC (permalink / raw)
To: Sofer, Yuval <Yuval_Sofer@bmc.com>; +Cc: pgsql-admin; Zucker, Yehudit <Yehudit_Zucker@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
^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: Postgres service starts and then stops immediatly
2011-08-11 10:00 Postgres service starts and then stops immediatly Sofer, Yuval <Yuval_Sofer@bmc.com>
@ 2011-08-11 14:06 ` Igor Neyman <ineyman@perceptron.com>
1 sibling, 0 replies; 3+ messages in thread
From: Igor Neyman @ 2011-08-11 14:06 UTC (permalink / raw)
To: Sofer, Yuval <Yuval_Sofer@bmc.com>; pgsql-admin; +Cc: Zucker, Yehudit <Yehudit_Zucker@bmc.com>
From: Sofer, Yuval [mailto:Yuval_Sofer@bmc.com]
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
^ permalink raw reply [nested|flat] 3+ messages in thread
end of thread, other threads:[~2011-08-11 14:06 UTC | newest]
Thread overview: 3+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2011-08-11 10:00 Postgres service starts and then stops immediatly Sofer, Yuval <Yuval_Sofer@bmc.com>
2011-08-11 12:37 ` Craig Ringer <ringerc@ringerc.id.au>
2011-08-11 14:06 ` Igor Neyman <ineyman@perceptron.com>
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