[ANNOUNCEMENT] Updated: postgresql-7.1.3-1

[ANNOUNCEMENT] Updated: postgresql-7.1.3-1

[Jason Tishler]

New News:
=== ====
I have updated the version of PostgreSQL in cygwin/contrib to 7.1.3-1.
The tarballs should be available on a Cygwin mirror near you shortly.

I have also taken this opportunity to document the procedure to install
PostgreSQL as an NT service (via cygrunsrv) in the README file.

Old News:
=== ====
PostgreSQL is an open-source, Object-Relational DBMS.  If interested,
see the PostgreSQL web site for more details:

    http://www.postgresql.org/

Please read the README file:

    /usr/doc/Cygwin/postgresql-7.1.3.README

since it covers requirements, installation, known issues, etc.

To update your installation, click on the "Install Cygwin now" link on
the http://cygwin.com/ web page.  This downloads setup.exe to your
system.  Then, run setup and answer all of the questions.

Note that we have recently stopped downloads from sources.redhat.com
(aka cygwin.com) due to bandwidth limitations.  This means that you will
need to find a mirror which has this update.

In the US,
ftp://mirrors.rcn.net/mirrors/sources.redhat.com/cygwin/
is a reliable high bandwidth connection.

In Germany,
ftp://ftp.uni-erlangen.de/pub/pc/gnuwin32/cygwin/mirrors/cygnus/
is usually pretty good.

In the UK,
http://programming.ccp14.ac.uk/ftp-mirror/programming/cygwin/pub/cygwin/
is usually up-to-date within 48 hours.

If one of the above doesn't have the latest version of this package
then you can either wait for the site to be updated or find another
mirror.

The setup.exe program will figure out what needs to be updated on your
system and will install newer packages automatically.

If you have questions or comments, please send them to the Cygwin
mailing list at: cygwin@cygwin.com .  I would appreciate if you would
use this mailing list rather than emailing me directly.  This includes
ideas and comments about the setup utility or Cygwin in general.

If you want to make a point or ask a question, the Cygwin mailing list
is the appropriate place.

              *** CYGWIN-ANNOUNCE UNSUBSCRIBE INFO ***

If you want to unsubscribe from the cygwin-announce mailing list, look
at the "List-Unsubscribe: " tag in the email header of this message.
Send email to the address specified there.  It will be in the format:

cygwin-announce-unsubscribe-you=yourdomain.com@cygwin.com

Jason


--
Unsubscribe info:      http://cygwin.com/ml/#unsubscribe-simple
Bug reporting:         http://cygwin.com/bugs.html
Documentation:         http://cygwin.com/docs.html
FAQ:                   http://cygwin.com/faq/

Re: [ANNOUNCEMENT] Updated: postgresql-7.1.3-1

[Kurt Roeckx]

On Thu, Aug 23, 2001 at 02:31:48PM -0400, Jason Tishler wrote:
> I have also taken this opportunity to document the procedure to install
> PostgreSQL as an NT service (via cygrunsrv) in the README file.

Couldn't you do that 2 days earlier, so I wouldn't have to figure
things out myself? :)

It's running perfectly now.

I do have a question though:
What is the proper way to remove the pid file during boot, in
case it wasn't shut down properly?


Kurt


--
Unsubscribe info:      http://cygwin.com/ml/#unsubscribe-simple
Bug reporting:         http://cygwin.com/bugs.html
Documentation:         http://cygwin.com/docs.html
FAQ:                   http://cygwin.com/faq/

Re: [ANNOUNCEMENT] Updated: postgresql-7.1.3-1

[Jason Tishler]

Kurt,

On Thu, Aug 23, 2001 at 09:38:35PM +0200, Kurt Roeckx wrote:
> What is the proper way to remove the pid file during boot, in
> case it wasn't shut down properly?

Do the following when running under the postgres user account:

    $ rm /usr/share/postgresql/data/postmaster.pid 

Jason

--
Unsubscribe info:      http://cygwin.com/ml/#unsubscribe-simple
Bug reporting:         http://cygwin.com/bugs.html
Documentation:         http://cygwin.com/docs.html
FAQ:                   http://cygwin.com/faq/

Re: [ANNOUNCEMENT] Updated: postgresql-7.1.3-1

[Kurt Roeckx]

On Thu, Aug 23, 2001 at 04:21:41PM -0400, Jason Tishler wrote:
> Kurt,
> 
> On Thu, Aug 23, 2001 at 09:38:35PM +0200, Kurt Roeckx wrote:
> > What is the proper way to remove the pid file during boot, in
> > case it wasn't shut down properly?
> 
> Do the following when running under the postgres user account:
> 
>     $ rm /usr/share/postgresql/data/postmaster.pid 

I don't want to remove it manually.  Normaly on boot you remove
all stale pid files from the init scripts.  You basicly do an rm
of /var/run/*.pid.  Is it removed for other daemons, like sshd,
and how?


Kurt


--
Unsubscribe info:      http://cygwin.com/ml/#unsubscribe-simple
Bug reporting:         http://cygwin.com/bugs.html
Documentation:         http://cygwin.com/docs.html
FAQ:                   http://cygwin.com/faq/

Re: [ANNOUNCEMENT] Updated: postgresql-7.1.3-1

[Jason Tishler]

Kurt,

On Fri, Aug 24, 2001 at 12:22:50AM +0200, Kurt Roeckx wrote:
> On Thu, Aug 23, 2001 at 04:21:41PM -0400, Jason Tishler wrote:
> > Do the following when running under the postgres user account:
> > 
> >     $ rm /usr/share/postgresql/data/postmaster.pid 
> 
> I don't want to remove it manually.  Normaly on boot you remove
> all stale pid files from the init scripts.  You basicly do an rm
> of /var/run/*.pid.  Is it removed for other daemons, like sshd,
> and how?

I'm not sure that I am grokking your questions...

If postmaster is not shutting down cleanly and leaving a stale
postmaster.pid file, then you need to replace you Cygwin DLL with the
2001-Jul-28 snapshot or later.  Note that this is documented in the
Cygwin PostgreSQL 7.1.3-1 README file.

If you are asking for an automatic way to remove arbitrary stale pid
files cause by events like power failures, then I don't have any canned
solutions to offer you since I haven't tried to solve this problem (yet).

Jason

--
Unsubscribe info:      http://cygwin.com/ml/#unsubscribe-simple
Bug reporting:         http://cygwin.com/bugs.html
Documentation:         http://cygwin.com/docs.html
FAQ:                   http://cygwin.com/faq/

Re: [ANNOUNCEMENT] Updated: postgresql-7.1.3-1

[Kurt Roeckx]

On Thu, Aug 23, 2001 at 09:51:54PM -0400, Jason Tishler wrote:
> 
> If you are asking for an automatic way to remove arbitrary stale pid
> files cause by events like power failures, then I don't have any canned
> solutions to offer you since I haven't tried to solve this problem (yet).

That's the problem I'm thinking about, yes.


Kurt


--
Unsubscribe info:      http://cygwin.com/ml/#unsubscribe-simple
Bug reporting:         http://cygwin.com/bugs.html
Documentation:         http://cygwin.com/docs.html
FAQ:                   http://cygwin.com/faq/