Thread

  1. pg_dump 7.0.2 fails on linuxppc

    Andrew Smith <andrew@thesoftwaresmith.com.au> — 2000-10-03T17:00:35Z

    Hi People,
    
    I have encountered the following problem with pg_dump from postgresql
    7.0.2 on linuxppc:
    
    bash $ pg_dump template1 >tp.db
    getFuncs(): SELECT failed.  Explanation from backend: 'ERROR:
    getattproperties: no attribute tuple 1255 -2'.
    
    CONFIGURATION
    
    machine: PowerMac Rev2 B/W G3 450, 256MB RAM, 2 x 9GB u2/w scsi
    kernel: LinuxPPC 2.2.17pre13 with RAID patches
    distribution: LinuxPPC 2000 Q1
    
    postgresql: built from postgresql-7.0.2-2.src.rpm for target ppc
    compiler: gcc 2.95.2 built with --with-cpu=750
    
    I encountered the same problem with postgresql built from the 7.0.2
    tarball for linuxppc.
    
    I have also built postgresql 7.0.2 for i686 (RedHat 6.1) but the problem
    is not evident on that architecture.
    
    Cheers,
    Andrew
    
    
    
    
  2. Re: pg_dump 7.0.2 fails on linuxppc

    Tom Lane <tgl@sss.pgh.pa.us> — 2000-10-10T04:02:51Z

    Andrew Smith <Andrew@TheSoftwareSmith.Com.Au> writes:
    > I have encountered the following problem with pg_dump from postgresql
    > 7.0.2 on linuxppc:
    
    > bash $ pg_dump template1 >tp.db
    > getFuncs(): SELECT failed.  Explanation from backend: 'ERROR:
    > getattproperties: no attribute tuple 1255 -2'.
    
    7.0.* does not really work on PPC unless built with -O0.  I believe
    this should happen automatically because of the contents of
    src/template/linux_ppc, but perhaps that template didn't get selected
    when you rebuilt?
    
    The good news is that the underlying portability problem is (at long
    last) fixed in current sources.  I've run successful regression tests
    on a G3 with current sources and -O2.
    
    			regards, tom lane