Re: Starting a cluster as a service

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.