Обсуждение: Re: postmaster does not shutdown

Hi John,

Are you using cygwin on your PC for anything other than PostgreSQL?

About a day ago we put together an initial "easy-installation" package
of PostgreSQL (using cygwin) for Windows.  It's been working fine here.

If you're not using cygwin for anything else, and you've made a backup
of your data (just in case), would you be interested in installing that
and seeing if it works for you properly?  Was going to add it to the
PostgreSQL sites later on today, but can do it sooner rather than later
if needed.

:-)

Regards and best wishes,

Justin Clift


John Smith wrote:
>
> On my system (w2k), all postgres processes disappear from taskman after
> closing the cygwin window (started with either pg_ctl or postmaster)..
>
>  */Cornelia Boenigk <poppcorn@cornelia-boenigk.de>/* wrote:
>
>      > I guess closing the window kills it?
>     No. It doesn't kill postgresql and it doesn't kill the ipc-daemon.
>     If you
>     look at the win task manager you see the processes still running.
>     You can
>     kill it with the task manager but this is a rather inelegant way;-)


--
"My grandfather once told me that there are two kinds of people: those
who work and those who take the credit. He told me to try to be in the
first group; there was less competition there."
- Indira Gandhi

Well, I use some of the other cygwin unix utils ocassionally. What exactly is the easy-install? It uses cygwin, but cygwin wouldn't be available?

thanks
John

 Justin Clift <justin@postgresql.org> wrote:

Hi John,

Are you using cygwin on your PC for anything other than PostgreSQL?

About a day ago we put together an initial "easy-installation" package
of PostgreSQL (using cygwin) for Windows. It's been working fine here.

If you're not using cygwin for anything else, and you've made a backup
of your data (just in case), would you be interested in installing that
and seeing if it works for you properly? Was going to add it to the
PostgreSQL sites later on today, but can do it sooner rather than later
if needed.

:-)

Regards and best wishes,

Justin Clift


John Smith wrote:
>
> On my system (w2k), all postgres processes disappear from taskman after
> closing the cygwin window (started with either pg_ctl or postmaster)..
>
> */Cornelia Boenigk /* wrote:
>
> > I guess closing the window kills it?
> No. It doesn't kill postgresql and it doesn't kill the ipc-daemon.
> If you
> look at the win task manager you see the processes still running.
> You can
> kill it with the task manager but this is a rather inelegant way;-)


--
"My grandfather once told me that there are two kinds of people: those
who work and those who take the credit. He told me to try to be in the
first group; there was less competition there."
- Indira Gandhi

John Smith wrote:
> Well, I use some of the other cygwin unix utils ocassionally. What
> exactly is the easy-install? It uses cygwin, but cygwin wouldn't be
> available?

It might not be your best option then.  ;-)

The "easy-install" version package that's being worked on (and this is
the 1st Alpha release!) is just Cygwin+PostgreSQL 7.3.1 packaged up
using Isso Setup so that it's easy for end users to install.

It's also kind of basic, being targeted to only cater for PostgreSQL,
and doesn't include all of the standard cywin utils.

Don't reckon it's a good idea for you after all, was just hoping to make
things easy to get a complete snapshot of a "known working" installation.

:-)

Regards and best wishes,

Justin Clift


> thanks
> John


--
"My grandfather once told me that there are two kinds of people: those
who work and those who take the credit. He told me to try to be in the
first group; there was less competition there."
- Indira Gandhi

Oh, OK. Shouldn't be too difficult figuring out how to get the service working.

Just curious - what are the future plans for PostgreSQL on Windows? I've seen posts about a native port for 7.4. The cygwin/ipc page also states that ipc-daemon is deprecated and exists only for PG, and that PG will probably use another method (standard cygwin?) in the future.

thanks,
John

 Justin Clift <justin@postgresql.org> wrote:

John Smith wrote:
> Well, I use some of the other cygwin unix utils ocassionally. What
> exactly is the easy-install? It uses cygwin, but cygwin wouldn't be
> available?

It might not be your best option then. ;-)

The "easy-install" version package that's being worked on (and this is
the 1st Alpha release!) is just Cygwin+PostgreSQL 7.3.1 packaged up
using Isso Setup so that it's easy for end users to install.

It's also kind of basic, being targeted to only cater for PostgreSQL,
and doesn't include all of the standard cywin utils.

Don't reckon it's a good idea for you after all, was just hoping to make
things easy to get a complete snapshot of a "known working" installation.

:-)

Regards and best wishes,

Justin Clift


> thanks
> John


--
"My grandfather once told me that ther e are two kinds of people: those
who work and those who take the credit. He told me to try to be in the
first group; there was less competition there."
- Indira Gandhi

John Smith wrote:
> Oh, OK. Shouldn't be too difficult figuring out how to get the service
> working.
>
> Just curious - what are the future plans for PostgreSQL on Windows? I've
> seen posts about a native port for 7.4. The cygwin/ipc page also states
> that ipc-daemon is deprecated and exists only for PG, and that PG will
> probably use another method (standard cygwin?) in the future.

Good question.  The main PostgreSQL effort will have PostgreSQL 7.4
running natively on Windows when it's released, without cygwin being
needed at all.  The original work was done by a company called
PeerDirect as part of their developing a Windows native PostgreSQL 7.2.1
variant called UltraSQL.  They have donated the source code and changes
they did for this to the PostgreSQL Community.

That doesn't in any way mean that PostgreSQL 7.4 will stop working with
cygwin though, it just means that there are now 2 options for running
PostgreSQL on 7.4.

The testing that's been done on the PeerDirect beta of their PostgreSQL
variant was showing 2 to 3 times the transaction throughput of the
cygwin version of PostgreSQL 7.2.1, so there looks to be some advantages
to this approach.

:-)

Regards and best wishes,

Justin Clift


> thanks,
> John


--
"My grandfather once told me that there are two kinds of people: those
who work and those who take the credit. He told me to try to be in the
first group; there was less competition there."
- Indira Gandhi