Re: [GENERAL] Pgsql on Solaris
On 10/31/06, [EMAIL PROTECTED] <[EMAIL PROTECTED]> wrote: How widespread is the use of PostgreSQL on Solaris? I am beginning to sense that community support is not currently very strong on this platform, and that pgsql may not be the best candidate for my current project -- installing LXR on a 64-bit Solaris system. I recently compiled pg on a sun solaris 10/ultra sparc iii with no issues. I had never used sparc or solaris prevously. Once I got a handle on Sun's particular spin on unix, I determined the box to be quite an amazing workhorse. merlin ---(end of broadcast)--- TIP 9: In versions below 8.0, the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match
Re: [GENERAL] Pgsql on Solaris
[EMAIL PROTECTED] wrote: Thanks to all who replied. The reason I wanted to go 64-bit on our Fujitsu sparc-alikes was that our sysadmins switched to 64-bit Perl as part of the standard package, and that broke our DBD::Pg interface. With no warning, we started getting a message about Pg.so, "Wrong ELF Class: ELFCLASS32". My assumption had been that 64-bit was the latest and greatest, so of course config should have found the appropriate libraries etc. and set me up for a 64-bit make. The answer to my question seems to be yes, I could cause 64-bit compilation, but it's not the obvious way to go. You only need the client libraries as 64-bit for this particular problem . Of course, if server and client are on the same machine then it's probably simpler to have everything the same. -- Richard Huxton Archonet Ltd ---(end of broadcast)--- TIP 5: don't forget to increase your free space map settings
Re: [GENERAL] Pgsql on Solaris
Ray Stell wrote: > I was interested in going down that path. This thread seems to be sparc > oriented. How about on opteron? Will pg work on solaris10 without too > much stress? PostgreSQL will work wonderfully on Solaris10 Opteron. Joshua D> Drake > >> isainfo -v > 64-bit amd64 applications > sse3 sse2 sse fxsr amd_3dnowx amd_3dnow amd_mmx mmx cmov amd_sysc cx8 > tsc fpu > 32-bit i386 applications > sse3 sse2 sse fxsr amd_3dnowx amd_3dnow amd_mmx mmx cmov amd_sysc cx8 > tsc fpu > > thanks. > > > > On Tue, Oct 31, 2006 at 10:43:55AM -0700, [EMAIL PROTECTED] wrote: >> So, please advise as to the level of 64-bit Solaris 10 activity with pgsql. >> > > ---(end of broadcast)--- > TIP 2: Don't 'kill -9' the postmaster > -- === The PostgreSQL Company: Command Prompt, Inc. === Sales/Support: +1.503.667.4564 || 24x7/Emergency: +1.800.492.2240 Providing the most comprehensive PostgreSQL solutions since 1997 http://www.commandprompt.com/ Donate to the PostgreSQL Project: http://www.postgresql.org/about/donate ---(end of broadcast)--- TIP 1: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly
Re: [GENERAL] Pgsql on Solaris
Thanks to all who replied. The reason I wanted to go 64-bit on our Fujitsu sparc-alikes was that our sysadmins switched to 64-bit Perl as part of the standard package, and that broke our DBD::Pg interface. With no warning, we started getting a message about Pg.so, "Wrong ELF Class: ELFCLASS32". My assumption had been that 64-bit was the latest and greatest, so of course config should have found the appropriate libraries etc. and set me up for a 64-bit make. The answer to my question seems to be yes, I could cause 64-bit compilation, but it's not the obvious way to go. I don't know if our Fujis might be faster in 64-bit mode, but who cares when you're talking about CGIs? So I think I'll beat on the admins to give me a 32-bit Perl under a different name for talking to Pgsql. (Our Sun operation is heavily administered to simulate our production world. We also have linux boxes where we can play god if we feel that need.) Thanks again, Victor Odhner ---(end of broadcast)--- TIP 6: explain analyze is your friend
Re: [GENERAL] Pgsql on Solaris
On Tue, Oct 31, 2006 at 10:43:55AM -0700, [EMAIL PROTECTED] wrote: > How widespread is the use of PostgreSQL on Solaris? I am beginning Well, one of the core members (Josh Berkus) actually works for Sun, and Sun is officially supporting PostgreSQL in some capacity. Moreover, I ran our Postgres installations on Solaris for years, and would have continued to do so if I coulda got Sun to be nice to me as a customer. (There's more to that story, though, most of which I can't discuss.) I believe there are actually packaged binaries available for Solaris, but I always built my own using gcc. So It Worked For Me(tm) is about all I can tell you. > I had to do a lot of web searching to learn how to get past a > compilation problem, apparently fixed for the current release; and > now It appears (based on the reply below) that the "configure" > setup is not ready to recognize 64-bit solaris environment; the I don't see how my reply says anything of the sort. All you asked was how you did that, and I asked you what I think are reasonable questions, like "do you have a compiler that produces 64 bit binaries?" I certainly don't know any of that from what you've told me so far. Posting the exact error message you're getting might lead you to more productive responses from people using Solaris today. Or maybe you can use the packages, and you don't need to build it. A -- Andrew Sullivan | [EMAIL PROTECTED] Unfortunately reformatting the Internet is a little more painful than reformatting your hard drive when it gets out of whack. --Scott Morris ---(end of broadcast)--- TIP 1: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly
Re: [GENERAL] Pgsql on Solaris
Ray Stell <[EMAIL PROTECTED]> writes: > I was interested in going down that path. This thread seems to be sparc > oriented. How about on opteron? Will pg work on solaris10 without too > much stress? It seems like most of the questions in this thread could be answered by perusing the latest version of FAQ_Solaris: http://developer.postgresql.org/cvsweb.cgi/~checkout~/pgsql/doc/FAQ_Solaris?rev=1.22 In particular note the advice *against* using 64-bit on Sparc unless you have a strong reason why you need it (hint: you probably don't). regards, tom lane ---(end of broadcast)--- TIP 4: Have you searched our list archives? http://archives.postgresql.org/
Re: [GENERAL] Pgsql on Solaris
On Oct 31, 2006, at 9:43 AM, <[EMAIL PROTECTED]> <[EMAIL PROTECTED]> wrote: How widespread is the use of PostgreSQL on Solaris? I am beginning to sense that community support is not currently very strong on this platform, and that pgsql may not be the best candidate for my current project -- installing LXR on a 64-bit Solaris system. I had to do a lot of web searching to learn how to get past a compilation problem, apparently fixed for the current release; and now It appears (based on the reply below) that the "configure" setup is not ready to recognize 64-bit solaris environment; the 32- bit executables are incompatible with 64-bit Perl. I am not an autoconf hacker, and can't afford in this case to go "where none have gone before". You should be able to build it just by setting CFLAGS and LDFLAGS appropriately, e.g. "-xarch=v9", but my build scripts actually do it by setting CC to "cc -xarch=v9" - I don't recall why I did that, but it's possible there was something funky with flags handling somewhere in the build process. Works fine, and has done for years. I've had 64 bit sparc builds running happily since 7.2 or so. That's all assuming you're using Sun compilers on sparc. If not, I've no idea whether you can even build 64 bit binaries. Cheers, Steve This is always a challenge with Free Software, of course: potential users of a given product need to know how to pick their battles. So, please advise as to the level of 64-bit Solaris 10 activity with pgsql. Thanks, Victor Odhner Andrew Sullivan <[EMAIL PROTECTED]> wrote: 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 a compiler that can generate 64 bit binaries? How about your libs? A ---(end of broadcast)--- TIP 3: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faq ---(end of broadcast)--- TIP 5: don't forget to increase your free space map settings
Re: [GENERAL] Pgsql on Solaris
I was interested in going down that path. This thread seems to be sparc oriented. How about on opteron? Will pg work on solaris10 without too much stress? > isainfo -v 64-bit amd64 applications sse3 sse2 sse fxsr amd_3dnowx amd_3dnow amd_mmx mmx cmov amd_sysc cx8 tsc fpu 32-bit i386 applications sse3 sse2 sse fxsr amd_3dnowx amd_3dnow amd_mmx mmx cmov amd_sysc cx8 tsc fpu thanks. On Tue, Oct 31, 2006 at 10:43:55AM -0700, [EMAIL PROTECTED] wrote: > So, please advise as to the level of 64-bit Solaris 10 activity with pgsql. > ---(end of broadcast)--- TIP 2: Don't 'kill -9' the postmaster
[GENERAL] Pgsql on Solaris
How widespread is the use of PostgreSQL on Solaris? I am beginning to sense that community support is not currently very strong on this platform, and that pgsql may not be the best candidate for my current project -- installing LXR on a 64-bit Solaris system. I had to do a lot of web searching to learn how to get past a compilation problem, apparently fixed for the current release; and now It appears (based on the reply below) that the "configure" setup is not ready to recognize 64-bit solaris environment; the 32-bit executables are incompatible with 64-bit Perl. I am not an autoconf hacker, and can't afford in this case to go "where none have gone before". This is always a challenge with Free Software, of course: potential users of a given product need to know how to pick their battles. So, please advise as to the level of 64-bit Solaris 10 activity with pgsql. Thanks, Victor Odhner Andrew Sullivan <[EMAIL PROTECTED]> wrote: 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 a compiler that can generate 64 bit binaries? How about your libs? A ---(end of broadcast)--- TIP 3: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faq
