Sorry. I added some "< raw >" tags so maybe this is the reason why you
couldn't see half of my message.
Hi again,
It looks like the problem comes from the "-l" option I'm trying to set when
I register the service.
1) If I register the cluster as a service in the following way:
-------------------------------------------------------------------------------------------
dos ; a_user> pg_ctl.exe register -N a_pgcluster_srv -U a_user -P a_password
-D "a_pgcluster" -S auto -w -t 60
-------------------------------------------------------------------------------------------
It works: the service is automatically started properly.
2) If I add the following option:
-------------------------------------------------------------------------------------------
-o "-l '<path_to_the_cluster_log_file>/a_pgcluster.log'"
-------------------------------------------------------------------------------------------
and then try to start the service (via "Control Panel" -> "Administrative
Tools" -> "Services"), it fails with the message:
-------------------------------------------------------------------------------------------
"The a_pgcluster_srv 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."
-------------------------------------------------------------------------------------------
Is this not the right way to set the cluster log file?
Or maybe this should be set in the cluster "postgresql.conf" configuration
file instead?
Thanks for helping.
Best regards.
--
View this message in context:
http://postgresql.1045698.n5.nabble.com/Starting-a-cluster-as-a-service-tp5712728p5713070.html
Sent from the PostgreSQL - general mailing list archive at Nabble.com.