Re: [GENERAL] compiling postgres_fdw fails for 9.6.5

2017-10-06 Thread Tom Lane
Sandeep Gupta writes: > I downloaded the source, configured it with prefix=install_dir and > then moved to contrib/postgres_fdw dir. > However make fails with following error: > ../../src/include/utils/elog.h:71:28: fatal error: utils/errcodes.h: > No such file or directory Try building the core

[GENERAL] compiling postgres_fdw fails for 9.6.5

2017-10-06 Thread Sandeep Gupta
Hello, I am on Cent OS 6.8 machine. The Postgres is already installed in some install_dir/. I downloaded the source, configured it with prefix=install_dir and then moved to contrib/postgres_fdw dir. However make fails with following error: gcc -Wall -Wmissing-prototypes -Wpointer-arith -Wdeclarat

Re: [GENERAL] Compiling libpq only on Linux

2017-08-08 Thread Peter Eisentraut
On 8/8/17 14:49, Igor Korot wrote: > Quick question - what is the best way to compile libpq only on Linux? > Should I grab it, unpack it and do configure and then make inside > libpq directory > manually? Pretty much yes. > Or there is some other way? You could look for updated distribution pac

[GENERAL] Compiling libpq only on Linux

2017-08-08 Thread Igor Korot
Hi, ALL, Quick question - what is the best way to compile libpq only on Linux? I just checked and currently my distro (I didn't updated in a long time) has 9.5 version as current. Should I grab it, unpack it and do configure and then make inside libpq directory manually? Or there is some other

Re: [GENERAL] compiling postgresql 9.2.4 on fedora 17 64 bit takes very long time

2013-06-08 Thread Jeff Janes
On Sat, Jun 8, 2013 at 12:46 PM, Scott Marlowe wrote: > Just for reference, way back in the day my laptop w/486DX50 and 16 > megs of RAM took 30 minutes to run ./configure and 1.5 hours to run > make. > Using MinGW and a modern laptop, it does slightly better than that. But not much. Just runni

Re: [GENERAL] compiling postgresql 9.2.4 on fedora 17 64 bit takes very long time

2013-06-08 Thread Scott Marlowe
Just for reference, way back in the day my laptop w/486DX50 and 16 megs of RAM took 30 minutes to run ./configure and 1.5 hours to run make. -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-genera

Re: [GENERAL] compiling postgresql 9.2.4 on fedora 17 64 bit takes very long time

2013-06-08 Thread c k
I changed the hwclock and date/time of the system and synced hwclock with date/time. hwclock was showing a date around a year ago, which may be due to some incorrect selection during setup. I will compile again when I will get access to the server. I will remember it and will check for other compil

Re: [GENERAL] compiling postgresql 9.2.4 on fedora 17 64 bit takes very long time

2013-06-07 Thread Tom Lane
c k writes: > Yesterday we configured a new server with Fedora 17 64 bit and updated it's > kernel to 3.8. I have to compile and install postgresql with python. So I > executed commands > ./configure --with-python > make > but make is running for last 16 hours and still not completed. It is > sh

[GENERAL] compiling postgresql 9.2.4 on fedora 17 64 bit takes very long time

2013-06-06 Thread c k
Hi, Yesterday we configured a new server with Fedora 17 64 bit and updated it's kernel to 3.8. I have to compile and install postgresql with python. So I executed commands ./configure --with-python make but make is running for last 16 hours and still not completed. It is showing same messages aga

Re: [GENERAL] Compiling C function with VC++ for Windows version

2012-01-13 Thread Edwin Quijada
> Date: Fri, 13 Jan 2012 14:44:24 +0800 > From: ring...@ringerc.id.au > To: listas_quij...@hotmail.com; pgsql-general@postgresql.org > Subject: Re: [GENERAL] Compiling C function with VC++ for Windows version > > On 13/01/2012 1:55 AM, Edwin Quijada wrote: > > > >

Re: [GENERAL] Compiling C function with VC++ for Windows version

2012-01-12 Thread Craig Ringer
On 13/01/2012 1:55 AM, Edwin Quijada wrote: Ok. This is the way that I compile. Linux this way works fine and I use the modules compiled. of course, Linux I compile from source and I use gcc. Yep... but Windows isn't Linux. In particular, the distributions of PostgreSQL for Windows are compi

Re: [GENERAL] Compiling C function with VC++ for Windows version

2012-01-12 Thread Edwin Quijada
Date: Thu, 12 Jan 2012 13:45:06 +0800 From: ring...@ringerc.id.au To: listas_quij...@hotmail.com CC: pgsql-general@postgresql.org Subject: Re: [GENERAL] Compiling C function with VC++ for Windows version On 12/01/12 11:06, Edwin Quijada wrote

Re: [GENERAL] Compiling C function with VC++ for Windows version

2012-01-11 Thread Craig Ringer
On 12/01/12 11:06, Edwin Quijada wrote: > Hi! > I am trying to create a C function for windows in Postgres compiling > with VC++ 2008 Express Edition. I did this function for Linux without > problem using gcc and tried to do the same in Windows but in Windows > was imposible. The function compile f

[GENERAL] Compiling C function with VC++ for Windows version

2012-01-11 Thread Edwin Quijada
Hi!I am trying to create a C function for windows in Postgres compiling with VC++ 2008 Express Edition. I did this function for Linux without problem using gcc and tried to do the same in Windows but in Windows was imposible. The function compile fine but when I tried to run from Postgres it do

[GENERAL] Compiling PostgreSql 9.0 on Sparc Solaris (64 bit)

2010-11-03 Thread Gerrit Seré
Hallo A few weeks ago, we saw questions on the mailing list about compiling PostgreSql on Solaris Sparc. Compiling on Solaris is always an adventure. It took us nearly a 2 weeks for compiling and making a package for PostgreSql and Postgis. We heavily use spare zones. That's one of the reasons

Re: [GENERAL] Compiling openssl

2010-09-22 Thread Alban Hertroys
On 22 Sep 2010, at 22:00, Awodipe James wrote: > Good day, > Is it possible to use any of your products to compile openssl-1.0.0a.tar.gz No. Relational databases aren't generally used to compile code ;) I think you're looking to contact the guys of Mingw/Msys or possibly Cygwin. Alban Hertroys

[GENERAL] Compiling openssl

2010-09-22 Thread Awodipe James
Good day, Is it possible to use any of your products to compile openssl-1.0.0a.tar.gz form http://www.openssl.org/source/ for Win32 environment, how? OR can you help complile it with this adjustment to the makefile: To build, I needed to modify the first lines of the example code's Makefile as

[GENERAL] Compiling with MinGW in windows , compile but my server down

2010-09-08 Thread Edwin Quijada
Hi!! I could compile my windows extension for Postgres but now when I try to run this extension my server goes down. I compiled using Mingw and this line C:\mingw\bin\gcc -O2 -Wall -Wmissing-prototypes -Wpointer-arith -Wdeclaration-after-statement -Wendif-labels -fno-strict-aliasing -fwrapv

Re: [GENERAL] Compiling extension C with MingW in windows, Error...

2010-09-06 Thread Magnus Hagander
On Fri, Sep 3, 2010 at 18:23, Edwin Quijada wrote: > >> Date: Fri, 3 Sep 2010 09:41:17 +0200 >> Subject: Re: [GENERAL] Compiling extension C with MingW in windows, >> Error... >> From: mag...@hagander.net >> To: listas_quij...@hotmail.com >> CC: pgsql-gen

Re: [GENERAL] Compiling extension C with MingW in windows, Error...

2010-09-03 Thread Edwin Quijada
> Date: Fri, 3 Sep 2010 09:41:17 +0200 > Subject: Re: [GENERAL] Compiling extension C with MingW in windows, Error... > From: mag...@hagander.net > To: listas_quij...@hotmail.com > CC: pgsql-general@postgresql.org > > On Fri, Sep 3, 2010 at 5:31 AM, Edwin Quijada &

Re: [GENERAL] Compiling extension C with MingW in windows, Error...

2010-09-03 Thread Magnus Hagander
On Fri, Sep 3, 2010 at 5:31 AM, Edwin Quijada wrote: > Hi, I am tryng to compile a C extension in windows using Minigw but always I > get the same error > > C:\Program Files\PostgreSQL\8.3\share\exte_c>C:\mingw\bin\gcc -shared -o > pg2.dll >  pg2.o > pg2.o:pg2.c:(.text+0x86): undefined reference t

[GENERAL] Compiling extension C with MingW in windows, Error...

2010-09-02 Thread Edwin Quijada
Hi, I am tryng to compile a C extension in windows using Minigw but always I get the same error C:\Program Files\PostgreSQL\8.3\share\exte_c>C:\mingw\bin\gcc -shared -o pg2.dll pg2.o pg2.o:pg2.c:(.text+0x86): undefined reference to `_imp__CurrentMemoryContext' pg2.o:pg2.c:(.text+0x92): undefine

Re: [GENERAL] Compiling .pgc programs gives error

2010-02-19 Thread Tom Lane
"mike stanton" writes: > I have a problem compiling pgc programs with ecpg. > I always get the following error: > /usr/local/pgsql/lib/libpgtypes.a(timestamp.o): In function `timestamp2tm': > timestamp.c:(.text+0x2fc): undefined reference to `rint' Seems like you need to add "-lm" to your link c

[GENERAL] Compiling .pgc programs gives error

2010-02-19 Thread mike stanton
I have a problem compiling pgc programs with ecpg. I always get the following error: /usr/local/pgsql/lib/libpgtypes.a(timestamp.o): In function `timestamp2tm': timestamp.c:(.text+0x2fc): undefined reference to `rint' Version: PostgreSQL 8.3.6 on i686-pc-linux-gnu, compiled by GCC gcc (GCC) 4.2.4

Re: [GENERAL] Compiling using Visual Studio 2005

2009-07-07 Thread Ms swati chande
Hi,   You may obtain the required files from: http://winpg.jp/~saito/pg_work/OSSP_win32/msvc/ for MS-VC++, by Hiroshi Saito   Copy uuid.h and uuid.lib from here to appropriate folders and it should work.   Swati Chande  

[GENERAL] Compiling using Visual Studio 2005

2009-07-07 Thread Vikram Patil
Hello Folks, I am trying to compile PostgreSQL source code using Visual Studio 2005 . I am able to compile psql but while compiling .\contrib\uuid-ossp\uuid-ossp. I encountered following error. ecpg : warning PRJ0009: Build log could not be opened for writing. .\contrib\uuid-ossp\uuid-os

Re: [GENERAL] compiling postgres for 64 bit windows using mingw64

2009-07-02 Thread Tom Lane
"McWilliams, Steven" writes: > I am wondering if anyone has successfully compiled postgres for 64 bit > windows using mingw64? We don't currently support 64-bit builds on Windows. There are a pile of issues there, most coming from Microsoft's nonstandard decision to make sizeof(long) != sizeof(p

[GENERAL] compiling postgres for 64 bit windows using mingw64

2009-07-02 Thread McWilliams, Steven
Hello, I am wondering if anyone has successfully compiled postgres for 64 bit windows using mingw64? I tried doing so but the "configure" step fails with the following message: conftest.c:50: error: conflicting types for 'accept' The config.log file shows the following additional message: c:

Re: [GENERAL] Compiling Pl/Java

2009-06-22 Thread Kris Jurka
On Mon, 22 Jun 2009, Jorge Vidal - Disytel wrote: I've been trying to compile pl/java from cvs with no success. Is it going to be avaiable for pg 8.4 ? pl/java CVS builds against 8.4. A common gotcha is that pljava will only build with JDK 1.4 or 1.5 and fails with 1.6. It can be run

[GENERAL] Compiling Pl/Java

2009-06-22 Thread Jorge Vidal - Disytel
Hi community, I've been trying to compile pl/java from cvs with no success. Is it going to be avaiable for pg 8.4 ? We are going to run some intensive test on our system, and I thought it was a good idea to test it under 8.4, but for that I need pl/java... Jorge -- Sent via pgsql-general m

[GENERAL] compiling c function using MinGW

2009-04-06 Thread eehab hamzeh
this is how i write the command in MinGW any more direction about I. I am a new user for MinGW gcc -shared -o hamzeh.dll tt1.o -L "c:/programme/postgresql/8.3/lib" -lpostgres Thanks Ihab > > 2009/4/6 eehab hamzeh : > > Hello > > > > I am trying to build some functions using C languag

[GENERAL] compiling libpq.lb into qsqlpsql.dll

2009-01-27 Thread justin
Hello all. I have a problem and tech support at troll tech has been unable to help me resolve.   I am trying to compile libpq.lib from postgresql 8.3.5 into QT's version 4.4.3 qsqlpsql.dll. using Visual Studio 2008 Built libpq.lib and libpq.dll with no problesm using nmake. Now comes time t

Re: [GENERAL] Compiling 8.4devel on OpenSolaris2008.11 with SunStudioExpress

2008-12-26 Thread Emanuel Calvo Franco
2008/12/24 Tom Lane : > "Emanuel Calvo Franco" writes: >> But when i want to make, i recieved an error (make and >> /opt/SunStudioExpress/bin/dmake ): >> "... >> eca...@lastchance:~/Desktop/postgresql-snapshot$ sudo make >> You must use GNU make to build PostgreSQL. > > What do you find unclear ab

Re: [GENERAL] Compiling 8.4devel on OpenSolaris2008.11 with SunStudioExpress

2008-12-24 Thread Tom Lane
"Emanuel Calvo Franco" writes: > But when i want to make, i recieved an error (make and > /opt/SunStudioExpress/bin/dmake ): > "... > eca...@lastchance:~/Desktop/postgresql-snapshot$ sudo make > You must use GNU make to build PostgreSQL. What do you find unclear about that message? Install gmake

[GENERAL] Compiling 8.4devel on OpenSolaris2008.11 with SunStudioExpress

2008-12-24 Thread Emanuel Calvo Franco
Hi for everyone, i download yesterday the ftp snapshot of the 8.4devel. I configure with: ./configure --prefix=/usr/local/pg84devel CC=/opt/SunStudioExpress/bin/cc CFLAGS="-xO3 -xarch=native \ -xspace -W0,-Lt -W2,-Rcond_elim -Xa -xildoff -xc99=none -xCC" --with-perl --with-python --enable-dtrace

Re: [GENERAL] compiling libpq.dll with Borland C++, is it possible?

2008-11-21 Thread Martin Gainty
content contained within this transmission. > Date: Fri, 21 Nov 2008 21:22:11 +0100 > From: [EMAIL PROTECTED] > To: [EMAIL PROTECTED] > CC: [EMAIL PROTECTED]; pgsql-general@postgresql.org > Subject: Re: [GENERAL] compiling libpq.dll with Borland C++, is it possible? > &g

Re: [GENERAL] compiling libpq.dll with Borland C++, is it possible?

2008-11-21 Thread Magnus Hagander
Alvaro Herrera wrote: > Tony Caduto wrote: >> Hi, >> I am trying to compile my own copy of libpq.dll using bcc32.exe, the >> docs say it is possible, but I get a error when it tries to compile >> dirent.c > > How hard would it be to set up a buildfarm member that exercises the > Borland compile

Re: [GENERAL] compiling libpq.dll with Borland C++, is it possible?

2008-11-20 Thread Alvaro Herrera
Tony Caduto wrote: > Hi, > I am trying to compile my own copy of libpq.dll using bcc32.exe, the > docs say it is possible, but I get a error when it tries to compile > dirent.c How hard would it be to set up a buildfarm member that exercises the Borland compiler? If it only compiles client cod

Re: [GENERAL] compiling libpq.dll with Borland C++, is it possible?

2008-11-20 Thread Bruce Momjian
Tony Caduto wrote: > Hi, > I am trying to compile my own copy of libpq.dll using bcc32.exe, the > docs say it is possible, but I get a error when it tries to compile dirent.c > Has anyone been able to do this? Oh, that's a shame. We usually get feedback once per major release from Borland CC us

[GENERAL] compiling libpq.dll with Borland C++, is it possible?

2008-11-17 Thread Tony Caduto
Hi, I am trying to compile my own copy of libpq.dll using bcc32.exe, the docs say it is possible, but I get a error when it tries to compile dirent.c Has anyone been able to do this? C:\postgresql-8.3.5\src\interfaces\libpq>make -N -DCFG=Release /f bcc32.mak MAKE Version 5.3 Copyright (c) 19

[GENERAL] Compiling C Trigger function

2008-09-03 Thread pw
Hello, I am attempting to compile a C trigger function for use with Postgresql. The function uses SPI and I am comiling in linux using gcc. The compiler is finding all the correct headers but complains that it can't find the SPI functions. I am compiling with -lpq . Do I need to compile with

Re: [GENERAL] compiling Xpath functions in PostgreSQL 8.3.3

2008-08-11 Thread Peter Eisentraut
Am Wednesday, 6. August 2008 schrieb sagswe: > When i run ' \i  /usr/local/pgsql/share/pgxml.sql' in postgre , I get error > saying file or directory named 'MODULE_PATHNAME' doesn't exist. How to get > this MODULE_PATHNAME exist?. This sounds like your installation is botched? How did you install

[GENERAL] compiling Xpath functions in PostgreSQL 8.3.3

2008-08-08 Thread sagswe
Hi, I was trying to install postgreSQL with XML data type support. My OS is ubuntu , kernel 2.6.15.. PostgresSQL version is 8.3.3 .I have libxml2 and libxslt installed. I configured using ./configure --with-libxml --with-libxslt configure went fine.. 'make all' went fine 'make install' went fine.

Re: [GENERAL] compiling, performance of PostGreSQL 8.3 on 64-bit processors

2008-06-29 Thread Greg Smith
On Thu, 26 Jun 2008, Adam Rich wrote: Is there any benefit to running a 32-bit OS (rhel 5 in this case) on a server with more than 4 GB of memory? If you have more than 3GB of memory, you should be using a 64-bit OS. While theoretically the 32-bit code might be smaller which has some advanta

Re: [GENERAL] compiling, performance of PostGreSQL 8.3 on 64-bit processors

2008-06-27 Thread Scott Marlowe
On Fri, Jun 27, 2008 at 10:21 AM, Tom Lane <[EMAIL PROTECTED]> wrote: > "Douglas McNaught" <[EMAIL PROTECTED]> writes: >> On Fri, Jun 27, 2008 at 11:52 AM, Benjamin Weaver >> <[EMAIL PROTECTED]> wrote: >>> Not knowing about such things, I was scared by the following quote. > >> Distro support for 6

Re: [GENERAL] compiling, performance of PostGreSQL 8.3 on 64-bit processors

2008-06-27 Thread Douglas McNaught
On Fri, Jun 27, 2008 at 11:52 AM, Benjamin Weaver <[EMAIL PROTECTED]> wrote: > Sorry, guys, for wasting bandwidth on this! You guys gave just the answer I > wanted to hear. Sounds like there aren't any problems. > > Not knowing about such things, I was scared by the following quote. Perhaps > bi

Re: [GENERAL] compiling, performance of PostGreSQL 8.3 on 64-bit processors

2008-06-27 Thread Tom Lane
"Douglas McNaught" <[EMAIL PROTECTED]> writes: > On Fri, Jun 27, 2008 at 11:52 AM, Benjamin Weaver > <[EMAIL PROTECTED]> wrote: >> Not knowing about such things, I was scared by the following quote. > Distro support for 64-bit x86 in 2004 was light-years behind where it > is now. A lot of stuff w

Re: [GENERAL] compiling, performance of PostGreSQL 8.3 on 64-bit processors

2008-06-27 Thread Benjamin Weaver
Sorry, guys, for wasting bandwidth on this! You guys gave just the answer I wanted to hear. Sounds like there aren't any problems. Not knowing about such things, I was scared by the following quote. Perhaps binaries do not need to be compiled as 64 bit binaries on a 64 bit machine? Or perhaps

Re: [GENERAL] compiling, performance of PostGreSQL 8.3 on 64-bit processors

2008-06-26 Thread Tom Lane
Greg Smith <[EMAIL PROTECTED]> writes: > On Thu, 26 Jun 2008, Benjamin Weaver wrote: >> I have heard of problems arising from compiling PostGreSQL (8.3) on >> 64-bit processors. > From who? Perhaps someone who remembers PG 6.4 or thereabouts? Certainly any version released in the last couple of

Re: [GENERAL] compiling, performance of PostGreSQL 8.3 on 64-bit processors

2008-06-26 Thread Ben
On Thu, 26 Jun 2008, Benjamin Weaver wrote: Dear All, 1. I have heard of problems arising from compiling PostGreSQL (8.3) on 64-bit processors. What sort of problems am I likely to encounter and how should I fix them? We are will run Linux Redhat 5 on a Dell PE2950 III Quad Core Xeon E54 2.3

Re: [GENERAL] compiling, performance of PostGreSQL 8.3 on 64-bit processors

2008-06-26 Thread Douglas McNaught
On Thu, Jun 26, 2008 at 7:12 PM, Adam Rich <[EMAIL PROTECTED]> wrote: > >> 1. I have heard of problems arising from compiling PostGreSQL (8.3) on >> 64-bit >> processors. What sort of problems am I likely to encounter and how >> should I fix >> them? We are will run Linux Redhat 5 on a Dell PE29

Re: [GENERAL] compiling, performance of PostGreSQL 8.3 on 64-bit processors

2008-06-26 Thread Greg Smith
On Thu, 26 Jun 2008, Benjamin Weaver wrote: I have heard of problems arising from compiling PostGreSQL (8.3) on 64-bit processors. From who? We are will run Linux Redhat 5 If there were any problems compiling and running PostgreSQL on 64-bit RHEL5, I wouldn't be writing this message rig

Re: [GENERAL] compiling, performance of PostGreSQL 8.3 on 64-bit processors

2008-06-26 Thread Adam Rich
> 1. I have heard of problems arising from compiling PostGreSQL (8.3) on > 64-bit > processors. What sort of problems am I likely to encounter and how > should I fix > them? We are will run Linux Redhat 5 on a Dell PE2950 III Quad Core > Xeon E54 > 2.33 GHz, and a Dell PE2950 III Quad Core Xeon

[GENERAL] compiling, performance of PostGreSQL 8.3 on 64-bit processors

2008-06-26 Thread Benjamin Weaver
Dear All, 1. I have heard of problems arising from compiling PostGreSQL (8.3) on 64-bit processors. What sort of problems am I likely to encounter and how should I fix them? We are will run Linux Redhat 5 on a Dell PE2950 III Quad Core Xeon E54 2.33 GHz, and a Dell PE2950 III Quad Core Xeon L53

Re: [GENERAL] Compiling trigger function with MinGW

2008-05-13 Thread Hiroshi Saito
Hi. One of question... Was 8.3 of a main part built for yourself(MinGW)? When it is official pginstaller, you should use it by MS-VC+. Regards, Hiroshi Saito - Original Message - From: "Anton Burkun" <[EMAIL PROTECTED]> Hello All. Now I try to link dll with MinGW from Example in P

[GENERAL] Compiling trigger function with MinGW

2008-05-13 Thread Anton Burkun
Hello All. Now I try to link dll with MinGW from Example in Postgres Help. Linker show me this error: D:\users\anthony\kursor\abzcrm\c\foo>gcc -shared foo.o -o foo.dll -L "d:/files/local/PostgreSQL/8.3/lib" -l postgres Cannot export ⌂postgres_NULL_THUNK_DATA: symbol not found collect2: ld return

[GENERAL] Compiling trigger function with MinGW

2008-05-01 Thread Anton Burkun
Hello All. Now I try to link dll with MinGW from Example in Postgres Help. Linker show me this error: D:\users\anthony\kursor\abzcrm\c\foo>gcc -shared foo.o -o foo.dll -L "d:/files/local/PostgreSQL/8.3/lib" -l postgres Cannot export ⌂postgres_NULL_THUNK_DATA: symbol not found collect2: ld return

Re: [GENERAL] Compiling Pl/Perl on Mac OSX

2007-09-06 Thread Tom Lane
Logan Bowers <[EMAIL PROTECTED]> writes: > Has anyone had any luck compiling the Pl/Perl language on Mac OSX > (10.4)? I get the following error: Worksforme ... which Postgres version are you using exactly? > gcc -no-cpp-precomp -O2 -Wall -Wmissing-prototypes -Wpointer-arith - > Winline -Wdec

[GENERAL] Compiling Pl/Perl on Mac OSX

2007-09-05 Thread Logan Bowers
Hello all, Has anyone had any luck compiling the Pl/Perl language on Mac OSX (10.4)? I get the following error: *** Cannot build PL/Perl because libperl is not a shared library. *** You might have to rebuild your Perl installation. Refer to *** the documentation for details. If I modify Ma

Re: [GENERAL] Compiling PostgreSQL 8.2 on Windows using msvc2k5

2007-04-26 Thread Magnus Hagander
Marcelo de Moraes Serpa wrote: > Hello! > > I'd like to learn more about PostgreSQL (8.x) internal architecture so > as to build C extensions and Stored Procedures in C. I think that I nice > way to start is trying to compile PostgreSQL from the source. I'm on > Windows XP PRO. I've found this art

[GENERAL] Compiling PostgreSQL 8.2 on Windows using msvc2k5

2007-04-26 Thread Marcelo de Moraes Serpa
Hello! I'd like to learn more about PostgreSQL (8.x) internal architecture so as to build C extensions and Stored Procedures in C. I think that I nice way to start is trying to compile PostgreSQL from the source. I'm on Windows XP PRO. I've found this article: http://developer.postgresql.org/pgdo

[GENERAL] Compiling PL/R library on win32

2006-12-21 Thread Mike Leahy
Hello list, Last night I was finally able to compile in MinGW the PL/R module for using R stats in PostgreSQL. I describe how I did this here: http://gborg.postgresql.org/pipermail/plr-general/2006-December/000183.html. However, as I mention in that post, it seems that the dll doesn't want to w

Re: [GENERAL] compiling c-function on various version

2006-11-02 Thread Martijn van Oosterhout
On Thu, Nov 02, 2006 at 10:53:52PM +0900, Hitoshi Harada wrote: > but couldn't, PG_VERSION is string type. > any other macro or definitions?? In recent versions there's a PG_VERSION_NUM. For older versions you can track changes in the catalog version number. Have a nice day, -- Martijn van Oost

[GENERAL] compiling c-function on various version

2006-11-02 Thread Hitoshi Harada
Is there any way to compile c-function using pre-processor macro?? The code below is able to be compiled on 8.1.4: --- if(timestamp2tm(timestamp, NULL, tm, &fsec, NULL, NULL ) != 0){ // error } --- but not on 8.0.4, since the arguments of timestamp2tm() are changed. I tried like this: ---

Re: [GENERAL] Compiling/Installing as a non-admin user

2006-11-01 Thread Ritesh Nadhani
Thanks to all of you. I have get it up and running according to my needs. Help by everybody is appreciated! Richard Huxton wrote: Gurjeet Singh wrote: You are talking about /usr/local/data; so I assume that you are trying this on Linux or some other Nixen. You just need to use the --prefix

Re: [GENERAL] Compiling/Installing as a non-admin user

2006-11-01 Thread Thomas Kellerer
Ritesh Nadhani wrote on 01.11.2006 07:51: Hello All Me and my professor are planning to work upon machine learning in postgresql over tsearch2. So I have some questions: We have a server where Postgresql is running without any problem with postgres username and admin rights. I have a user ac

Re: [GENERAL] Compiling/Installing as a non-admin user

2006-11-01 Thread Alvaro Herrera
Ritesh Nadhani wrote: > As I see, using the default MAKE for postgresql will set the data > directory etc. in /usr/local/data etc which I dont have access to as a user. Specify the --prefix=DIR argument to configure, pointing to a directory you can write (presumably within your $HOME). You can

Re: [GENERAL] Compiling/Installing as a non-admin user

2006-11-01 Thread Richard Huxton
Gurjeet Singh wrote: You are talking about /usr/local/data; so I assume that you are trying this on Linux or some other Nixen. You just need to use the --prefix option to configure... Here's what I typically do: Download/'CVS checkout' the sources. Enter the source directory, and invoke configu

Re: [GENERAL] Compiling/Installing as a non-admin user

2006-11-01 Thread Gurjeet Singh
You are talking about /usr/local/data; so I assume that you are trying this on Linux or some other Nixen.You just need to use the --prefix option to configure... Here's what I typically do: Download/'CVS checkout' the sources. Enter the source directory, and invoke configure like this:./configure -

Re: [GENERAL] Compiling/Installing as a non-admin user

2006-10-31 Thread Thomas Kellerer
Ritesh Nadhani wrote on 01.11.2006 07:51: We have a server where Postgresql is running without any problem with postgres username and admin rights. Interesting. On Windows, PG will *refuse* to run on an account with admin rights. ---(end of broadcast)

[GENERAL] Compiling/Installing as a non-admin user

2006-10-31 Thread Ritesh Nadhani
Hello All Me and my professor are planning to work upon machine learning in postgresql over tsearch2. So I have some questions: We have a server where Postgresql is running without any problem with postgres username and admin rights. I have a user account in that server. I plan to compile an

Re: [GENERAL] Compiling ELF 64-bit on Solaris

2006-10-26 Thread Andrew Sullivan
On Thu, Oct 26, 2006 at 12:40:41PM -0700, [EMAIL PROTECTED] wrote: > How can I get the "make" to generate ELF 64-bit executables on Solaris 10? > > We're on Fujitsu hardware; uname -a displays this: > SunOS 5.10 Generic_118822-26 sun4us sparc FJSV,GPUZC-M Well, to start with, are you using

[GENERAL] Compiling ELF 64-bit on Solaris

2006-10-26 Thread vodhner
How can I get the "make" to generate ELF 64-bit executables on Solaris 10? We're on Fujitsu hardware; uname -a displays this: SunOS 5.10 Generic_118822-26 sun4us sparc FJSV,GPUZC-M Thanks Victor Odhner ---(end of broadcast)--- TIP 1: if pos

[GENERAL] Compiling ELF 64-bit on Solaris

2006-10-25 Thread vodhner
How can I get the "make" to generate ELF 64-bit executables on Solaris 10? We're on Fujitsu hardware; uname -a gives me: SunOS 5.10 Generic_118822-26 sun4us sparc FJSV,GPUZC-M Thanks ---(end of broadcast)--- TIP 2: Don't 'kill -9' the postm

Re: [GENERAL] Compiling libpqddll.lib win32 mingw msys

2006-09-02 Thread Keith Hutchison
Context postgres-8.1.3. win32 Found out to get libpqddll this had to be compiled with the VS compiler. Using the following steps. . 1. Download the MS Platform SDK http://download.microsoft.com/download/a/5/f/a5f0d781-e201-4ab6-8c6a-9bb4efed1e1a/PSDK-x86.exe 2. Change pg_config.h line 11 to have

[GENERAL] Compiling libpqddll.lib win32 mingw msys

2006-09-01 Thread Keith Hutchison
What parameters have to be passed to configure or make to build the import library files like libpqddll.lib on win32 using msys and mingw? Thank in advance -- Keith Hutchison http://balance-infosystems.com http://realopen.org http://www.kasamba.com/Keith-Hutchison ---(en

[GENERAL] Compiling contrib dblink_tds and oralink

2006-06-14 Thread LLC
Hi List; I've downloaded and unzipped the dblink_tds and the oralink contribs from the pgfoundry. Once I move them into the contrib directory and try to run make I get errors about undeclared functions (see the listing below). Any C guru's have any thoughts/advice/etc?? Thanks in advance for yo

Re: [GENERAL] compiling source code!!!!!!!!!!!!!!!!!!!!!!!!!!!!!

2006-05-24 Thread Dann Corbit
are ready to go.  It’s really easy.   I would guess it works the same under Cygwin, but I have not tried it.   From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] On Behalf Of sibel karaasma Sent: Wednesday, May 24, 2006 1:41 AM To: pgsql-general@postgresql.org Subject: [GENERAL

Re: [GENERAL] compiling source code!!!!!!!!!!!!!!!!!!!!!!!!!!!!!

2006-05-24 Thread Richard Huxton
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

[GENERAL] compiling source code!!!!!!!!!!!!!!!!!!!!!!!!!!!!!

2006-05-24 Thread sibel karaasma
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 c

Re: [GENERAL] compiling postgres on solaris and DBD::Pg

2006-05-12 Thread Martijn van Oosterhout
On Fri, May 12, 2006 at 08:25:26AM +0930, Luke Vanderfluit wrote: > Does this mean libpq is part of the perl install? > > Since libpq is under /usr/local/pgsql/lib/ doesn't that mean that it's > part of the postgresql install? Isn't then the postgres install 32 bit > and should be 64 bit? libpq

Re: [GENERAL] compiling postgres on solaris and DBD::Pg

2006-05-11 Thread Luke Vanderfluit
Hi Martijn. Martijn van Oosterhout wrote: On Thu, May 11, 2006 at 02:55:04PM +0930, Luke Vanderfluit wrote: Hi. I've been able to compile postgresql on solaris 10. Now I want to install the perl DBD::Pg module but I get a complaint, namely: [EMAIL PROTECTED]

Re: [GENERAL] compiling postgres on solaris and DBD::Pg

2006-05-11 Thread Martijn van Oosterhout
On Thu, May 11, 2006 at 02:55:04PM +0930, Luke Vanderfluit wrote: > Hi. > > I've been able to compile postgresql on solaris 10. > Now I want to install the perl DBD::Pg module but I get a complaint, namely: > [EMAIL PROTECTED] # make > rm -f blib/arch/auto/DBD/Pg/Pg.so > LD_RUN_PATH="/usr/local/p

[GENERAL] compiling postgres on solaris and DBD::Pg

2006-05-10 Thread Luke Vanderfluit
Hi. I've been able to compile postgresql on solaris 10. Now I want to install the perl DBD::Pg module but I get a complaint, namely: /~~~ [EMAIL PROTECTED] # make rm -f blib/arch/auto/DBD/Pg/Pg.so LD_RUN_PATH="/usr/local/pgsql/lib" /opt/SUNWspro/bin/cc -G -xarch=generic64 -

[GENERAL] Compiling libpq on Windows

2005-11-10 Thread Helge Elvik
Hi,   I’ve been trying to compile my own custom version of Mapserver for Windows this afternoon. Basically none of the binaries linked from the official page are compiled with Fast-CGI support, so I want to compile my own version since we want to use it in a pretty high volume environment

Re: [GENERAL] Compiling contrib module - intarray

2005-10-02 Thread Tom Lane
Jonathan Tse <[EMAIL PROTECTED]> writes: > I just downloaded 8.03 source and try to compile the contrib module > intarray by following the instruction in readme. However, I got the > following error: You need to run "configure" at the top of the distribution tree first. Be sure to give confi

[GENERAL] Compiling contrib module - intarray

2005-10-02 Thread Jonathan Tse
Hi list, I just downloaded 8.03 source and try to compile the contrib module intarray by following the instruction in readme. However, I got the following error: $ gmake Makefile:15: ../../src/Makefile.global: No such file or directory Makefile:16: /contrib/contrib-global.mk: No such file

Re: [GENERAL] Compiling Postgresql 8.0.3 on Solaris 10

2005-05-26 Thread Tom Lane
Greg Stark <[EMAIL PROTECTED]> writes: > I suspect something stranger going on. I'm still wondering about the theory that it's not the aliases at issue, but some scripts in the PATH ahead of the normal /bin/ls and friends. regards, tom lane ---(end

Re: [GENERAL] Compiling Postgresql 8.0.3 on Solaris 10

2005-05-26 Thread Aly Dharshi
Hello Tom, I hope that you are well, thank you for your guidence, but these are indeed defined in my .bashrc: # .bashrc # User specific aliases and functions # Source global definitions if [ -f /etc/bashrc ]; then . /etc/bashrc fi if [ "$PS1" ]; then # your settings:

Re: [GENERAL] Compiling Postgresql 8.0.3 on Solaris 10

2005-05-26 Thread Greg Stark
Tom Lane <[EMAIL PROTECTED]> writes: > Aly Dharshi <[EMAIL PROTECTED]> writes: > > alias ls='colorls -al' > > alias rm='rm -i' > > > I don't see any aliases that are going to break the compile process. > > I beg to differ --- I think the ones quoted above match your symptoms > pretty well. So t

Re: [GENERAL] Compiling Postgresql 8.0.3 on Solaris 10

2005-05-25 Thread Tom Lane
Aly Dharshi <[EMAIL PROTECTED]> writes: > alias ls='colorls -al' > alias rm='rm -i' > I don't see any aliases that are going to break the compile process. I beg to differ --- I think the ones quoted above match your symptoms pretty well. So the question is: why are they getting used in a noninte

Re: [GENERAL] Compiling Postgresql 8.0.3 on Solaris 10

2005-05-25 Thread Aly Dharshi
Hello Tom, I hope that you are well. I tried to check my aliases in my current shell which is bash (/bin/bash): alias allproc='ps -ef | less' alias cls='clear' alias e='emacs -nw $1' alias e-mail='pine' alias ll='colorls -l' alias lo='exit' alias logout='exit' alias ls='colorls -al' alias mpr

Re: [GENERAL] Compiling Postgresql 8.0.3 on Solaris 10

2005-05-25 Thread Tom Lane
Aly Dharshi <[EMAIL PROTECTED]> writes: > I hope that you are well. I tried compiling Postgres 8.0.3 on Solaris > 10 and > encountered the following problem, has anybody else had problems. > [dharshi::02:03 PM::~/downloads/postgresql-8.0.3]$ ./configure > rm: remove conftest.sh (yes/no)? y

Re: [GENERAL] Compiling Postgresql 8.0.3 on Solaris 10

2005-05-25 Thread Mohan, Ross
To: pgsql-general@postgresql.org Subject: [GENERAL] Compiling Postgresql 8.0.3 on Solaris 10 Hello Folks, I hope that you are well. I tried compiling Postgres 8.0.3 on Solaris 10 and encountered the following problem, has anybody else had problems. I know that I have gcc3 installed and

[GENERAL] Compiling Postgresql 8.0.3 on Solaris 10

2005-05-25 Thread Aly Dharshi
Hello Folks, I hope that you are well. I tried compiling Postgres 8.0.3 on Solaris 10 and encountered the following problem, has anybody else had problems. I know that I have gcc3 installed and working, compiled apache with it as well as a small test program. This is a Sun Blade 150 with abou

[GENERAL] Compiling

2004-03-26 Thread Nilton Yudiro Ikezire
Hi, I have PostgreSQL compiled and i realized that it has some diferences from the packages instalation like the way i access a database, when i compile i have psql.bin that access the database and packages i have a link to pg_wrapper How can i compile and execute the same way the pack

[GENERAL] Compiling postgres-7.4.1

2004-01-21 Thread Sathiamoorthy Balasubramaniyan (ext_TCS)
hello, Iam trying to install postgres-7.4.1 on my tru64 (O.S version 5.1A) box without the shared library support. Here's my list of commands: ./configure --with-includes=/opt/gcc-33/include --prefix=/tools/postgres-741 --disable-shared gmake gmake install The "gmake" successfully compiles the s

[GENERAL] compiling libpq without 'main'

2003-09-08 Thread Marco Vezzoli
Hi all, I'm using solaris 8 gcc 3.0.1 postgres 7.3.4 psycopg 1.1.2 apache 1.3.19 python 2.1.1 mod_python 2.7.8 compiled with DSO Compilation and tests run good for all tools. When I connect from a standalone python session (either a program or a CGI) everything works fine. But when I use either

Re: [GENERAL] compiling the examples

2003-08-18 Thread Martijn van Oosterhout
You forgot the: -L /usr/local/pgsql/lib -lpq Hope this helps, On Mon, Aug 18, 2003 at 02:01:08PM +0200, Marc Cuypers wrote: > Hi, > > How do i make the examples in postgresql-7.3.3/src/test/examples/? > It seems that just typing make doesn't link to the libpq library. Where > should I start ma

Re: [GENERAL] compiling the examples

2003-08-18 Thread Marc Cuypers
Tom Lane wrote: Marc Cuypers <[EMAIL PROTECTED]> writes: How do i make the examples in postgresql-7.3.3/src/test/examples/? "make" works for me, assuming that I'm doing it in a built directory tree. [ looks at 7.3 branch... ] Hm, it looks like there's a mistake in the Makefile in that director

  1   2   >