Compilation of PostgreSQL 8.3.7 on Visual Studio 2008

  • Posted on: 17 May 2009
  • By: Michał Turecki

Today I have encountered few problems while trying to compile PostgreSQL on Windows. PostgreSQL designed to work in *nix environments and it's native build system works flawlessly on Linux just as expected. Unfortunatelly on Windows this build system is used by minority of applications, partially using Microsoft's own version of make: nmake.

In PostgreSQL only libpq.dll can be compiled using nmake in Visual Studio Command Prompt which sets all necessary environment variables for compiler and linker (INCLUDE, LIBPATH etc, type set in command prompt to verify these paths).

Make sure you have installed most recent version of the Windows SDK before compiling postgresql, current version is 6.1 and it's default installation path is C:\Program Files\Microsoft SDKs\Windows\v6.1. To compile only libpq.dll in command prompt type following:

nmake /f win32.mak
or optionally:
nmake /f win32.mak DEBUG=1

To build whole project you need to satisfy all requirements regarding win32 build, specified in PostgresSQL documentation ( http://www.postgresql.org/docs/8.3/interactive/install-win32-full.html ). I used ActiveState Perl, but as mentioned in documentation standard distribution would be sufficient, just be sure to update src\tools\msvc\Mkvcbuild.pm if perl version differs from 5.8 ( replace \lib\CORE\perl58.lib with valid perl library path ). When installing these requirements you can specify same folder for all installations, even ActiveState Perl, for example C:\pgbuild, then only bin directory in C:\pgbuild folder must be added to PATH environment variable so all tools could be found by PostgreSQL build scripts.

PostgreSQL 8.3.7 default win32 build scripts are prepared for Visual Studio 8 (2005) and Windows Platform SDK obsoleted by Windows SDK so few changes are necessary to build PostgreSQL:

  1. In Project.pm replace ProjectType="Visual C++" Version="8.00" with ProjectType="Visual C++" Version="9.00"
  2. In src\include\port\win32.h replace #define _WIN32_WINNT 0x0500 with #define _WIN32_WINNT 0x0501 to satisfy requirement for IPPROTO_IPV6 conditionally defined in Windows SDK. Updating src\include\pg_config_os.h might be also necessary.
  3. To build libpq.dll I have needed to supply src\interfaces\libpq\libpq.rc file by copying it from src\interfaces\libpq\libpq.rc.in, elegant solution would be to add:
    "libpq.rc" :
    if not exist "libpq.rc" copy "libpq.rc.in" "libpq.rc"

    to src\interfaces\libpq\win32.mak just before line beginning with: CPP_PROJ=.
  4. Update paths in src\tools\msvc\config.pl to match previously installed dependencies.

To build PostgreSQL just type build in Visual Studio Command Prompt in src\tools\msvc folder. All possible problems would appear yellow and red and generally would be simple to solve by satisfying dependencies like include files (eg. zlib.h) or required libraries (zlib.lib and zdll.lib which need to be grabbed from the net).

Take a look at other tools in src\tools\msvc, clean would be your inseparable friend and install with destination folder passed as parameter will ease an installation of your fresh PostgreSQL build.

Have fun hacking pg and feel free to comment your experiences.

Comments

Keflex And Breastfeeding Prix Viagra Pfizer Pharmacie En Merignac Cephalexin For Dog No Prescriptions cheap cialis Propecia Concierto Cheapest Viagra Prices

Keflex And Breastfeeding Prix Viagra Pfizer Pharmacie En Merignac Cephalexin For Dog No Prescriptions cheap cialis Propecia Concierto Cheapest Viagra Prices

Canadianpharmacies Levitra Mercado Libre Gnc Substitute For Viagra generico de priligy Cialis For Sale Philippines Can Amoxicillin Cause A Rash Amoxil Dosage Weight

Canadianpharmacies Levitra Mercado Libre Gnc Substitute For Viagra generico de priligy Cialis For Sale Philippines Can Amoxicillin Cause A Rash Amoxil Dosage Weight

Alli Diet Pills Sale Canada buy generic cialis Difference Entre Cialis Apcalis

Alli Diet Pills Sale Canada buy generic cialis Difference Entre Cialis Apcalis

Caratteristiche Levitra Online Cialis Pharmacy viagra Order Now Zentel Best Website C.O.D. Mastercard On Line

Caratteristiche Levitra Online Cialis Pharmacy viagra Order Now Zentel Best Website C.O.D. Mastercard On Line

Buy Prevacid Otc 122 Order Meds Without A Script Amoxicillin Buy Uk viagra online pharmacy Pyridium 200mg By Money Order Levitra Online Drugstore Decadron 60 Pills 1 Mg Buy Paypal

Buy Prevacid Otc 122 Order Meds Without A Script Amoxicillin Buy Uk viagra online pharmacy Pyridium 200mg By Money Order Levitra Online Drugstore Decadron 60 Pills 1 Mg Buy Paypal

Levaquin Best Website In Internet Mastercard Nolvadex Homme Cialis Dolor De Espalda buy propecia 1 mg online safely Prix Cialis Viagra Zithromax Zpak Generiques Sans Ordonnance

Levaquin Best Website In Internet Mastercard Nolvadex Homme Cialis Dolor De Espalda buy propecia 1 mg online safely Prix Cialis Viagra Zithromax Zpak Generiques Sans Ordonnance

Levaquin Best Website In Internet Mastercard Nolvadex Homme Cialis Dolor De Espalda buy propecia 1 mg online safely Prix Cialis Viagra Zithromax Zpak Generiques Sans Ordonnance

What’s this category about? Top Porn Search Engine contains the best search engines that specialize in porn content. Everyone nowadays knows what a search engine is, but not everyone knows that one like Bing can be a very important ally to find the best porn sites on the internet! Of course, we all rely on Google to search most things, but if you are tired of incurring in its censorship, then you can use the search engines we have listed for you, to help you improve your search. Using this list we have provided, you will be able to find top free porn videos and images, either homemade or professional. These engines work equally fine from your computer, tablet or mobile phones so that you don’t have to stop your search when you are on the move. What are the best Search Engines for porn? After a careful study of the most remarkable ones, we came up with a list that you’ll find very handy and accurate. Did you know that also Yahoo can help your porn search? And in a much more discreet way than Google too. Our parameters to decide which engines could have suited our users the most have been things like these sites’ design, how easy it is to access them and, most importantly the results’ quality. It’s very important that the results you get are accurate because there is nothing more annoying than clicking on several pages that do not deliver the porn content you were looking for, especially when you are very horny and are just looking to have a wank in the fastest way possible. Also, the results that come up before the others are to be taken into consideration, the accuracy of the results’ order, to say it in another way. It is very important that these porn search engines narrow the search for you and limit it to only the best porn sites, otherwise you’ll end up getting a host of crappy results that have no use for you at all. These sex portals we have listed here are trustworthy and won’t give you any hassles, you’ll be more than satisfied with the heaps of hot results you’ll get. Some of those we found and ranked is really straight to the point. Adult Video Finder, for instance, is great, first of all, you have to select if you are gay or straight, and this is important to narrow the search immensely already. Then you can avail of the classic search bar or you can venture in the featured or most recent videos. You also have the possibility to search among all the porn categories listed, and you can view the number of results that are indicated per each category. The featured videos have a descriptive title, a time tag of when they were uploaded, the duration and also the source from where they have been taken. You basically are all sorted with just one sex site and you don’t really need to go anywhere else. You may as well stay here for weeks! To conclude, if you have been wondering why you should use a porn search engine I hope now you know the answer. There are way too many good reasons and if you still don’t see the point I would start worrying. The whole point is, why settling for something that is not as good? You should always aim for the best, you deserve it, you have been working hard! So, as soon as you get the chance make your way over to the hollyporno and try these out hollyporno adultpornmovie xxndx pornminutes xxxvideotuber sluttyteensex freexxxstuf freexvideotube fastmobiporn sextubesvideos toutpornxxx sextresss hotmomteenxxx sexmagxxx pornotrixxx, one by one, have a little play and see which one suits you best then relax, unwind and enjoy!

Viagra Kaufen Mit Paypal Cialis Och Alkohol cialis Buy Cipro No Prescription

Viagra Kaufen Mit Paypal Cialis Och Alkohol cialis Buy Cipro No Prescription

Viagra E Cialis Problemi Guidelines For Prescribing Amoxicillin viagra Cialis Rischio Infarto

Viagra E Cialis Problemi Guidelines For Prescribing Amoxicillin viagra Cialis Rischio Infarto

Propecia Liver Damage Forum Levitra Sans Ordonnance Order Now Bentyl 20mg Best Website Internet buy cialis online Cialis Pills Online Google. Viagra India Viagra Pharmacy Online

Propecia Liver Damage Forum Levitra Sans Ordonnance Order Now Bentyl 20mg Best Website Internet buy cialis online Cialis Pills Online Google. Viagra India Viagra Pharmacy Online

Propecia Liver Damage Forum Levitra Sans Ordonnance Order Now Bentyl 20mg Best Website Internet buy cialis online Cialis Pills Online Google. Viagra India Viagra Pharmacy Online

Buy Propecia For Acne order cialis online Discount Finasteride

Buy Propecia For Acne order cialis online Discount Finasteride

Buy Propecia For Acne order cialis online Discount Finasteride

Prezzo Viagra Pfizer Cephalexin 500mg 500ct cheap cialis Buy Xenical Without Rx

Prezzo Viagra Pfizer Cephalexin 500mg 500ct cheap cialis Buy Xenical Without Rx

postgresql-9 complaint about missing strings.h & stdint.h
any suggestion?

Your guide also works with postgresql 8.4 thanx. /pete