[HACKERS] Intel x64 vs AMD x64 pgdata
Hey folks, Asking here since it may deal with clever things such as alignment and or binary reps. I'm migrating from some opterons to some xeons (E5345) both are running x86_64. At first I figured I'd need to dump & load my data, which will be painful. But on a whim I made a test db on the opteron, copied it over (tar) and it fired up and worked fine on the xeon. Seeing the success of this, I took our PITR backup and restored it properly, and everything seems to be functioning correctly from my tests. Is there anything I should be weary of doing this? I'd figure any alignment or other issues would have bitten me in my testing or PG would simply refuse to start. btw, the version in question is 8.2.5 thanks guys! -- Jeff Trout <[EMAIL PROTECTED]> http://www.dellsmartexitin.com/ http://www.stuarthamm.net/ ---(end of broadcast)--- TIP 4: Have you searched our list archives? http://archives.postgresql.org
Re: [HACKERS] plperl/plperlu interaction
On Oct 26, 2006, at 3:23 PM, Martijn van Oosterhout wrote: On Thu, Oct 26, 2006 at 03:15:00PM -0400, Andrew Dunstan wrote: Perhaps people who use other platforms could look for these flags in the output of perl -e 'use Config qw(myconfig config_sh config_vars config_re); print config_sh();' OSX 10.4.8: usemultiplicity='define' usethreads='define' useithreads='define' -- Jeff Trout <[EMAIL PROTECTED]> http://www.dellsmartexitin.com/ http://www.stuarthamm.net/ ---(end of broadcast)--- TIP 3: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faq
Re: [HACKERS] plPHP and plRuby
On Jul 20, 2006, at 8:49 PM, Joshua D. Drake wrote: It could be interesting to have something like this: ./configure --with-plruby and it would actually fetch the latest plruby sources from the net and build. Ala Ports. Or if we didn't want to develop that infastructure of auto-fetching & whatnot we could have --with-plruby output some info like "download foo, put there and rerun configure" (essentially what would be in the src/pl*/README.txt idea). A lot of folks would look at the output of configure --help to see what's available instead of poking around src/pl/* -- Jeff Trout <[EMAIL PROTECTED]> http://www.dellsmartexitin.com/ http://www.stuarthamm.net/ ---(end of broadcast)--- TIP 3: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faq
Re: [HACKERS] Segfault Exiting psql
On Jan 27, 2006, at 10:21 AM, Jason Essington wrote:
Has there been any movement on this? as of 8.1.2 psql still whines
on OS X tiger when you exit.
I realize it is not significant, but I'd still rather not see it.
In the interim, I've done:
errno = 0;
write_history(fname); /* return value is not standardized */
if (errno)
psql_error("could not save history to file \"%s\": %s\n", fname,
strerror(errno));
else
return true;
I can into this recently on my osx install.
It is another case of Apple being really, really stupid.
Look to see if /usr/lib/libreadline.dylib is a symlink to libedit
Once I made libreadline actually readline, it stopped segfaulting.
(Highly annoying since I kept trying to recompile to get it to work).
You can also use otool -L psql to check to see what it is actually
linking as well.
(You were getting those core dumps and the message about szone_error
right - I missed the rest of the thread)
--
Jeff Trout <[EMAIL PROTECTED]>
http://www.jefftrout.com/
http://www.stuarthamm.net/
---(end of broadcast)---
TIP 3: Have you checked our extensive FAQ?
http://www.postgresql.org/docs/faq
Re: [HACKERS] Which qsort is used
Here's some results for a 2.5Ghz G5 and a 933Mhz G4 http://www.jefftrout.com/sort/ -- Jeff Trout <[EMAIL PROTECTED]> http://www.jefftrout.com/ http://www.stuarthamm.net/ ---(end of broadcast)--- TIP 2: Don't 'kill -9' the postmaster
Re: [HACKERS] SHMMAX seems entirely broken in OS X 10.4.2
On Aug 30, 2005, at 12:37 AM, Tom Lane wrote: Did that. Set shmall first, shmall second, both together in one sysctl command; no joy anywhere. Are you trying this on fully up-to-date Tiger? Just ran software update and (besides a couple apps) it had a security update. skittlebrau:~ postgres$ grep shm /etc/rc # sysctl -w kern.sysv.shmmax=4194305 kern.sysv.shmmin=1 kern.sysv.shmmni=32 kern.sysv.shmseg=8 kern.sysv.shmall=1024 sysctl -w kern.sysv.shmmax=335544320 sysctl -w kern.sysv.shmmin=1 sysctl -w kern.sysv.shmmni=32 sysctl -w kern.sysv.shmseg=16 sysctl -w kern.sysv.shmall=327680 skittlebrau:~ postgres$ sysctl -a | grep shm kern.sysv.shmmax: 335544320 kern.sysv.shmmin: 1 kern.sysv.shmmni: 32 kern.sysv.shmseg: 16 kern.sysv.shmall: 327680 good luck. -- Jeff Trout <[EMAIL PROTECTED]> http://www.jefftrout.com/ http://www.stuarthamm.net/ ---(end of broadcast)--- TIP 2: Don't 'kill -9' the postmaster
Re: [HACKERS] Timezone bugs
On Jul 21, 2005, at 11:57 PM, Bruce Momjian wrote: >works fine now. It will also obey whatever DST rules were in effect at >just that date, which the previous implementation did not. Speaking of that, would the nearly passed US bill to extend daylight savings screw up our timezone & dst things? http://usgovinfo.about.com/od/consumerawareness/a/dstextend.htm (nutshell summary: DST would be changed from april-oct to mar-nov) afaik it has passed the house & senate it just needs the prez to sign it. -- Jeff Trout <[EMAIL PROTECTED]> http://www.jefftrout.com/ http://www.stuarthamm.net/ ---(end of broadcast)--- TIP 6: explain analyze is your friend
Re: [HACKERS] Problems compiling Postgresql 8.0.3 on 10.4
On Jul 20, 2005, at 5:58 AM, Dave Cramer wrote: Hi, i have just installed 10.4 on one of our machines and cannot get past this error during make /usr/bin/libtool: for architecture: cputype (16777234) cpusubtype (0) file: -lSystem is not an object file (not allowed in a library) Install the new Xcode. that should fix it. -- Jeff Trout <[EMAIL PROTECTED]> http://www.jefftrout.com/ http://www.stuarthamm.net/ ---(end of broadcast)--- TIP 4: Have you searched our list archives? http://archives.postgresql.org
Re: [HACKERS] Solaris initdb fails: shmmax tweak alternative?
On Apr 4, 2004, at 3:41 PM, Greg Sabino Mullane wrote: I am trying to get version 7.4.2 installed on a Solaris box, but initdb fails because of shmmax being set too low. It does this even though initdb drops shared buffers as low as it can go (50). Is there any other way of getting around this limitation? I know You can also check out max_connections. Each one of those gobbles up shared memory. Unfortunately, there isn't anything else you can really do beyond taking down shared_buffers and max_connections. Its annoying, but if it makes you feel better, Informix or Oracle would have the same problem. -- Jeff Trout <[EMAIL PROTECTED]> http://www.jefftrout.com/ http://www.stuarthamm.net/ ---(end of broadcast)--- TIP 9: the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match
