X-Spam-Check-By: sourceware.org
Date: Sat, 12 Aug 2006 16:22:17 -0700 (PDT)
From: "Peter A. Castro" <doctor AT fruitbat DOT org>
To: alecswan <aukcioner AT yahoo DOT com>
cc: cygwin AT cygwin DOT com
Subject: Re: Older postgresql versions [changed]
In-Reply-To: <5780088.post@talk.nabble.com>
Message-ID: <Pine.LNX.4.63.0608121547240.10551@gremlin.fruitbat.org>
References: <5722793 DOT post AT talk DOT nabble DOT com> <44DA1EF8 DOT 7010408 AT x-ray DOT at>  <44DAD730 DOT 4080207 AT x-ray DOT at> <5772970 DOT post AT talk DOT nabble DOT com> <44DDB954 DOT 4060305 AT x-ray DOT at>  <5778314 DOT post AT talk DOT nabble DOT com> <44DE279B DOT 2050705 AT cygwin DOT com>  <5780088 DOT post AT talk DOT nabble DOT com>
MIME-Version: 1.0
Content-Type: TEXT/PLAIN; charset=US-ASCII; format=flowed
X-IsSubscribed: yes
Mailing-List: contact cygwin-help AT cygwin DOT com; run by ezmlm
Precedence: bulk
List-Unsubscribe: <mailto:cygwin-unsubscribe-archive-cygwin=delorie DOT com AT cygwin DOT com>
List-Subscribe: <mailto:cygwin-subscribe AT cygwin DOT com>
List-Archive: <http://sourceware.org/ml/cygwin/>
List-Post: <mailto:cygwin AT cygwin DOT com>
List-Help: <mailto:cygwin-help AT cygwin DOT com>, <http://sourceware.org/ml/#faqs>
Sender: cygwin-owner AT cygwin DOT com
Mail-Followup-To: cygwin AT cygwin DOT com
Delivered-To: mailing list cygwin AT cygwin DOT com

On Sat, 12 Aug 2006, alecswan wrote:

>> Always install with 'setup.exe'.  Never "just unzip" a file if you don't
>> understand and/or aren't willing to endure the consequences.
>
> I spent the whole day messing with cygwin time machine and also trying to

What specific problem did you have with the Cygwin Time Machine?  The
package you are looking for (postgresql-7.4.5-1) is located in many
snapshots, ranging from 2004/08/26/093142 to 2006/07/23/184023.

> install from a tarball. No luck at all. I can't even figure out how to
> install from the tarball. Where do I enter the tarball location when running
> setup.exe?

Setup only works with setup.ini.  You can create a custom setup.ini in a
custom built local install directory (this is what I do to test my own
install packages).  This isn't all that difficult to do, but it does take
some attention to detail.

> Then I tried to download PostgreSQL source and just build it on cygwin. And
> of course I ran into linking errors and such.
>
> I am so frustrated, that I'd be happy with any solution that will get old
> postgres to work on cygwin.

The main problem with "old" packages running on a "newer" snapshot of
cygwin is that, as things are fixed, invariably "old" things get broken
and either need to be re-compiled with the newer environment or simply
need to be upgraded to a newer release which fixes the specific
incompatability.  Such is the price of progress :)

Your options are:

1) Downgrade your entire cygwin environment to one which contains the
specific version of the package you need (and works!).  Since there is a
wide time-range for postgresql-7.4.5-1 (and not too far back-level for
Cygwin either), this should not be too difficult to do.  The Time Machine
can help with this.  Again, if you are having a problem with the Time
Machine, contact me off-list and I'll help you out.

2) Grab the source to the version you want and build it yourself.  As
you've already discovered, other linklibs or packages are needed for
this.  Suggest looking at the porting notes in
/usr/share/doc/Cygwin/postgresql-7.4.5.README and
/usr/share/doc/Cygwin/postgresql-7.4.5/ for possible building details.

3) Forget about this version and upgrade to the latest version.  That
way, if it doesn't work, you can harass the maintainer to fix it :^)

-- 
Peter A. Castro <doctor AT fruitbat DOT org> or <Peter DOT Castro AT oracle DOT com>
 	"Cats are just autistic Dogs" -- Dr. Tony Attwood

--
Unsubscribe info:      http://cygwin.com/ml/#unsubscribe-simple
Problem reports:       http://cygwin.com/problems.html
Documentation:         http://cygwin.com/docs.html
FAQ:                   http://cygwin.com/faq/