Обсуждение: Linux Alpha destroydb and pg_dump problem

Hi,

On my Alpha (linux-2.2.12), destroydb and pg_dump kill the backend.

Basically, the pg_database table is queried for the "oid" column which
is never found/reached.
A "select oid from pg_database" has the same effect, ie. kills the backend.

On my Intel box all the above works.

Does anyone have any ideas/pointers?

Cheers,

Gerd.

gerd@babe.bibliotech.net wrote:
>
> Hi,
>
> On my Alpha (linux-2.2.12), destroydb and pg_dump kill the backend.
>
> Basically, the pg_database table is queried for the "oid" column which
> is never found/reached.
> A "select oid from pg_database" has the same effect, ie. kills the backend.

What version of PostgreSQL?  With what patches?

Lamar Owen
WGCR Internet Radio

Oops, user ineptitude detected.

This applies to version 6.5.1, no patches.

GJ.

>
> On my Alpha (linux-2.2.12), destroydb and pg_dump kill the backend.
>
> Basically, the pg_database table is queried for the "oid" column which
> is never found/reached.
> A "select oid from pg_database" has the same effect, ie. kills the backend.
>
> On my Intel box all the above works.
>
> Does anyone have any ideas/pointers?
>
> Cheers,
>
> Gerd.
>
> ************
>

gerd@babe.bibliotech.net wrote:
>
> Oops, user ineptitude detected.
>
> This applies to version 6.5.1, no patches.
>
> GJ.

You will need the alpha patches put together by Uncle George and Ryan
Kirkpatrick -- you can download at
www.ramifordistat.net/postgres/postgresql-6.5.1-alpha.patch.gz

Untar a fresh distribution of 6.5.1, put the patchset in its dir,
CD to the postgresql-6.5.1 directory,
gzip -d -c postgresql-6.5.1-alpha.patch.gz|patch -p1
rebuild, and things should work.  This is the patchset that is going in
RedHat 6.1 to make PostgreSQL work right on Alpha.

Oh, that is the numeral one after the -p (just in case you read is as a
lowercase ell.)

HTH

Lamar Owen
WGCR Internet Radio