Re: pg_dumpall failing from possible corrupted shared memory

[Richard Broersma Jr <rabroersma@xxxxxxxxx>]

> >> So what do you get from 'select * from pg_index where indrelid = 16737' ?
> >> If that crashes, which individual columns can you select from the row?
> 
> > I found the exact row and column that causes the server to crash.
> > http://archives.postgresql.org/pgsql-general/2006-10/msg01320.php
> 
> That didn't answer my question.

mydb=# \x
Expanded display is on.
mydb=# select * from pg_index where indrelid = 16737;
-[ RECORD 1 ]--+--------------------------
indexrelid     | 604243
indrelid       | 16737
indnatts       | 1
indisunique    | t
indisprimary   | t
indisclustered | t
indkey         | 1
indclass       | 2039
indexprs       |
indpred        |
-[ RECORD 2 ]--+--------------------------
indexrelid     | 604251
indrelid       | 16737
indnatts       | 1
indisunique    | f
indisprimary   | f
indisclustered | f
indkey         | 0
indclass       | 2039
indexprs       | ({FUNCEXPR :funcid 2020 :funcresulttype 1114 :funcretset false :funcformat 0
:args ({CONST :consttype 25 :constlen -1 :constbyval false :constisnull false :constvalue 7 [ 7 0
0 0 100 97 121 ]} {VAR :varno 1 :varattno
indpred        |
-[ RECORD 3 ]--+--------------------------
indexrelid     | 604252
indrelid       | 16737
indnatts       | 1
indisunique    | f
indisprimary   | f
indisclustered | f
indkey         | 0
indclass       | 2039
indexprs       | ({FUNCEXPR :funcid 2020 :funcresulttype 1114 :funcretset false :funcformat 0
:args ({CONST :consttype 25 :constlen -1 :constbyval false :constisnull false :constvalue 8 [ 8 0
0 0 104 111 117 114 ]} {VAR :varno 1 :varattno 1 :vartype 1114 :vartypmod -1 :varlevelsup 0
:varnoold 1 :varoattno 1})})
indpred        |
-[ RECORD 4 ]--+--------------------------
indexrelid     | 604253
indrelid       | 16737
indnatts       | 1
indisunique    | f
indisprimary   | f
indisclustered | f
indkey         | 0
indclass       | 2039
indexprs       | ({FUNCEXPR :funcid 2020 :funcresulttype 1114 :funcretset false :funcformat 0
:args ({CONST :consttype 25 :constlen -1 :constbyval false :constisnull false :constvalue 10 [ 10
0 0 0 109 105 110 117 116 101 ]} {VAR :varno 1 :varattno 1 :vartype 1114 :vartypmod -1
:varlevelsup 0 :varnoold 1 :varoattno 1})})
indpred        |


Sorry about that,

Regards,

Richard Broersma Jr.