[HACKERS] Re: Why not to use 'pg_ctl start -D ../data' to register posgtresql windows service

2015-11-03 Thread YuanyuanLiu
Ok, Michael! Thanks for your kindly remind! Regards! Liu Yuanyuan -- View this message in context: http://postgresql.nabble.com/Why-not-to-use-pg-ctl-start-D-data-to-register-posgtresql-windows-service-tp5872282p5872631.html Sent from the PostgreSQL - hackers mailing list archive at Nabble.com

Re: [HACKERS] Re: Why not to use 'pg_ctl start -D ../data' to register posgtresql windows service

2015-11-03 Thread Michael Paquier
On Tue, Nov 3, 2015 at 10:46 AM, YuanyuanLiu wrote: >I really learned a lot from you, and thank you! By the way, in the future you may want to ask general questions to pgsql-general, pgsql-hackers is where new features are being discussed and where technical discussions happen :) -- Michael

[HACKERS] Re: Why not to use 'pg_ctl start -D ../data' to register posgtresql windows service

2015-11-02 Thread YuanyuanLiu
Yup, I think I totally understand now, the registered postgres service is different from "pg_ctl start". To start the postgres windows service needs privileged prompt (to execute net or sc command) or manually(start or stop in windows service list).After the service is started, it can be recog

Re: [HACKERS] Re: Why not to use 'pg_ctl start -D ../data' to register posgtresql windows service

2015-11-02 Thread Michael Paquier
On Mon, Nov 2, 2015 at 9:30 PM, Michael Paquier wrote: > On Mon, Nov 2, 2015 at 4:27 PM, YuanyuanLiu wrote: >> When we registered postgresql windows service named "postgres-9.4", >> we can start the postgresql server by manually starting the windows service >> , runing command "net stop postgres

Re: [HACKERS] Re: Why not to use 'pg_ctl start -D ../data' to register posgtresql windows service

2015-11-02 Thread Michael Paquier
On Mon, Nov 2, 2015 at 4:27 PM, YuanyuanLiu wrote: > When we registered postgresql windows service named "postgres-9.4", > we can start the postgresql server by manually starting the windows service > , runing command "net stop postgres-9.4" (need user with administrator > privilege), or runing c

[HACKERS] Re: Why not to use 'pg_ctl start -D ../data' to register posgtresql windows service

2015-11-01 Thread YuanyuanLiu
Hi, Michael! Thanks for your reply! I knew that postgresql windows service is made by "pg_ctl register -N serviceName -D dataPath". And command from service, like "D:\Program Files (x86)\PostgreSQL\9.4\bin\pg_ctl.exe" runservice -N "postgres-9.4" -D "D:\Program Files (x86)\PostgreSQL\9.4\data", c