Thread: compiling source code!!!!!!!!!!!!!!!!!!!!!!!!!!!!!

compiling source code!!!!!!!!!!!!!!!!!!!!!!!!!!!!!

From
sibel karaasma
Date:
Hi I'm a new postgresql user. I wrote ACO (ant colony optimazition) and <br />want to replace it with GEQO in
postres/src/backend/optimizerbut I don't know how <br />to compile and run the source code :(<br />   <br />  I
installedpostgresql-8.1.3 and cygwin but I can not use them to <br />compile the source code. I want to compare GEQO
andACO optimizers performance using a small database<br />   <br />  Can you help me???????<br /><p><hr size="1"
/>Yahoo!Messenger with Voice. <a
href="http://us.rd.yahoo.com/mail_us/taglines/postman1/*http://us.rd.yahoo.com/evt=39663/*http://voice.yahoo.com">Make
PC-to-PhoneCalls</a> to the US (and 30+ countries) for 2¢/min or less. 

Re: compiling source code!!!!!!!!!!!!!!!!!!!!!!!!!!!!!

From
Reini Urban
Date:
sibel karaasma schrieb:
> Hi I'm a new postgresql user. I wrote ACO (ant colony optimazition) and
> want to replace it with GEQO in postres/src/backend/optimizer but I
> don't know how
> to compile and run the source code :(
>   
>   I installed postgresql-8.1.3 and cygwin but I can not use them to
> compile the source code. I want to compare GEQO and ACO optimizers
> performance using a small database
>    
>   Can you help me???????

download the src package via cygwin.com/setup.exe
and check out the buildscript to see the used configure parameters and
get all the dependencies right.

-- 
Reini


Re: compiling source code!!!!!!!!!!!!!!!!!!!!!!!!!!!!!

From
"Jim C. Nasby"
Date:
On Wed, May 24, 2006 at 01:46:19AM -0700, sibel karaasma wrote:
> Hi I'm a new postgresql user. I wrote ACO (ant colony optimazition) and 
> want to replace it with GEQO in postres/src/backend/optimizer but I don't know how 
> to compile and run the source code :(
>    
>   I installed postgresql-8.1.3 and cygwin but I can not use them to 
> compile the source code. I want to compare GEQO and ACO optimizers performance using a small database

mingw is now the approved build method for windows, and I think there's
instructions on how to build PostgreSQL with it somewhere, though I
can't seem to find them now. Though to be honest, you'd probably find it
easier doing development on any kind of a unix box, including OS X.
-- 
Jim C. Nasby, Sr. Engineering Consultant      jnasby@pervasive.com
Pervasive Software      http://pervasive.com    work: 512-231-6117
vcard: http://jim.nasby.net/pervasive.vcf       cell: 512-569-9461


Re: compiling source code!!!!!!!!!!!!!!!!!!!!!!!!!!!!!

From
"Gurjeet Singh"
Date:
Hi Sibel,
   Here's the mail that I posted about 10 days ago about compiling
and debugging postgres on windows. I have used msys/mingw toolkit and
it is the recommended (by pg community) toolkit to compile postgres on
windows.
   http://archives.postgresql.org/pgsql-hackers/2006-05/msg00396.php

Hope it helps. Do let me know if you face any problems.

Regards,
Gurjeet.

On 5/25/06, Jim C. Nasby <jnasby@pervasive.com> wrote:
> On Wed, May 24, 2006 at 01:46:19AM -0700, sibel karaasma wrote:
> > Hi I'm a new postgresql user. I wrote ACO (ant colony optimazition) and
> > want to replace it with GEQO in postres/src/backend/optimizer but I don't know how
> > to compile and run the source code :(
> >
> >   I installed postgresql-8.1.3 and cygwin but I can not use them to
> > compile the source code. I want to compare GEQO and ACO optimizers performance using a small database
>
> mingw is now the approved build method for windows, and I think there's
> instructions on how to build PostgreSQL with it somewhere, though I
> can't seem to find them now. Though to be honest, you'd probably find it
> easier doing development on any kind of a unix box, including OS X.
> --
> Jim C. Nasby, Sr. Engineering Consultant      jnasby@pervasive.com
> Pervasive Software      http://pervasive.com    work: 512-231-6117
> vcard: http://jim.nasby.net/pervasive.vcf       cell: 512-569-9461
>
> ---------------------------(end of broadcast)---------------------------
> TIP 3: Have you checked our extensive FAQ?
>
>                http://www.postgresql.org/docs/faq
>


Re: compiling source code!!!!!!!!!!!!!!!!!!!!!!!!!!!!!

From
"Gurjeet Singh"
Date:
    Also, I would recommend uninstalling cygwin before you install
mingw, because if the mingw doesn't behave properly (gcc won't compile
files etc...), you could be sure that there definitely is a conflict
between the cygwin and mingw.
   If you don't wish to uninstall cygwin, at least rename the folder
to someting else (cygwin.before.mingw) so that you don't accidentally
use cygwin's binaries.

Regards,
Gurjeet.

On 5/25/06, Gurjeet Singh <singh.gurjeet@gmail.com> wrote:
> Hi Sibel,
>
>     Here's the mail that I posted about 10 days ago about compiling
> and debugging postgres on windows. I have used msys/mingw toolkit and
> it is the recommended (by pg community) toolkit to compile postgres on
> windows.
>
>     http://archives.postgresql.org/pgsql-hackers/2006-05/msg00396.php
>
> Hope it helps. Do let me know if you face any problems.
>
> Regards,
> Gurjeet.
>
> On 5/25/06, Jim C. Nasby <jnasby@pervasive.com> wrote:
> > On Wed, May 24, 2006 at 01:46:19AM -0700, sibel karaasma wrote:
> > > Hi I'm a new postgresql user. I wrote ACO (ant colony optimazition) and
> > > want to replace it with GEQO in postres/src/backend/optimizer but I don't know how
> > > to compile and run the source code :(
> > >
> > >   I installed postgresql-8.1.3 and cygwin but I can not use them to
> > > compile the source code. I want to compare GEQO and ACO optimizers performance using a small database
> >
> > mingw is now the approved build method for windows, and I think there's
> > instructions on how to build PostgreSQL with it somewhere, though I
> > can't seem to find them now. Though to be honest, you'd probably find it
> > easier doing development on any kind of a unix box, including OS X.
> > --
> > Jim C. Nasby, Sr. Engineering Consultant      jnasby@pervasive.com
> > Pervasive Software      http://pervasive.com    work: 512-231-6117
> > vcard: http://jim.nasby.net/pervasive.vcf       cell: 512-569-9461
> >
> > ---------------------------(end of broadcast)---------------------------
> > TIP 3: Have you checked our extensive FAQ?
> >
> >                http://www.postgresql.org/docs/faq
> >
>


Re: compiling source code!!!!!!!!!!!!!!!!!!!!!!!!!!!!!

From
"Andrew Dunstan"
Date:
Gurjeet Singh said:
>    Also, I would recommend uninstalling cygwin before you install
> mingw, because if the mingw doesn't behave properly (gcc won't compile
> files etc...), you could be sure that there definitely is a conflict
> between the cygwin and mingw.
>
>    If you don't wish to uninstall cygwin, at least rename the folder
> to someting else (cygwin.before.mingw) so that you don't accidentally
> use cygwin's binaries.


This is complete nonsense. I have Cygwin and Mingw/Msys living quite happily
side by side on the same box. Each is largely ignorant of the other.

Of course, if you add Cygwin to the system path you can cause problems, so
don't do that. But there is no need at all that I know of to uninstall or
rename anything.

If you have problems with your setup please ask for help, instead of handing
out wrong advice.

cheers

andrew




Re: compiling source code!!!!!!!!!!!!!!!!!!!!!!!!!!!!!

From
"Gurjeet Singh"
Date:
    I was just telling one of the ways to avoid the conflicts. It
generally happens that a newbie adds the cygwin paths to the env
variables and if he forgets to remove those, then, you know better,
which tools he'd be using!!! In such cases, a less experienced person
would just give up.
   I remember that if I hadn't had that small peice of advice from
AumAum, I was on the verge of giving up on trying the mingw
installation aftar failing 3 times!!!

<quote>
It's crucial to crack the tarballs into /mingw (C:\msys\n.n\mingw),
because if you crack any of them into / (C:\msys\n.n), you'll cause
some subtle conflicts between MSYS and the MinGW tools which will
cause your compilations to fail.
</quote>from http://www.mingw.org/MinGWiki/index.php/RealDumbQuickstart
    So my suggestion was just to at least rename the folder
temporarily till sibel gets everything started.
   Moreover, I dont think one would need cygwin after having mingw. I
might be wrong!
   Yes, I agree your approach is more non-intrusive.
   Sibel, just add the method of 'removing cygwin's paths from
environment variables (if they exist)' to the top of the
pre-requisites-list before you try installing mingw.
   Sorry for uiintentionally misleading someone, if I did!

Regards,
Gurjeet

On 5/25/06, Andrew Dunstan <andrew@dunslane.net> wrote:
> Gurjeet Singh said:
> >    Also, I would recommend uninstalling cygwin before you install
> > mingw,

> >    If you don't wish to uninstall cygwin, at least rename the folder
> > to someting else (cygwin.before.mingw) so that you don't accidentally
> > use cygwin's binaries.
>
>
> This is complete nonsense. I have Cygwin and Mingw/Msys living quite happily
> side by side on the same box. Each is largely ignorant of the other.
>
> Of course, if you add Cygwin to the system path you can cause problems, so
> don't do that. But there is no need at all that I know of to uninstall or
> rename anything.
>
> If you have problems with your setup please ask for help, instead of handing
> out wrong advice.
>
> cheers
>
> andrew