Older versions

[alecswan]

I installed Cygwin on my desktop long time ago. So, now I have old versions of different packages, such as PostgreSQL 7.3.4 set up on my desktop.

I am currently trying to set up my laptop and I want to have identical setup to my desctop. Which mean that I want an old version of PG.

So, my question is how to install old versions of Cygwin on my laptop that have old versions of Postgres on my laptop?

P.S. If somebody is interested why I need to install old versions of PosgreSQL on my Windows machine, it's because PgAdmin2 (old versions, which works with PostgreSQL 7.x) can import Access database, but not  PgAdmin3.

Regards.

Alec

[Christopher Faylor-2]

On Wed, Aug 09, 2006 at 02:53:50AM -0700, alecswan wrote:
>I installed Cygwin on my desktop long time ago. So, now I have old versions
>of different packages, such as PostgreSQL 7.3.4 set up on my desktop.
>
>I am currently trying to set up my laptop and I want to have identical setup
>to my desctop. Which mean that I want an old version of PG.
>
>So, my question is how to install old versions of Cygwin on my laptop that
>have old versions of Postgres on my laptop?

You'd need to copy Cygwin from your desktop to your laptop.  Just a drag
n' drop copy of the cygwin folder from your desktop to your laptop
should be sufficient.  Assuming that you're duplicating the layout of
your desktop on your laptop, you'll also need to copy the mount table.
You can do that by generating a .bat file with the appropriate commands
using something like:

mount -m > foo.bat

and running foo.bat under in the MS-DOS console on your laptop.

Finally, you'll need to run mkpasswd and mkgroup doing something like:

bash$ mkpasswd -l > /etc/passwd
bash$ mkgroup -l > /etc/passwd

>P.S. If somebody is interested why I need to install old versions of
>PosgreSQL on my Windows machine, it's because PgAdmin2 (old versions, which
>works with PostgreSQL 7.x) can import Access database, but not  PgAdmin3.

That's fine but there is no way to exactly duplicate your desktop layout
on your laptop using cygwin's setup.exe.
--
Christopher Faylor spammer? -> aaaspam@...
Cygwin Co-Project Leader aaaspam@...

--
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/

[Reini Urban]

alecswan schrieb:

> I installed Cygwin on my desktop long time ago. So, now I have old versions
> of different packages, such as PostgreSQL 7.3.4 set up on my desktop.
>
> I am currently trying to set up my laptop and I want to have identical setup
> to my desctop. Which mean that I want an old version of PG.
>
> So, my question is how to install old versions of Cygwin on my laptop that
> have old versions of Postgres on my laptop?
>
> P.S. If somebody is interested why I need to install old versions of
> PosgreSQL on my Windows machine, it's because PgAdmin2 (old versions, which
> works with PostgreSQL 7.x) can import Access database, but not  PgAdmin3.

PostgreSQL 7.x is still as src in libpq3.
Install the src package for libpq3 and follow the instructions.

Unfortunately it's too much work for me to support parallel postgresql
server versions as in debian.
--
Reini Urban

--
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/

[alecswan]

Christopher,

I must have messed something up while zipping up and copying cygwin from my desktop to my laptop. Now I am getting the following error when running cygwin.bat on desktop or laptop:

"'bash' is not recognized as an internal or external command, operable program or batch file."

Do you have any idea what I messed up?

[Larry Hall (Cygwin)]

alecswan wrote:
> Christopher,
>
> I must have messed something up while zipping up and copying cygwin from my
> desktop to my laptop. Now I am getting this error:
>
> "'bash' is not recognized as an internal or external command, operable
> program or batch file."
>
> Do you have any idea what I messed up?

You forgot 'bash' or your path isn't set up properly so you can find the
copy you do have.  Unless you're missing everything from '/bin' (which
would include 'cygwin1.dll'), I suspect it's the latter point that is
the cause of your problems.

--
Larry Hall                              http://www.rfk.com
RFK Partners, Inc.                      [phone] - RFK Office
216 Dalton Rd.                          [phone] - FAX
Holliston, MA 01746

--
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/

[Christopher Faylor-2]

On Wed, Aug 09, 2006 at 06:35:49PM -0400, Larry Hall (Cygwin) wrote:

>alecswan wrote:
>>Christopher,
>>
>>I must have messed something up while zipping up and copying cygwin from my
>>desktop to my laptop. Now I am getting this error:
>>
>>"'bash' is not recognized as an internal or external command, operable
>>program or batch file."
>>
>>Do you have any idea what I messed up?
>
>You forgot 'bash' or your path isn't set up properly so you can find the
>copy you do have.  Unless you're missing everything from '/bin' (which
>would include 'cygwin1.dll'), I suspect it's the latter point that is
>the cause of your problems.

Or, you didn't recreate the mount table with the .bat file created by
"mount -m"?

Or, if you put the cygwin files on different drives on one system than
on the other, the mount commands and the cygwin.bat file would need to
be modified.

cgf

--
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/

[Reini Urban]

Reini Urban schrieb:

> alecswan schrieb:
>> I installed Cygwin on my desktop long time ago. So, now I have old
>> versions
>> of different packages, such as PostgreSQL 7.3.4 set up on my desktop.
>>
>> I am currently trying to set up my laptop and I want to have identical
>> setup
>> to my desctop. Which mean that I want an old version of PG.
>>
>> So, my question is how to install old versions of Cygwin on my laptop
>> that have old versions of Postgres on my laptop?

Google for the cygwin timemachine.

>> P.S. If somebody is interested why I need to install old versions of
>> PosgreSQL on my Windows machine, it's because PgAdmin2 (old versions,
>> which
>> works with PostgreSQL 7.x) can import Access database, but not  PgAdmin3.
>
> PostgreSQL 7.x is still as src in libpq3.
> Install the src package for libpq3 and follow the instructions.

The old binary postgresql-7.4.5-1 is also available as prev, but it's
hard to convince setup to install it.

> Unfortunately it's too much work for me to support parallel postgresql
> server versions as in debian.

Ok, I'm convinced to prepare a new postgresql74-7.4.13-1 package tree,
which installs into usr/lib/postgres74.
Importing MS-Access seems to be a cool feature.
--
Reini

--
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/

[alecswan]

>Ok, I'm convinced to prepare a new postgresql74-7.4.13-1 package tree,
>which installs into usr/lib/postgres74.
>Importing MS-Access seems to be a cool feature.

Thanks for doing this, Reini.
So when and where can I get the 7.4.x package tree?

[Reini Urban]

alecswan schrieb:
>> Ok, I'm convinced to prepare a new postgresql74-7.4.13-1 package tree,
>> which installs into usr/lib/postgres74.
>> Importing MS-Access seems to be a cool feature.
>
> Thanks for doing this, Reini.
> So when and where can I get the 7.4.x package tree?

I had the first version yesterday, but it needs some more testing for
the side-to-side installation and cleanup.
And right now I have a more important clisp bug to investigate, which
only appears under cygwin.

The old one, which overwrites 8.x can be downloaded e.g. at
http://xarch.tu-graz.ac.at/publ/cygwin/release/postgresql/postgresql-7.4.5-1.tar.bz2 


I expect the new one to be ready at about Monday.
--
Reini

--
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/

[alecswan]

>The old one, which overwrites 8.x can be downloaded e.g. at
>http://xarch.tu-graz.ac.at/publ/cygwin/release/postgresql/postgresql-7.4.5-1.tar.bz2 

I am not sure what's the right way to install the tarball, so I just unzipped it in the root folder. However, I am getting the following error when running initdb:

$ initdb -D /var/db/psql-7.4.5/data/
The program
    /usr/bin/postgres
needed by initdb does not belong to PostgreSQL version 7.4.5, or
there may be a configuration problem.

What am I doing wrong?

--
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/

[Larry Hall (Cygwin)]

alecswan wrote:

>> The old one, which overwrites 8.x can be downloaded e.g. at
>> http://xarch.tu-graz.ac.at/publ/cygwin/release/postgresql/postgresql-7.4.5-1.tar.bz2 
>
> I am not sure what's the right way to install the tarball, so I just
> unzipped it in the root folder. However, I am getting the following error
> when running initdb:
>
> $ initdb -D /var/db/psql-7.4.5/data/
> The program
>     /usr/bin/postgres
> needed by initdb does not belong to PostgreSQL version 7.4.5, or
> there may be a configuration problem.
>
> What am I doing wrong?

Always install with 'setup.exe'.  Never "just unzip" a file if you don't
understand and/or aren't willing to endure the consequences.  At this point,
I'd recommend removing the files you unzipped and then uninstalling V8.x via
'setup.exe' and installing the mentioned tarball via 'setup.exe'.  I don't
know if this will resolve all your problems or not but it is a process that
will put you back into the realm of a supported installation.


--
Larry Hall                              http://www.rfk.com
RFK Partners, Inc.                      [phone] - RFK Office
216 Dalton Rd.                          [phone] - FAX
Holliston, MA 01746

--
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/

[alecswan]

> 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 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?

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.


--
Larry Hall                              http://www.rfk.com
RFK Partners, Inc.                      [phone] - RFK Office
216 Dalton Rd.                          [phone] - FAX
Holliston, MA 01746

--
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/

[Peter A. Castro]

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@...> or <Peter.Castro@...>
  "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/

[Reini Urban]

alecswan schrieb:

>> The old one, which overwrites 8.x can be downloaded e.g. at
>> http://xarch.tu-graz.ac.at/publ/cygwin/release/postgresql/postgresql-7.4.5-1.tar.bz2 
>
> I am not sure what's the right way to install the tarball, so I just
> unzipped it in the root folder. However, I am getting the following error
> when running initdb:
>
> $ initdb -D /var/db/psql-7.4.5/data/
> The program
>     /usr/bin/postgres
> needed by initdb does not belong to PostgreSQL version 7.4.5, or
> there may be a configuration problem.
>
> What am I doing wrong?

You haven't deinstalled postgresql-8.x yet.
First deinstall postgresql and all other postgresql packages (-client,
libpq4 the most important) via setup.exe
You can only install one version so far.
On the side-by-side installation I'm just working now.

1. uninstall 8.x via setup.exe

2. install the mess:
tar xvfz -C / /usr/src/postgresql-7.4.5-1.tar.bz2 | \
   tee /usr/src/postgresql-7.4.5-1.lst

This should be enough then, but be sure to clean up the mess afterwards,
because setup doesn't help you then.

3. read the two readme's (cygwin and default)

4. try it out.

5. uninstall the mess and wait for proper:
cat /usr/src/postgresql-7.4.5-1.lst | xargs rm

Note: 7.4 has a lot of shell scripts without .exe and 8.x has some
binaries in /usr/sbin/.
--
Reini Urban

--
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/