Re: [GENERAL] Postgres: Starting Server in background mode
On Thu, Apr 9, 2009 at 8:18 PM, Craig Ringer wrote: > Tino Wildenhain wrote: > >> The problem here is, Postgres is not an embedded database but really a >> database management system. Therefore trying to bundle it with a desktop >> application will usually cause more headaches. I'd suggest installing >> Postgres as central service > > Note that Windows is designed to allow applications to create services, > start them, stop them, etc. You should have *NO* problems having your > application install PostgreSQL as a service, and start/stop it on > demand. You can do this through the command line (net.exe), the Services > snap-in (services.msc), or via Win32 API calls from your application. Note that if one is going to do this, it's probably a good idea to install your private pgsql into a different default directory and have it answer on a different port than the 5432 one, so that if the user has or will install their own pgsql version your customer version won't get in the way. -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
Re: [GENERAL] Postgres: Starting Server in background mode
Tino Wildenhain wrote: > The problem here is, Postgres is not an embedded database but really a > database management system. Therefore trying to bundle it with a desktop > application will usually cause more headaches. I'd suggest installing > Postgres as central service Note that Windows is designed to allow applications to create services, start them, stop them, etc. You should have *NO* problems having your application install PostgreSQL as a service, and start/stop it on demand. You can do this through the command line (net.exe), the Services snap-in (services.msc), or via Win32 API calls from your application. Doing anything else is trying to re-invent the Windows service mechanism - poorly - and is really just NOT a good idea. -- Craig Ringer -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
Re: [GENERAL] Postgres: Starting Server in background mode
CM J wrote: Hi, I do not want start postgres as a service.Postgres will bundled along with my application and i am only looking at starting it only from cmd line.If there are any options to disable this cmd window which appears after executing the "pg_ctl.exe start", that would be great ! The problem here is, Postgres is not an embedded database but really a database management system. Therefore trying to bundle it with a desktop application will usually cause more headaches. I'd suggest installing Postgres as central service (as you know with web servers, application servers, mail servers... ) and connect your clients to it or use a desktop/linkable database for example firebird or whatever. Regards Tino -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
Re: [GENERAL] Postgres: Starting Server in background mode
CM J, 09.04.2009 13:23: I do not want start postgres as a service.Postgres will bundled along with my application and i am only looking at starting it only from cmd line.If there are any options to disable this cmd window which appears after executing the "pg_ctl.exe start", that would be great ! Thanks. If you are running this from a batch file, try start pg_ctl That might get rid of the window (you'll still have the initial Window that is shown when you run the batch file, but that is then closed) Thomas -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
Re: [GENERAL] Postgres: Starting Server in background mode
On Thu, Apr 09, 2009 at 04:53:06PM +0530, CM J wrote: > I do not want start postgres as a service.Postgres will bundled along > with my application and i am only looking at starting it only from cmd > line.If there are any options to disable this cmd window which appears after > executing the "pg_ctl.exe start", that would be great ! I think you can pass options to CreateProcess that will cause it to "hide" the window; not sure if this is what you want but I've not programmed under Windows for a long time so can't suggest more. -- Sam http://samason.me.uk/ -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
Re: [GENERAL] Postgres: Starting Server in background mode
Hi, I do not want start postgres as a service.Postgres will bundled along with my application and i am only looking at starting it only from cmd line.If there are any options to disable this cmd window which appears after executing the "pg_ctl.exe start", that would be great ! Thanks. On Thu, Apr 9, 2009 at 3:52 PM, Craig Ringer wrote: > CM J wrote: > > Hi, > > > >To start the postgres server in background mode in windows, i > > executed the following command: > > > > *runas /user:postgres "D:\postgres_new\pgsql\bin\pg_ctl.exe -W start -D > > D:\postgres_new\pgsql\data -l D:\postgres_new\pgsql\data\logfile"* > > > > The postgres starts up all fine and logs get redirected.However, > a > > command window gets opened which says "server starting...". How do i > disable > > this command window ? > > Run Pg as a service, and use the "net" command or the "services.msc" > snapin to start/stop the service. > > The GUI installer sets Pg up as a service by default. Why not use that? > > -- > Craig Ringer >
Re: [GENERAL] Postgres: Starting Server in background mode
CM J wrote: > Hi, > >To start the postgres server in background mode in windows, i > executed the following command: > > *runas /user:postgres "D:\postgres_new\pgsql\bin\pg_ctl.exe -W start -D > D:\postgres_new\pgsql\data -l D:\postgres_new\pgsql\data\logfile"* > > The postgres starts up all fine and logs get redirected.However, a > command window gets opened which says "server starting...". How do i disable > this command window ? Run Pg as a service, and use the "net" command or the "services.msc" snapin to start/stop the service. The GUI installer sets Pg up as a service by default. Why not use that? -- Craig Ringer -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
[GENERAL] Postgres: Starting Server in background mode
Hi, To start the postgres server in background mode in windows, i executed the following command: *runas /user:postgres "D:\postgres_new\pgsql\bin\pg_ctl.exe -W start -D D:\postgres_new\pgsql\data -l D:\postgres_new\pgsql\data\logfile"* The postgres starts up all fine and logs get redirected.However, a command window gets opened which says "server starting...". How do i disable this command window ? Thanks !