[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