Обсуждение: pg_dump doesn't work on Linux PPC

Marco Pratesi (pratesi@fitcom.it) reports a bug with a severity of 1
The lower the number the more severe it is.

Short Description
pg_dump doesn't work on Linux PPC

Long Description
The description is very simple.
I am using PostgreSQL 7.0.2 on Yellow Dog Linux CS 1.2,
I use the official RPMs.

bash$ pg_dump pgmarket -u
Username: postgres
Password:

getFuncs(): SELECT failed.  Explanation from backend: 'ERROR:  getattproperties: no attribute tuple 1255 -2
'.
bash$ uname -a
Linux localhost.localdomain 2.2.16 #9 Mon Aug 7 14:59:54 CEST 2000 ppc unknown

If I have to dump my data, I have to downgrade to the 7.0 version,
but with 7.0 I have a problem with a JOIN, hence I have had
to upgrade.
To store my data on ascii files, I have to use COPY
on the psql prompt.

Also pgaccess and ODBC connections don't work, the error messages
are almost the same.

Is it a known problem ?
Does it exist a workaround ?
Can it be solved ?

Many thanks in advance.


Sample Code


No file was uploaded with this report

pgsql-bugs@postgresql.org wrote:
>
> Marco Pratesi (pratesi@fitcom.it) reports a bug with a severity of 1
> The lower the number the more severe it is.
>
> Short Description
> pg_dump doesn't work on Linux PPC
>
> Long Description
> The description is very simple.
> I am using PostgreSQL 7.0.2 on Yellow Dog Linux CS 1.2,
> I use the official RPMs.

There are known problems with the _official_ RPM's on PPC.
Specifically, they are compiled with an optimization setting too high.
Look for 7.0.3 PPC RPM's soon.
--
Lamar Owen
WGCR Internet Radio
1 Peter 4:11