Re: [GENERAL] PostgreSQL 9 Mac OS X one-click install - PL/perl broken
On Tue, Sep 28, 2010 at 7:46 PM, Scott Ribe scott_r...@killerbytes.com wrote: On Sep 28, 2010, at 11:50 AM, Dave Page wrote: You're welcome. I guess it is running the 64bit image - is your machine Leopard Server? That's irrelevant. The 32-bit vs 64-bit default is for the kernel and extensions, not for applications. On 64-bit hardware, apps can be run as 64-bit, and will be if there's a 64-bit executable, regardless of which mode the kernel is booted into. Thanks for the clarification. I thought it was only Snow Leopard/Snow Leopard Server and Leopard Server that could run the 64 bit images. -- Dave Page Blog: http://pgsnake.blogspot.com Twitter: @pgsnake EnterpriseDB UK: http://www.enterprisedb.com The Enterprise Postgres Company -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
Re: [GENERAL] PostgreSQL 9 Mac OS X one-click install - PL/perl broken
On Mon, Sep 27, 2010 at 11:35 PM, Larry Leszczynski lar...@emailplus.org wrote: Hi - I use Dave Page's one-click installers for Mac OS X: http://www.enterprisedb.com/products/pgdownload.do#osx I recently installed PostgreSQL 9.0.0 on Mac OS X 10.5.8. PL/perl will not load because it is looking for Perl 5.10 in the System dirs and I only have 5.8.8: grumble. That's a PITA. We build on Snow Leopard now, because we were getting more requests for x86_64 support than PPC. even though the plperl.so I built looks ok: $ file plperl.so plperl.so: Mach-O bundle i386 Has anyone else run into this? Anybody have any suggestions? I could understand that if it's running the 64 bit image in the binary, but that shouldn't be the case on Leopard I don't think - unless this is Leopard Server? If so, you could try building the 64 bit binary: CFLAGS=-isysroot /Developer/SDKs/MacOSX10.5.sdk -mmacosx-version-min=10.5 -O2 -arch x86_64 ./configure -- Dave Page Blog: http://pgsnake.blogspot.com Twitter: @pgsnake EnterpriseDB UK: http://www.enterprisedb.com The Enterprise Postgres Company -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
Re: [GENERAL] PostgreSQL 9 Mac OS X one-click install - PL/perl broken
On Tue, 28 Sep 2010 13:35 +0100, Dave Page dp...@pgadmin.org wrote: I recently installed PostgreSQL 9.0.0 on Mac OS X 10.5.8. PL/perl will not load because it is looking for Perl 5.10 in the System dirs and I only have 5.8.8: grumble. That's a PITA. We build on Snow Leopard now, because we were getting more requests for x86_64 support than PPC. [snip] you could try building the 64 bit binary: CFLAGS=-isysroot /Developer/SDKs/MacOSX10.5.sdk -mmacosx-version-min=10.5 -O2 -arch x86_64 ./configure Excellent! Looks like that worked fine. I just added the --with-perl option to configure. Thanks Dave! Larry -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
Re: [GENERAL] PostgreSQL 9 Mac OS X one-click install - PL/perl broken
On Tue, Sep 28, 2010 at 6:46 PM, Larry Leszczynski lar...@emailplus.org wrote: On Tue, 28 Sep 2010 13:35 +0100, Dave Page dp...@pgadmin.org wrote: I recently installed PostgreSQL 9.0.0 on Mac OS X 10.5.8. PL/perl will not load because it is looking for Perl 5.10 in the System dirs and I only have 5.8.8: grumble. That's a PITA. We build on Snow Leopard now, because we were getting more requests for x86_64 support than PPC. [snip] you could try building the 64 bit binary: CFLAGS=-isysroot /Developer/SDKs/MacOSX10.5.sdk -mmacosx-version-min=10.5 -O2 -arch x86_64 ./configure Excellent! Looks like that worked fine. I just added the --with-perl option to configure. Thanks Dave! You're welcome. I guess it is running the 64bit image - is your machine Leopard Server? -- Dave Page Blog: http://pgsnake.blogspot.com Twitter: @pgsnake EnterpriseDB UK: http://www.enterprisedb.com The Enterprise Postgres Company -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
Re: [GENERAL] PostgreSQL 9 Mac OS X one-click install - PL/perl broken
Hi Dave - you could try building the 64 bit binary: CFLAGS=-isysroot /Developer/SDKs/MacOSX10.5.sdk -mmacosx-version-min=10.5 -O2 -arch x86_64 ./configure Excellent! Looks like that worked fine. I just added the --with-perl option to configure. Thanks Dave! You're welcome. I guess it is running the 64bit image - is your machine Leopard Server? Not sure how I would check... sw_vers give me: ProductName:Mac OS X ProductVersion: 10.5.8 BuildVersion: 9L31a Thanks! Larry -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
Re: [GENERAL] PostgreSQL 9 Mac OS X one-click install - PL/perl broken
On Sep 28, 2010, at 11:50 AM, Dave Page wrote: You're welcome. I guess it is running the 64bit image - is your machine Leopard Server? That's irrelevant. The 32-bit vs 64-bit default is for the kernel and extensions, not for applications. On 64-bit hardware, apps can be run as 64-bit, and will be if there's a 64-bit executable, regardless of which mode the kernel is booted into. -- Scott Ribe scott_r...@elevated-dev.com http://www.elevated-dev.com/ (303) 722-0567 voice -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
[GENERAL] PostgreSQL 9 Mac OS X one-click install - PL/perl broken
Hi - I use Dave Page's one-click installers for Mac OS X: http://www.enterprisedb.com/products/pgdownload.do#osx I recently installed PostgreSQL 9.0.0 on Mac OS X 10.5.8. PL/perl will not load because it is looking for Perl 5.10 in the System dirs and I only have 5.8.8: $ ./createlang plperl my_db createlang: language installation failed: ERROR: could not load library /Library/PostgreSQL/9.0/lib/postgresql/plperl.so: dlopen(/Library/PostgreSQL/9.0/lib/postgresql/plperl.so, 10): Library not loaded: /System/Library/Perl/lib/5.10/libperl.dylib Referenced from: /Library/PostgreSQL/9.0/lib/postgresql/plperl.so Reason: image not found I tried building plperl.so from source and copied it to /Library/PostgreSQL/9.0/lib/postgresql/plperl.so. But then I get a different error: $ ./createlang plperl my_db createlang: language installation failed: ERROR: could not load library /Library/PostgreSQL/9.0/lib/postgresql/plperl.so: dlopen(/Library/PostgreSQL/9.0/lib/postgresql/plperl.so, 10): no suitable image found. Did find: /Library/PostgreSQL/9.0/lib/postgresql/plperl.so: mach-o, but wrong architecture even though the plperl.so I built looks ok: $ file plperl.so plperl.so: Mach-O bundle i386 Has anyone else run into this? Anybody have any suggestions? Thanks! Larry -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
Re: [GENERAL] postgresql and Mac OS X
At 7:51 PM -0500 11/7/08, Tom Allison wrote: adam_pgsql wrote: When I do the install script in contrib it says I have no rights to the directory. It was in /usr/local/pgsql/data/log and I changed it to /usr/local/pgsql/log. It was set as root.wheel with 755 permissions so I suspect it's mad at me because the postgres user was left in the cold. Have you switched on logging in postgresql.conf? doh! There's no postgresql.conf file, just a postgresql.conf.sample. Guess I have to start from .sample and work my way up... -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general Mine was installed as part of the distribution. -Owen -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
Re: [GENERAL] postgresql and Mac OS X
adam_pgsql wrote: When I do the install script in contrib it says I have no rights to the directory. It was in /usr/local/pgsql/data/log and I changed it to /usr/local/pgsql/log. It was set as root.wheel with 755 permissions so I suspect it's mad at me because the postgres user was left in the cold. Have you switched on logging in postgresql.conf? doh! There's no postgresql.conf file, just a postgresql.conf.sample. Guess I have to start from .sample and work my way up... -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
Re: [GENERAL] postgresql and Mac OS X
Tom Allison wrote: Scott Ribe wrote: 'make' is prefixed by /Developer/usr/bin/. The question is *why* the location is nonstandard. Starting with Xcode 3, all the developer tools get installed under the Developer directory, in order to allow one to easily have multiple versions of Xcode installed alongside each other. The question then is why the OP doesn't also have make in /usr/bin, or why his path is configured so that it finds /Developer/usr/bin first--*that* is what is non-standard. There is an option during installation for a Unix Tools installation. Which puts everything where it's expected. Made great progress on getting everything to work. I'm down to one detail It runs, it starts with the notebook on boot. But there is no logging... When I do the install script in contrib it says I have no rights to the directory. It was in /usr/local/pgsql/data/log and I changed it to /usr/local/pgsql/log. It was set as root.wheel with 755 permissions so I suspect it's mad at me because the postgres user was left in the cold. Now - I have what I hope is the last question related to Mac OSX and not so much the Postgresql. How do you start/stop services without rebooting the machine? I tried launchctl but it's not listed. -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
Re: [GENERAL] postgresql and Mac OS X
When I do the install script in contrib it says I have no rights to the directory. It was in /usr/local/pgsql/data/log and I changed it to /usr/local/pgsql/log. It was set as root.wheel with 755 permissions so I suspect it's mad at me because the postgres user was left in the cold. Have you switched on logging in postgresql.conf? Now - I have what I hope is the last question related to Mac OSX and not so much the Postgresql. How do you start/stop services without rebooting the machine? I tried launchctl but it's not listed. I installed PostgreSQL from source (configured using pgsql as system username) and use one of: sudo -u pgsql /usr/local/pgsql/bin/pg_ctl -D /usr/local/pgsql/data start sudo -u pgsql /usr/local/pgsql/bin/pg_ctl -D /usr/local/pgsql/data stop sudo -u pgsql /usr/local/pgsql/bin/pg_ctl -D /usr/local/pgsql/data restart sudo -u pgsql /usr/local/pgsql/bin/pg_ctl -D /usr/local/pgsql/data reload (reload if i have just changed some configuration parameters). You may have to substitute postgres for pgsql eg sudo -u postgres /usr/local/pgsql/bin/pg_ctl -D /usr/local/pgsql/data start -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
Re: [GENERAL] postgresql and Mac OS X
Tom Allison wrote: It confirms what I'm working through. crt1.o located at /Developer/SDKs/MacOSX10.5.sdk/usr/lib/crt1.o crt1.10.5.0 at /Developer/SDKs/MacOSX10.5.sdk/usr/lib/crt1.10.5.o So I'm trying to find how to get these directories included in the compilation. I thought --with-libs and/or --with-includes would have helped. But it didn't. This is what I ran (I'm running this from a script so I can repeat it) -- cd /Users/tom/src/postgresql-8.3.4 export PATH=$PATH:/Developer/usr/bin/ ./configure \ --with-libs=/Developer/SDKs/MacOSX10.5.sdk/usr/lib/ \ --with-includes=/Developer/SDKs/MacOSX10.5.sdk/usr/lib/ But I'm on the same error... crt1.o is located in usr/lib of the SDK's as far back as 10.1 a clean 10.3 has it at /usr/lib but a clean 10.5 doesn't - that's clean as in without dev tools 10.4 with dev tools has a copy at /usr/lib As others have suggested ensure that the full dev tools are installed into /usr/bin and so on. And leave the /Developer/usr... stuff for Apples binaries to use as they have been made to. If you want to use the SDK's to build a binary for a system version other than the one you are building on then what you are looking for is SDKROOT (use export or setenv - not as a configure option) From Xcode tips (under Build Locations - SDK Path)- The location of the SDK being used during the build. The product will built against the headers and libraries located inside the indicated SDK. This path will be prepended to all search paths, and will be passed through the environment to the compiler and linker. Normally, this path is set at the project level via the Cross-Develop Using Target SDK popup in the General tab of the project inspector. [SDKROOT] NOTE - This is an Apple GCC extension - I don't think it has made it into the general GCC release. -- Shane Ambler pgSQL (at) Sheeky (dot) Biz Get Sheeky @ http://Sheeky.Biz -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
Re: [GENERAL] postgresql and Mac OS X
On Tue, Nov 4, 2008 at 8:21 AM, Tom Allison [EMAIL PROTECTED] wrote: Grzegorz Jaśkiewicz wrote: I feel good about control here, and I certainly don't have any problems. So, please don't whine :) Especially since I want to run cvs head, and be able to actually update it from cvs when I want to, that's the only choice. Postgresql is so easy to get from sources, compared to other software packages, I can't understand people even with slightest expierence in unix to have any problems with it. I tried getting a source install on my mac book yesterday and today. It's not a normal *nix installation. The location of the files are all non-standard. 'make' is prefixed by /Developer/usr/bin/. I added /Developer/usr/bin to PATH and tried ./configure. checking build system type... i386-apple-darwin9.5.0 checking host system type... i386-apple-darwin9.5.0 checking which template to use... darwin checking whether to build with 64-bit integer date/time support... no checking whether NLS is wanted... no checking for default port number... 5432 checking for gcc... gcc checking for C compiler default output file name... configure: error: C compiler cannot create executables See `config.log' for more details. config.log shows an exit code of 77 with a statement that compiler cannot create executables. ??? configure:2213: $? = 0 configure:2215: gcc -v /dev/null 5 Using built-in specs. Target: i686-apple-darwin9 Configured with: /var/tmp/gcc/gcc-5488~2/src/configure --disable-checking -enabl e-werror --prefix=/usr --mandir=/share/man --enable-languages=c,objc,c++,obj-c++ --program-transform-name=/^[cg][^.-]*$/s/$/-4.0/ --with-gxx-include-dir=/includ e/c++/4.0.0 --with-slibdir=/usr/lib --build=i686-apple-darwin9 --with-arch=apple --with-tune=generic --host=i686-apple-darwin9 --target=i686-apple-darwin9 Thread model: posix gcc version 4.0.1 (Apple Inc. build 5488) configure:2218: $? = 0 configure:2220: gcc -V /dev/null 5 gcc-4.0: argument to `-V' is missing configure:2223: $? = 1 configure:2246: checking for C compiler default output file name configure:2249: gccconftest.c 5 ld: library not found for -lcrt1.10.5.o collect2: ld returned 1 exit status configure:2252: $? = 1 configure: failed program was: I think he questin is, what lib was missing so I can go find it and add it to some path/dir variable? I think you need to install the developer tools. I compile postgresql from sources with no problem on osx 10.5.4 but I installed developer tools before. The library which is missing is the following: configure:2246: checking for C compiler default output file name configure:2249: gccconftest.c 5 ld: library not found for -lcrt1.10.5.o - crt1.10.5.o I hope it helps. -- Regards, Francisco Figueiredo Jr. Npgsql Lead Developer http://fxjr.blogspot.com http://www.npgsql.org -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
Re: [GENERAL] postgresql and Mac OS X
Grzegorz Jaśkiewicz wrote: I feel good about control here, and I certainly don't have any problems. So, please don't whine :) Especially since I want to run cvs head, and be able to actually update it from cvs when I want to, that's the only choice. Postgresql is so easy to get from sources, compared to other software packages, I can't understand people even with slightest expierence in unix to have any problems with it. I tried getting a source install on my mac book yesterday and today. It's not a normal *nix installation. The location of the files are all non-standard. 'make' is prefixed by /Developer/usr/bin/. I added /Developer/usr/bin to PATH and tried ./configure. checking build system type... i386-apple-darwin9.5.0 checking host system type... i386-apple-darwin9.5.0 checking which template to use... darwin checking whether to build with 64-bit integer date/time support... no checking whether NLS is wanted... no checking for default port number... 5432 checking for gcc... gcc checking for C compiler default output file name... configure: error: C compiler cannot create executables See `config.log' for more details. config.log shows an exit code of 77 with a statement that compiler cannot create executables. ??? configure:2213: $? = 0 configure:2215: gcc -v /dev/null 5 Using built-in specs. Target: i686-apple-darwin9 Configured with: /var/tmp/gcc/gcc-5488~2/src/configure --disable-checking -enabl e-werror --prefix=/usr --mandir=/share/man --enable-languages=c,objc,c++,obj-c++ --program-transform-name=/^[cg][^.-]*$/s/$/-4.0/ --with-gxx-include-dir=/includ e/c++/4.0.0 --with-slibdir=/usr/lib --build=i686-apple-darwin9 --with-arch=apple --with-tune=generic --host=i686-apple-darwin9 --target=i686-apple-darwin9 Thread model: posix gcc version 4.0.1 (Apple Inc. build 5488) configure:2218: $? = 0 configure:2220: gcc -V /dev/null 5 gcc-4.0: argument to `-V' is missing configure:2223: $? = 1 configure:2246: checking for C compiler default output file name configure:2249: gccconftest.c 5 ld: library not found for -lcrt1.10.5.o collect2: ld returned 1 exit status configure:2252: $? = 1 configure: failed program was: I think he questin is, what lib was missing so I can go find it and add it to some path/dir variable? -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
Re: [GENERAL] postgresql and Mac OS X
On 4 nov 2008, at 11.21, Tom Allison wrote: I tried getting a source install on my mac book yesterday and today. It's not a normal *nix installation. The location of the files are all non-standard. 'make' is prefixed by /Developer/usr/bin/. That's not right. It should definately live in /usr/bin on a normal Mac OS X install. What versions of Mac OS X and the developer tools do you have? Did you make some non-standard choice during the installation of the dev tools? Sincerely, Niklas Johansson -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
Re: [GENERAL] postgresql and Mac OS X
Francisco Figueiredo Jr. wrote: On Tue, Nov 4, 2008 at 8:21 AM, Tom Allison [EMAIL PROTECTED] wrote: Grzegorz Jaśkiewicz wrote: I feel good about control here, and I certainly don't have any problems. So, please don't whine :) Especially since I want to run cvs head, and be able to actually update it from cvs when I want to, that's the only choice. Postgresql is so easy to get from sources, compared to other software packages, I can't understand people even with slightest expierence in unix to have any problems with it. I tried getting a source install on my mac book yesterday and today. It's not a normal *nix installation. The location of the files are all non-standard. 'make' is prefixed by /Developer/usr/bin/. I added /Developer/usr/bin to PATH and tried ./configure. checking build system type... i386-apple-darwin9.5.0 checking host system type... i386-apple-darwin9.5.0 checking which template to use... darwin checking whether to build with 64-bit integer date/time support... no checking whether NLS is wanted... no checking for default port number... 5432 checking for gcc... gcc checking for C compiler default output file name... configure: error: C compiler cannot create executables See `config.log' for more details. config.log shows an exit code of 77 with a statement that compiler cannot create executables. ??? configure:2213: $? = 0 configure:2215: gcc -v /dev/null 5 Using built-in specs. Target: i686-apple-darwin9 Configured with: /var/tmp/gcc/gcc-5488~2/src/configure --disable-checking -enabl e-werror --prefix=/usr --mandir=/share/man --enable-languages=c,objc,c++,obj-c++ --program-transform-name=/^[cg][^.-]*$/s/$/-4.0/ --with-gxx-include-dir=/includ e/c++/4.0.0 --with-slibdir=/usr/lib --build=i686-apple-darwin9 --with-arch=apple --with-tune=generic --host=i686-apple-darwin9 --target=i686-apple-darwin9 Thread model: posix gcc version 4.0.1 (Apple Inc. build 5488) configure:2218: $? = 0 configure:2220: gcc -V /dev/null 5 gcc-4.0: argument to `-V' is missing configure:2223: $? = 1 configure:2246: checking for C compiler default output file name configure:2249: gccconftest.c 5 ld: library not found for -lcrt1.10.5.o collect2: ld returned 1 exit status configure:2252: $? = 1 configure: failed program was: I think he questin is, what lib was missing so I can go find it and add it to some path/dir variable? I think you need to install the developer tools. I compile postgresql from sources with no problem on osx 10.5.4 but I installed developer tools before. The library which is missing is the following: configure:2246: checking for C compiler default output file name configure:2249: gccconftest.c 5 ld: library not found for -lcrt1.10.5.o - crt1.10.5.o I hope it helps. It confirms what I'm working through. crt1.o located at /Developer/SDKs/MacOSX10.5.sdk/usr/lib/crt1.o crt1.10.5.0 at /Developer/SDKs/MacOSX10.5.sdk/usr/lib/crt1.10.5.o So I'm trying to find how to get these directories included in the compilation. I thought --with-libs and/or --with-includes would have helped. But it didn't. This is what I ran (I'm running this from a script so I can repeat it) -- cd /Users/tom/src/postgresql-8.3.4 export PATH=$PATH:/Developer/usr/bin/ ./configure \ --with-libs=/Developer/SDKs/MacOSX10.5.sdk/usr/lib/ \ --with-includes=/Developer/SDKs/MacOSX10.5.sdk/usr/lib/ But I'm on the same error... -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
Re: [GENERAL] postgresql and Mac OS X
Tom Allison [EMAIL PROTECTED] writes: I tried getting a source install on my mac book yesterday and today. It's not a normal *nix installation. The location of the files are all non-standard. 'make' is prefixed by /Developer/usr/bin/. The question is *why* the location is nonstandard. Other people's Macs are not set up that way (mine seems to have these files in the expected place, for example). I added /Developer/usr/bin to PATH and tried ./configure. That would help configure find the stuff in /Developer/usr/bin, but it does nothing for files that ought to be in /usr/lib, /usr/include, etc. I am not sure whether adding these to the configure command would be sufficient: --with-includes=/Developer/usr/include --with-libraries=/Developer/usr/lib On the whole the best thing would be to toss /Developer and reinstall your devtools in the standard places. The nonstandard location is going to bite you for every package you work with, not only Postgres. regards, tom lane -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
Re: [GENERAL] postgresql and Mac OS X
On Nov 4, 2008, at 1:02 PM, Tom Allison wrote: I tried getting a source install on my mac book yesterday and today. It's not a normal *nix installation. The location of the files are all non-standard. 'make' is prefixed by /Developer/usr/bin/. It's in /usr/bin/make on my OS X box (as well as in /Developer/usr/bin/ make) If I recall correctly there's an option during the XCode install to include the commandline tools, which may be what you're missing It confirms what I'm working through. crt1.o located at /Developer/SDKs/MacOSX10.5.sdk/usr/lib/crt1.o crt1.10.5.0 at /Developer/SDKs/MacOSX10.5.sdk/usr/lib/crt1.10.5.o So I'm trying to find how to get these directories included in the compilation. I thought --with-libs and/or --with-includes would have helped. But it didn't. This is what I ran (I'm running this from a script so I can repeat it) That's the runtime. If that's not being included then your development environment is utterly broken, and messing with configure flags won't fix it. Give up on postgresql/configure for now, reinstall XCode with the commandline tools and check that you can build hello world from the commandline. Then start over with a clean postgresql tarball. Cheers, Steve -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
Re: [GENERAL] postgresql and Mac OS X
On Nov 4, 2008, at 4:14 PM, Tom Lane wrote: Tom Allison [EMAIL PROTECTED] writes: I tried getting a source install on my mac book yesterday and today. It's not a normal *nix installation. The location of the files are all non-standard. 'make' is prefixed by /Developer/usr/bin/. The question is *why* the location is nonstandard. Other people's Macs are not set up that way (mine seems to have these files in the expected place, for example). I added /Developer/usr/bin to PATH and tried ./configure. That would help configure find the stuff in /Developer/usr/bin, but it does nothing for files that ought to be in /usr/lib, /usr/include, etc. I am not sure whether adding these to the configure command would be sufficient: --with-includes=/Developer/usr/include --with-libraries=/Developer/ usr/lib /Developer/usr/ shouldn't be linked against directly- this is the location for OS X SDKs, so that binaries can be built and linked which work on older versions of OS X than one is currently using. Cheers, M -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
Re: [GENERAL] postgresql and Mac OS X
Tom Lane wrote: Tom Allison [EMAIL PROTECTED] writes: I tried getting a source install on my mac book yesterday and today. It's not a normal *nix installation. The location of the files are all non-standard. 'make' is prefixed by /Developer/usr/bin/. The question is *why* the location is nonstandard. Other people's Macs are not set up that way (mine seems to have these files in the expected place, for example). I added /Developer/usr/bin to PATH and tried ./configure. That would help configure find the stuff in /Developer/usr/bin, but it does nothing for files that ought to be in /usr/lib, /usr/include, etc. I am not sure whether adding these to the configure command would be sufficient: --with-includes=/Developer/usr/include --with-libraries=/Developer/usr/lib On the whole the best thing would be to toss /Developer and reinstall your devtools in the standard places. The nonstandard location is going to bite you for every package you work with, not only Postgres. regards, tom lane I have installed xcode311_2517_developerdvd that I added after I installed the Leopard OS. This was an upgrade from Tiger but that puked so I installed Leopard from scratch. I will try installing this package again. (note: Unix Tools is checked) Running just ./configure I got past that part... And finished the configure. So, the answer seems to be that I did not install the Unix Tools portion of the XCode tools. Which naturally is so very obvious for installation of anything used to unix installations... I did strictly the default installation. Sorry to run everyone through these loops. But now we all know something new about Mac OSX -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
Re: [GENERAL] postgresql and Mac OS X
'make' is prefixed by /Developer/usr/bin/. The question is *why* the location is nonstandard. Starting with Xcode 3, all the developer tools get installed under the Developer directory, in order to allow one to easily have multiple versions of Xcode installed alongside each other. The question then is why the OP doesn't also have make in /usr/bin, or why his path is configured so that it finds /Developer/usr/bin first--*that* is what is non-standard. -- Scott Ribe [EMAIL PROTECTED] http://www.killerbytes.com/ (303) 722-0567 voice -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
Re: [GENERAL] postgresql and Mac OS X
Scott Ribe wrote: 'make' is prefixed by /Developer/usr/bin/. The question is *why* the location is nonstandard. Starting with Xcode 3, all the developer tools get installed under the Developer directory, in order to allow one to easily have multiple versions of Xcode installed alongside each other. The question then is why the OP doesn't also have make in /usr/bin, or why his path is configured so that it finds /Developer/usr/bin first--*that* is what is non-standard. There is an option during installation for a Unix Tools installation. Which puts everything where it's expected. -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
Re: [GENERAL] postgresql and Mac OS X
I feel good about control here, and I certainly don't have any problems. So, please don't whine :) Especially since I want to run cvs head, and be able to actually update it from cvs when I want to, that's the only choice. Postgresql is so easy to get from sources, compared to other software packages, I can't understand people even with slightest expierence in unix to have any problems with it.
Re: [GENERAL] postgresql and Mac OS X
On 28 okt 2008, at 23.41, Tom Allison wrote: I can get postgresql installed in three flavors: EnterpriseDB has a dmg package for Mac. macports has their own package. fink also has their own package. You also have the fourth, most delicious flavor: build it yourself; PostgreSQL compiles nicely on Mac OS X. I've never had any reason to regret not using a package manager yet. I was using macports but got into a cluster-F on versions and multiple installs. After a spell I had all four versions 8.0 - 8.3 installed in order to use postgres, ruby, perl, and rails together. Do you mean that Macports installed different versions of Postgres because the other packages had different dependencies? Don't know if compiling from source would help you there, but surely there must be some way to tell the package manager that a certain dependency already exists, albeit somewhere else? Sincerely, Niklas Johansson -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
Re: [GENERAL] postgresql and Mac OS X
I use postgresql on MBP, current head, for testing and development. Just from sources, it won't bite :) you just have to add user postgres to your system, place $PGDATA wherever you feel you should, and you're done.
Re: [GENERAL] postgresql and Mac OS X
On Tue, Oct 28, 2008 at 11:41 PM, Tom Allison [EMAIL PROTECTED] wrote: I was using macports but got into a cluster-F on versions and multiple installs. After a spell I had all four versions 8.0 - 8.3 installed in order to use postgres, ruby, perl, and rails together. I use apple's ruby, but have postgres, perl and a lot of other packages/libraries installed from macports, and am quite happy with it. I had the same multiple-version-issues I think you're experiencing at first, believing that all deactivated ports were still required as dependencies, but eventually got tired of the mess and did a forced uninstall of anything inactive. My apps still worked. Installing a single app from source isn't that much of an issue, but I have 100+ different ports installed on my dev box. Four(*) commands in a terminal window keeps them all current. Isak *) sudo port sync# update package info sudo port selfupdate # update macports sudo port upgrade installed# upgrade installed ports sudo port uninstall -f inactive # clean up after upgrade -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
Re: [GENERAL] postgresql and Mac OS X
Grzegorz Jaśkiewicz wrote: I use postgresql on MBP, current head, for testing and development. Just from sources, it won't bite :) you just have to add user postgres to your system, place $PGDATA wherever you feel you should, and you're done. Yes. I actually started using Nix from Slackware. Which means, by definition, installation from scratch is trivial. I can see the value in doing an installation on your own because you do have absolute control over the version/options of the packages. I guess my reluctance against compiling is that I have little interest in tuning development box and going through the nuances of configuration. And as such -- plug chug seems easy. I think I found my answer though -- DIY. It's the control and knowing I have all the binaries and source code I need to. now, wish me luck! I might be back on the list really soon... :) - Tom -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
[GENERAL] postgresql and Mac OS X
Relatively simple question that I hope doesn't start too much Flame. I have recently had the opportunity to reformat my macbook hard drive, many thanks to suggestions from the actual Apple support team. That's not why I'm writing to the postgres group... But it's related. I have a fresh slate from which to build my development platform!! I can get postgresql installed in three flavors: EnterpriseDB has a dmg package for Mac. macports has their own package. fink also has their own package. I was using macports but got into a cluster-F on versions and multiple installs. After a spell I had all four versions 8.0 - 8.3 installed in order to use postgres, ruby, perl, and rails together. I'm interesting in knowing if this can be avoided by selecting one of the alternative sources of installation. Any experiences with differences in installation and long term management from these sources? I'm more accustomed to using Linux for PostgreSQL, but in this situation Linux probably won't be my development arena but test/prod. In the Linux environment I've had great success in getting migrations, upgrades, and languages to play well with PostgreSQL without the multi version issue. Many thanks in advance for all your input! Tom -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
Re: [GENERAL] postgresql and Mac OS X
On Oct 28, 2008, at 3:41 PM, Tom Allison wrote: Relatively simple question that I hope doesn't start too much Flame. I have recently had the opportunity to reformat my macbook hard drive, many thanks to suggestions from the actual Apple support team. That's not why I'm writing to the postgres group... But it's related. I have a fresh slate from which to build my development platform!! I can get postgresql installed in three flavors: EnterpriseDB has a dmg package for Mac. macports has their own package. fink also has their own package. There's also http://www.postgresqlformac.com/ and I think one or two others. I was using macports but got into a cluster-F on versions and multiple installs. After a spell I had all four versions 8.0 - 8.3 installed in order to use postgres, ruby, perl, and rails together. I'm interesting in knowing if this can be avoided by selecting one of the alternative sources of installation. Any experiences with differences in installation and long term management from these sources? I'm more accustomed to using Linux for PostgreSQL, but in this situation Linux probably won't be my development arena but test/ prod. In the Linux environment I've had great success in getting migrations, upgrades, and languages to play well with PostgreSQL without the multi version issue. I usually install postgresql from source on my macbook. I'm using it for development, rather than production, so I don't have it starting automatically via launchd, just start it with pg_ctl manually when I need it. Installing from source means I can avoid the fragility of macports or fink, and know that I've built it in much the same way as the postgresql or solaris installation I'd be using for production. I didn't know about the EnterpriseDB dmg, though. I'll take a look at that. Cheers, Steve -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
Re: [GENERAL] postgresql and Mac OS X
On 28 okt 2008, at 23.41, Tom Allison wrote: I can get postgresql installed in three flavors: EnterpriseDB has a dmg package for Mac. macports has their own package. fink also has their own package. You also have the fourth, most delicious flavor: build it yourself; PostgreSQL compiles nicely on Mac OS X. I've never had any reason to regret not using a package manager yet. I was using macports but got into a cluster-F on versions and multiple installs. After a spell I had all four versions 8.0 - 8.3 installed in order to use postgres, ruby, perl, and rails together. Do you mean that Macports installed different versions of Postgres because the other packages had different dependencies? Don't know if compiling from source would help you there, but surely there must be some way to tell the package manager that a certain dependency already exists, albeit somewhere else? Sincerely, Niklas Johansson -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
Re: [GENERAL] postgresql and Mac OS X
On Oct 28, 2008, at 4:03 PM, Steve Atkins wrote: Installing from source means I can avoid the fragility of macports or fink, and know that I've built it in much the same way as the postgresql or solaris installation I'd be using for production. +1 It means I can easily pick the contrib modules I'm interested in. -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
Re: [GENERAL] postgresql and Mac OS X
Niklas Johansson wrote: On 28 okt 2008, at 23.41, Tom Allison wrote: I was using macports but got into a cluster-F on versions and multiple installs. After a spell I had all four versions 8.0 - 8.3 installed in order to use postgres, ruby, perl, and rails together. Do you mean that Macports installed different versions of Postgres because the other packages had different dependencies? Don't know if compiling from source would help you there, but surely there must be some way to tell the package manager that a certain dependency already exists, albeit somewhere else? Yes. Between different programing libraries to access postgresql I was getting caught up in multiple versions of the database itself. Very unpleasant. -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
Re: [GENERAL] postgresql and Mac OS X
On Tue, Oct 28, 2008 at 7:10 PM, Christophe [EMAIL PROTECTED] wrote: On Oct 28, 2008, at 4:03 PM, Steve Atkins wrote: Installing from source means I can avoid the fragility of macports or fink, and know that I've built it in much the same way as the postgresql or solaris installation I'd be using for production. +1 Make that +2. My primary development machine is my macbook pro, and I'd definitely suggest compiling from source. It's quite painless, and it ensures that you have exactly what you think you have on the machine. Getting it to start up automatically is pretty trivial, and I'd say that the benefits *far* outweigh the avoidance of a few annoying system administration tasks at install time. Saving myself pain over time is definitely far better than saving a bit of discomfort once, IMO! -- - David T. Wilson [EMAIL PROTECTED] -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general