Обсуждение: startup Postgres on NT
Hello, I download cygwin package, IPC package and postgres's binaries and install them on NT. I startup postgres with the following command: - open cygwin-shell - ipc-daemon& - postmaster -i -S 1. When I close cygwin-shell or I logout, postgres process will close too. How to keep progres process running when I logout? 2. How to startup postgres with NT startup? Regards, wit
On Thu, Feb 01, 2001 at 11:23:53AM +0700, microx_2000@yahoo.com wrote: > 2. How to startup postgres with NT startup? The (klugey) procedure I used to setup up PostgreSQL as an NT service is documented in <http://www.ontosys.com/reports/postgresql.html> I've since patched a version of ipc-daemon so that it can install and run itself directly as an NT service. I've also thought about hacking postgres to run directly as an NT service, but that plan got only a tepid response when I proposed it to the 'hackers' list, so I'm shelving it for now. -- Fred Yankowski fred@OntoSys.com tel: +1.630.879.1312 Principal Consultant www.OntoSys.com fax: +1.630.879.1370 OntoSys, Inc 38W242 Deerpath Rd, Batavia, IL 60510, USA
That's a shame... I think it would be a great improvement to have PG able to run as a service. It would open up pg to be a usable database for a lot of people who currently find it too hard to setup. I don't know if MySQL runs as a service, but I know it has a clean windows setup, and does not require the user to install cygwin first. A similar setup for postgre would be fabulous also. This ability on Windows would help a lot of people who are in mixed environments. I know we are and it would help us. Matt > -----Original Message----- > From: Fred Yankowski [SMTP:fred@ontosys.com] > Sent: Tuesday, February 06, 2001 10:22 AM > To: microx_2000@yahoo.com > Cc: pgsql-general@postgresql.org > Subject: [GENERAL] Re: startup Postgres on NT > > On Thu, Feb 01, 2001 at 11:23:53AM +0700, microx_2000@yahoo.com wrote: > > 2. How to startup postgres with NT startup? > > The (klugey) procedure I used to setup up PostgreSQL as an NT service > is documented in > <http://www.ontosys.com/reports/postgresql.html> > > I've since patched a version of ipc-daemon so that it can install and > run itself directly as an NT service. > > I've also thought about hacking postgres to run directly as an NT > service, but that plan got only a tepid response when I proposed it to > the 'hackers' list, so I'm shelving it for now. > > -- > Fred Yankowski fred@OntoSys.com tel: +1.630.879.1312 > Principal Consultant www.OntoSys.com fax: +1.630.879.1370 > OntoSys, Inc 38W242 Deerpath Rd, Batavia, IL 60510, USA
On Mon, Feb 12, 2001 at 12:56:04PM +0700, Jarungwit J. wrote: > Now I can start ipc-daemon as NT Service by using invoker methood. But > when I start postmaster with invoker method, it shows error: > Error 0203: The sytem could not find the environment option that was > entered. > Note that I can start postmaster in cygwin-shell. Any suggestion? Make sure that the environment variables for whatever NT user the postmaster service is running under are set to everything that postmaster needs. Consider PGDATA, PGHOST, and PATH in particular. Note that the .bash_profile and .bashrc files won't apply to the service since it isn't run in the context of bash/sh. The Cygwin /usr/bin (or /bin) folder should be in PATH too so that postmaster/postgres can call system() on utilities like 'rm' and 'cp'. -- Fred Yankowski fred@OntoSys.com tel: +1.630.879.1312 Principal Consultant www.OntoSys.com fax: +1.630.879.1370 OntoSys, Inc 38W242 Deerpath Rd, Batavia, IL 60510, USA
Hello, Now I can start ipc-daemon as NT Service by using invoker methood. But when I start postmaster with invoker method, it shows error: Error 0203: The sytem could not find the environment option that was entered. Note that I can start postmaster in cygwin-shell. Any suggestion? Regards, wit On Tue, 6 Feb 2001, Fred Yankowski wrote: > On Thu, Feb 01, 2001 at 11:23:53AM +0700, microx_2000@yahoo.com wrote: > > 2. How to startup postgres with NT startup? > > The (klugey) procedure I used to setup up PostgreSQL as an NT service > is documented in > <http://www.ontosys.com/reports/postgresql.html> > > I've since patched a version of ipc-daemon so that it can install and > run itself directly as an NT service. > > I've also thought about hacking postgres to run directly as an NT > service, but that plan got only a tepid response when I proposed it to > the 'hackers' list, so I'm shelving it for now. > > -- > Fred Yankowski fred@OntoSys.com tel: +1.630.879.1312 > Principal Consultant www.OntoSys.com fax: +1.630.879.1370 > OntoSys, Inc 38W242 Deerpath Rd, Batavia, IL 60510, USA >