Thread: Start up and shutdown scripts for postgres on cygwin

Start up and shutdown scripts for postgres on cygwin

From
"Richard Church"
Date:
I am new to cygwin how I can use the equivalent of Linux rc.d scripts in
cygwin to get postgres started

I want to run postgres automatically after I start cygwin, and get it to
shutdown when cygwin shuts down.

It is always necessary to redefine the PGDATA variable after I start. The
variables don't remain after cygwin shuts down.

What sort of script can I use to achieve this?
_________________________________________________________________________
Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com.


Re: Start up and shutdown scripts for postgres on cygwin

From
Jason Tishler
Date:
Richard,

On Mon, May 28, 2001 at 01:27:12AM -0000, Richard Church wrote:
> I am new to cygwin how I can use the equivalent of Linux rc.d scripts in
> cygwin to get postgres started
>
> I want to run postgres automatically after I start cygwin, and get it to
> shutdown when cygwin shuts down.

Try using cygrunsrv that is part of Cygwin now -- the README has a
PostgreSQL example in it.

> It is always necessary to redefine the PGDATA variable after I start. The
> variables don't remain after cygwin shuts down.
>
> What sort of script can I use to achieve this?

You can always add this to your .bash_profile (just like on Linux).

Jason

--
Jason Tishler
Director, Software Engineering       Phone: 732.264.8770 x235
Dot Hill Systems Corp.               Fax:   732.264.8798
82 Bethany Road, Suite 7             Email: Jason.Tishler@dothill.com
Hazlet, NJ 07730 USA                 WWW:   http://www.dothill.com

Re: Start up and shutdown scripts for postgres on cygwin

From
"Richard Church"
Date:
Thanks, I will give it a try.

I have also got Postgres running on Windows 98. I will be giving it a good
work out soon

Richard

>From: Jason Tishler <Jason.Tishler@dothill.com>
>To: Richard Church <rfchurch@hotmail.com>
>CC: pgsql-cygwin@postgresql.org
>Subject: Re: [CYGWIN] Start up and shutdown scripts for postgres on cygwin
>Date: Tue, 29 May 2001 13:53:38 -0400
>
>Richard,
>
>On Mon, May 28, 2001 at 01:27:12AM -0000, Richard Church wrote:
> > I am new to cygwin how I can use the equivalent of Linux rc.d scripts in
> > cygwin to get postgres started
> >
> > I want to run postgres automatically after I start cygwin, and get it to
> > shutdown when cygwin shuts down.
>
>Try using cygrunsrv that is part of Cygwin now -- the README has a
>PostgreSQL example in it.
>
> > It is always necessary to redefine the PGDATA variable after I start.
>The
> > variables don't remain after cygwin shuts down.
> >
> > What sort of script can I use to achieve this?
>
>You can always add this to your .bash_profile (just like on Linux).
>
>Jason
>
>--
>Jason Tishler
>Director, Software Engineering       Phone: 732.264.8770 x235
>Dot Hill Systems Corp.               Fax:   732.264.8798
>82 Bethany Road, Suite 7             Email: Jason.Tishler@dothill.com
>Hazlet, NJ 07730 USA                 WWW:   http://www.dothill.com

_________________________________________________________________________
Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com.


Re: Start up and shutdown scripts for postgres on cygwin

From
"Richard Church"
Date:


Does the cygrunsrv have a home page?

I have checked the cygwin homepage but I  have not seen it there. Can you
tell me the location? I would like to read more about before installing it?

Richard

>Try using cygrunsrv that is part of Cygwin now -- the README has a
>PostgreSQL example in it.
>
> > It is always necessary to redefine the PGDATA variable after I start.
>The
> > variables don't remain after cygwin shuts down.
> >
> > What sort of script can I use to achieve this?
>
>You can always add this to your .bash_profile (just like on Linux).
>
>Jason
>
>--
>Jason Tishler
>Director, Software Engineering       Phone: 732.264.8770 x235
>Dot Hill Systems Corp.               Fax:   732.264.8798
>82 Bethany Road, Suite 7             Email: Jason.Tishler@dothill.com
>Hazlet, NJ 07730 USA                 WWW:   http://www.dothill.com
>
>Try using cygrunsrv that is part of Cygwin now -- the README has a
>PostgreSQL example in it.
>
> > It is always necessary to redefine the PGDATA variable after I start.
>The
> > variables don't remain after cygwin shuts down.
> >
> > What sort of script can I use to achieve this?
>
>You can always add this to your .bash_profile (just like on Linux).
>
>Jason
>
>--
>Jason Tishler
>Director, Software Engineering       Phone: 732.264.8770 x235
>Dot Hill Systems Corp.               Fax:   732.264.8798
>82 Bethany Road, Suite 7             Email: Jason.Tishler@dothill.com
>Hazlet, NJ 07730 USA                 WWW:   http://www.dothill.com

_________________________________________________________________________
Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com.


Re: Start up and shutdown scripts for postgres on cygwin

From
Jason Tishler
Date:
Richard,

On Thu, May 31, 2001 at 02:22:10AM -0000, Richard Church wrote:
> Does the cygrunsrv have a home page?

AFAIK, no.

> I have checked the cygwin homepage but I  have not seen it there. Can you
> tell me the location? I would like to read more about before installing it?

cygrunsrv is one of the latest packages -- it is automatically installed
when you update from a Cygwin mirror.  The tarball is only 15K --
so why don't you just install it?  Note that installing the package
has no affect on your system (except for disk space consumption) until
you start to install services with it.  So why don't you install it and
read the README?  Otherwise, you can always download and untar to a temp
directory and then delete it...

Jason

--
Jason Tishler
Director, Software Engineering       Phone: 732.264.8770 x235
Dot Hill Systems Corp.               Fax:   732.264.8798
82 Bethany Road, Suite 7             Email: Jason.Tishler@dothill.com
Hazlet, NJ 07730 USA                 WWW:   http://www.dothill.com