Thread: Re: Compiling 7.1.3 pgsql under cygwin 1.3 on W2000
If you are running a flavour of NT you can run it as a service using
cygrunsrv (and I definitly would advise against 9x for a server
anyway). You must already have the cygipc installed as a service, then
you could do something like this (not tested):
cygrunsrv --install postmaster \
--path /bin/postmaster \
--args "-D /usr/data -i -o '-e -o /var/log/postgres.log'" \
--dep ipc-daemon --termsig INT \
--user <username>
Cheers,
- Stuart
> -----Original Message-----
> From: Tim Finch, FosterFinch Ltd [mailto:tim@fosterfinch.co.uk]
> Sent: 17 February 2002 23:28
> To: Jason Tishler
> Cc: pgsql-cygwin@postgresql.org
> Subject: Re: [CYGWIN] Compiling 7.1.3 pgsql under cygwin 1.3 on W2000
>
>
> Jason
>
> Thanks! I feel a bit of a duffer as I discovered this very
> option about 10
> mins after posting my message. I have indeed used the
> prebuilt one. However
> I have only got as far as trying to start postmaster once,
> which it did OK,
> but then I thought I could exit Cygwin to allow postmaster to run in
> background and caused myself no end of grief -- is it true
> that cygwin must
> remain loaded whilst pgsql runs? Anyway to 'hide' the cygwin
> window (i.e.
> not even have it minimised, or sent to the tray for example?)
>
> Thanks
>
> Tim.
>
> At 21:19 16/02/2002 -0500, Jason Tishler wrote:
> >Tim,
> >
> >On Sat, Feb 16, 2002 at 10:51:30AM +0000, Tim Finch,
> FosterFinch Ltd wrote:
> > > This is my first attempt at using cygwin so that I can
> try and compile
> > > pgsql for Windows 2000.
> > >
> > > [snip]
> >
> >Why don't you just use the pre-built binary that it installable by
> >Cygwin's setup.exe?
> >
> > http://cygwin.com/ml/cygwin-announce/2002/msg00048.html
> >
> >Jason
>
>
>
> ---------------------------(end of
> broadcast)---------------------------
> TIP 3: if posting/reading through Usenet, please send an appropriate
> subscribe-nomail command to majordomo@postgresql.org so that your
> message can get through to the mailing list cleanly
>
Tim,
On Mon, Feb 18, 2002 at 02:20:56PM +0000, Henshall, Stuart - WCP wrote:
> If you are running a flavour of NT you can run it as a service using
> cygrunsrv (and I definitly would advise against 9x for a server
> anyway). You must already have the cygipc installed as a service, then
> you could do something like this (not tested):
> cygrunsrv --install postmaster \
> --path /bin/postmaster \
> --args "-D /usr/data -i -o '-e -o /var/log/postgres.log'" \
> --dep ipc-daemon --termsig INT \
> --user <username>
Stuart is correct.
BTW, you can find this and more in the README:
/usr/doc/Cygwin/postgresql-7.2.README
or:
http://tishler.net/jason/software/postgresql/postgresql-7.2.README.txt
Jason
Very helpful Stuart, thank you very much. At 14:20 18/02/2002 +0000, you wrote: >If you are running a flavour of NT you can run it as a service using >cygrunsrv (and I definitly would advise against 9x for a server >anyway). You must already have the cygipc installed as a service, then >you could do something like this (not tested): >cygrunsrv --install postmaster \ > --path /bin/postmaster \ > --args "-D /usr/data -i -o '-e -o /var/log/postgres.log'" \ > --dep ipc-daemon --termsig INT \ > --user <username> >Cheers, >- Stuart > > > -----Original Message----- > > From: Tim Finch, FosterFinch Ltd [mailto:tim@fosterfinch.co.uk] > > Sent: 17 February 2002 23:28 > > To: Jason Tishler > > Cc: pgsql-cygwin@postgresql.org > > Subject: Re: [CYGWIN] Compiling 7.1.3 pgsql under cygwin 1.3 on W2000 > > > > > > Jason > > > > Thanks! I feel a bit of a duffer as I discovered this very > > option about 10 > > mins after posting my message. I have indeed used the > > prebuilt one. However > > I have only got as far as trying to start postmaster once, > > which it did OK, > > but then I thought I could exit Cygwin to allow postmaster to run in > > background and caused myself no end of grief -- is it true > > that cygwin must > > remain loaded whilst pgsql runs? Anyway to 'hide' the cygwin > > window (i.e. > > not even have it minimised, or sent to the tray for example?) > > > > Thanks > > > > Tim. > > > > At 21:19 16/02/2002 -0500, Jason Tishler wrote: > > >Tim, > > > > > >On Sat, Feb 16, 2002 at 10:51:30AM +0000, Tim Finch, > > FosterFinch Ltd wrote: > > > > This is my first attempt at using cygwin so that I can > > try and compile > > > > pgsql for Windows 2000. > > > > > > > > [snip] > > > > > >Why don't you just use the pre-built binary that it installable by > > >Cygwin's setup.exe? > > > > > > http://cygwin.com/ml/cygwin-announce/2002/msg00048.html > > > > > >Jason > > > > > > > > ---------------------------(end of > > broadcast)--------------------------- > > TIP 3: if posting/reading through Usenet, please send an appropriate > > subscribe-nomail command to majordomo@postgresql.org so that your > > message can get through to the mailing list cleanly > >
Thanks, this info you have both supplied is very useful. I have yet to connect to postgresql successfully from odbc but I think this readme is helping me find out why. Tim. At 11:26 18/02/2002 -0500, Jason Tishler wrote: >Tim, > >On Mon, Feb 18, 2002 at 02:20:56PM +0000, Henshall, Stuart - WCP wrote: > > If you are running a flavour of NT you can run it as a service using > > cygrunsrv (and I definitly would advise against 9x for a server > > anyway). You must already have the cygipc installed as a service, then > > you could do something like this (not tested): > > cygrunsrv --install postmaster \ > > --path /bin/postmaster \ > > --args "-D /usr/data -i -o '-e -o /var/log/postgres.log'" \ > > --dep ipc-daemon --termsig INT \ > > --user <username> > >Stuart is correct. > >BTW, you can find this and more in the README: > > /usr/doc/Cygwin/postgresql-7.2.README > >or: > > http://tishler.net/jason/software/postgresql/postgresql-7.2.README.txt > >Jason