Change the relfilenode in above from 13741353 to 5214493
I' no change yeat, but i will...
select * from pg_classs where reltoastrelid = 9277970
returns:
oid | relname | relnamespace | reltype | reloftype | relowner | relam | relfilenode | reltablespace | relpages | reltuples | relallvisible | reltoastrelid | reltoastidxid | relhasindex | relisshared | relpersistence | relkind | relnatts | relchecks | relhasoids | relhaspkey | relhasrules | relhastriggers | relhassubclass | relispopulated | relfrozenxid | relminmxid | relacl | reloptions
---------+-------------+--------------+---------+-----------+----------+-------+-------------+---------------+----------+--------------+---------------+---------------+---------------+-------------+-------------+----------------+---------+----------+-----------+------------+------------+-------------+----------------+----------------+----------------+--------------+------------+--------+------------
9277966 | repositorio | 9277964 | 9277968 | 0 | 10 | 0 | 9277966 | 9277962 | 43779 | 1.50905e+006 | 43779 | 9277970 | 0 | t | f | p | r | 6 | 0 | f | t | f | f | f | t | 9360288 | 1 | |
(1 registro)
What is not clear is what 5214495 is?
Not to me either
select * from pg_class where relfilenode = 5214495;
returns: none records
But I'm worried about the select error. You are returning the table:pg_toast_9277966 not the pg_toast_5214489... bellow
ERROR: missing chunk number 0 for toast value 10259186 in pg_toast_9277966
Could it be because of the filenode link that is still pointing to another? -> 13741353
2017-06-06 21:08 GMT-03:00 Adrian Klaver <adrian.klaver@xxxxxxxxxxx>:
On 06/06/2017 02:07 PM, tel medola wrote:
rai=# select oid, * from pg_class where oid = 5214493;
result:
oid | relname | relnamespace | reltype | reloftype | relowner | relam | relfilenode | reltablespace | relpages | reltuples | relallvisible | reltoastrelid | reltoastidxid | relhasindex | relisshared | relpersistence | relkind | relnatts | relchecks | relhasoids | relhaspkey | relhasrules | relhastriggers | relhassubclass | relispopulated | relfrozenxid | relminmxid | relacl | reloptions
---------+------------------+--------------+---------+------ -----+----------+-------+----- --------+---------------+----- -----+-----------+------------ ---+---------------+---------- -----+-------------+---------- ---+----------------+--------- +----------+-----------+------ ------+------------+---------- ---+----------------+--------- -------+----------------+----- ---------+------------+------- -+------------
5214493 | pg_toast_5214489 | 99 | 5214494 | 0 | 10 | 0 | 13741353 | 5205910 | 0 | 0 | 0 | 0 | 5214495 | t | f | p | t | 3 | 0 | f | t | f | f | f | t | 9360288 | 1 | |
(1 registro)
Change the relfilenode in above from 13741353 to 5214493
If I do the select below (which is toast it returns me in error):
Select oid, * from pg_class where relname = 'pg_toast_9277966'
He will return me:
Not sure here. I would try:
select * from pg_classs where reltoastrelid = 9277970;
to see what table is claiming it.
I do not know if it helps, but the folder structure looks like this:
The file names = the relfilenode + additional info
5214489 is your repositorio table
5214489_fsm is the Free Space Map for that table.
5214493 and 5214493.x is your TOAST table broken down into 1 GB chunks.
What is not clear is what 5214495 is?
select * from pg_class where relfilenode = 5214495;
might help, unless it was also TRUNCATEd. In that case it depends on you knowing what other table then repositorio you had in the tablespace.
2017-06-06 16:37 GMT-03:00 Adrian Klaver <adrian.klaver@xxxxxxxxxxx <mailto:adrian.klaver@aklaver.
Volume in drive G is Gravacoes-III
Volume Serial Number is 8CF9-EDFA
Directory of g:\PG_9.3_201306121\32768
06/06/2017 13:18 <DIR> .
06/06/2017 13:18 <DIR> ..
23/05/2017 08:25 0 13741352
23/05/2017 08:25 0 13741353
06/06/2017 12:04 8.192 13789591
20/05/2016 09:10 649.650.176 5214489
20/05/2016 09:10 180.224 5214489_fsm
19/05/2016 23:47 16.384 5214489_vm
25/04/2016 09:00 1.073.741.824 5214493
25/04/2016 09:00 1.073.741.824 5214493.1
25/04/2016 09:00 1.073.741.824 5214493.10
25/04/2016 09:00 1.073.741.824 5214493.100
25/04/2016 09:00 1.073.741.824 5214493.101
25/04/2016 09:00 1.073.741.824 5214493.102
25/04/2016 09:00 1.073.741.824 5214493.103
25/04/2016 09:00 1.073.741.824 5214493.104
25/04/2016 09:00 1.073.741.824 5214493.105
25/04/2016 09:00 1.073.741.824 5214493.106
25/04/2016 09:00 1.073.741.824 5214493.107
25/04/2016 09:00 1.073.741.824 5214493.108
25/04/2016 09:00 1.073.741.824 5214493.109
25/04/2016 09:00 1.073.741.824 5214493.11
25/04/2016 09:00 1.073.741.824 5214493.110
25/04/2016 09:00 1.073.741.824 5214493.111
25/04/2016 09:00 1.073.741.824 5214493.112
25/04/2016 09:00 1.073.741.824 5214493.113
25/04/2016 09:00 1.073.741.824 5214493.114
25/04/2016 09:00 1.073.741.824 5214493.115
25/04/2016 09:00 1.073.741.824 5214493.116
25/04/2016 09:00 1.073.741.824 5214493.117
25/04/2016 09:00 1.073.741.824 5214493.118
25/04/2016 09:00 1.073.741.824 5214493.119
25/04/2016 09:00 1.073.741.824 5214493.12
25/04/2016 09:00 1.073.741.824 5214493.120
25/04/2016 09:00 1.073.741.824 5214493.121
25/04/2016 09:00 1.073.741.824 5214493.122
25/04/2016 09:00 1.073.741.824 5214493.123
25/04/2016 09:00 1.073.741.824 5214493.124
25/04/2016 09:00 1.073.741.824 5214493.125
25/04/2016 09:00 1.073.741.824 5214493.126
25/04/2016 09:00 1.073.741.824 5214493.127
25/04/2016 09:00 1.073.741.824 5214493.128
25/04/2016 09:00 1.073.741.824 5214493.129
25/04/2016 09:00 1.073.741.824 5214493.13
25/04/2016 09:00 1.073.741.824 5214493.130
25/04/2016 09:00 1.073.741.824 5214493.131
25/04/2016 09:00 1.073.741.824 5214493.132
25/04/2016 09:00 1.073.741.824 5214493.133
25/04/2016 09:00 1.073.741.824 5214493.134
25/04/2016 09:00 1.073.741.824 5214493.135
25/04/2016 09:00 1.073.741.824 5214493.136
25/04/2016 09:00 1.073.741.824 5214493.137
25/04/2016 09:00 1.073.741.824 5214493.138
25/04/2016 09:00 1.073.741.824 5214493.139
25/04/2016 09:00 1.073.741.824 5214493.14
25/04/2016 09:00 1.073.741.824 5214493.140
25/04/2016 09:00 1.073.741.824 5214493.141
25/04/2016 09:00 1.073.741.824 5214493.142
25/04/2016 09:00 1.073.741.824 5214493.143
25/04/2016 09:00 1.073.741.824 5214493.144
25/04/2016 09:00 1.073.741.824 5214493.145
25/04/2016 09:00 1.073.741.824 5214493.146
25/04/2016 09:00 1.073.741.824 5214493.147
25/04/2016 09:00 1.073.741.824 5214493.148
25/04/2016 09:00 1.073.741.824 5214493.149
25/04/2016 09:00 1.073.741.824 5214493.15
25/04/2016 09:00 1.073.741.824 5214493.150
25/04/2016 09:00 1.073.741.824 5214493.151
25/04/2016 09:00 1.073.741.824 5214493.152
25/04/2016 09:00 1.073.741.824 5214493.153
25/04/2016 09:00 1.073.741.824 5214493.154
25/04/2016 09:00 1.073.741.824 5214493.155
25/04/2016 09:00 1.073.741.824 5214493.156
25/04/2016 09:00 1.073.741.824 5214493.157
25/04/2016 09:00 1.073.741.824 5214493.158
25/04/2016 09:00 1.073.741.824 5214493.159
25/04/2016 09:00 1.073.741.824 5214493.16
25/04/2016 09:00 1.073.741.824 5214493.160
25/04/2016 09:00 1.073.741.824 5214493.161
25/04/2016 09:00 1.073.741.824 5214493.162
25/04/2016 09:00 1.073.741.824 5214493.163
25/04/2016 09:00 1.073.741.824 5214493.164
25/04/2016 09:00 1.073.741.824 5214493.165
25/04/2016 09:00 1.073.741.824 5214493.166
25/04/2016 09:00 1.073.741.824 5214493.167
25/04/2016 09:00 1.073.741.824 5214493.168
25/04/2016 09:00 1.073.741.824 5214493.169
25/04/2016 09:00 1.073.741.824 5214493.17
25/04/2016 09:00 1.073.741.824 5214493.170
25/04/2016 09:00 1.073.741.824 5214493.171
25/04/2016 09:00 1.073.741.824 5214493.172
25/04/2016 09:00 1.073.741.824 5214493.173
25/04/2016 09:00 1.073.741.824 5214493.174
25/04/2016 09:00 1.073.741.824 5214493.175
25/04/2016 09:00 1.073.741.824 5214493.176
25/04/2016 09:00 1.073.741.824 5214493.177
25/04/2016 09:00 1.073.741.824 5214493.178
25/04/2016 09:00 1.073.741.824 5214493.179
25/04/2016 09:00 1.073.741.824 5214493.18
25/04/2016 09:00 1.073.741.824 5214493.180
25/04/2016 09:00 1.073.741.824 5214493.181
25/04/2016 09:00 1.073.741.824 5214493.182
25/04/2016 09:00 1.073.741.824 5214493.183
25/04/2016 09:00 1.073.741.824 5214493.184
25/04/2016 09:00 1.073.741.824 5214493.185
25/04/2016 09:00 1.073.741.824 5214493.186
25/04/2016 09:00 1.073.741.824 5214493.187
25/04/2016 09:00 1.073.741.824 5214493.188
25/04/2016 09:00 1.073.741.824 5214493.189
25/04/2016 09:00 1.073.741.824 5214493.19
25/04/2016 09:00 1.073.741.824 5214493.190
25/04/2016 09:00 1.073.741.824 5214493.191
25/04/2016 09:00 1.073.741.824 5214493.192
25/04/2016 09:00 1.073.741.824 5214493.193
25/04/2016 09:00 1.073.741.824 5214493.194
25/04/2016 09:00 1.073.741.824 5214493.195
25/04/2016 09:00 1.073.741.824 5214493.196
25/04/2016 09:00 1.073.741.824 5214493.197
25/04/2016 09:00 1.073.741.824 5214493.198
25/04/2016 09:00 1.073.741.824 5214493.199
25/04/2016 09:00 1.073.741.824 5214493.2
25/04/2016 09:00 1.073.741.824 5214493.20
25/04/2016 09:00 1.073.741.824 5214493.200
25/04/2016 09:00 1.073.741.824 5214493.201
25/04/2016 09:00 1.073.741.824 5214493.202
25/04/2016 09:00 1.073.741.824 5214493.203
25/04/2016 09:00 1.073.741.824 5214493.204
25/04/2016 09:00 1.073.741.824 5214493.205
25/04/2016 09:00 1.073.741.824 5214493.206
25/04/2016 09:00 1.073.741.824 5214493.207
25/04/2016 09:00 1.073.741.824 5214493.208
25/04/2016 09:00 1.073.741.824 5214493.209
25/04/2016 09:00 1.073.741.824 5214493.21
25/04/2016 09:00 1.073.741.824 5214493.210
25/04/2016 09:00 1.073.741.824 5214493.211
25/04/2016 09:00 1.073.741.824 5214493.212
25/04/2016 09:00 1.073.741.824 5214493.213
25/04/2016 09:00 1.073.741.824 5214493.214
25/04/2016 09:00 1.073.741.824 5214493.215
25/04/2016 09:00 1.073.741.824 5214493.216
25/04/2016 09:00 1.073.741.824 5214493.217
25/04/2016 09:00 1.073.741.824 5214493.218
25/04/2016 09:00 1.073.741.824 5214493.219
25/04/2016 09:00 1.073.741.824 5214493.22
25/04/2016 09:00 1.073.741.824 5214493.220
25/04/2016 09:00 1.073.741.824 5214493.221
25/04/2016 09:00 1.073.741.824 5214493.222
25/04/2016 09:00 1.073.741.824 5214493.223
25/04/2016 09:00 1.073.741.824 5214493.224
25/04/2016 09:00 1.073.741.824 5214493.225
25/04/2016 09:00 1.073.741.824 5214493.226
25/04/2016 09:00 1.073.741.824 5214493.227
25/04/2016 09:00 1.073.741.824 5214493.228
25/04/2016 09:00 1.073.741.824 5214493.229
25/04/2016 09:00 1.073.741.824 5214493.23
25/04/2016 09:00 1.073.741.824 5214493.230
25/04/2016 09:00 1.073.741.824 5214493.231
25/04/2016 09:00 1.073.741.824 5214493.232
25/04/2016 09:00 1.073.741.824 5214493.233
25/04/2016 09:00 1.073.741.824 5214493.234
25/04/2016 09:00 1.073.741.824 5214493.235
25/04/2016 09:00 1.073.741.824 5214493.236
25/04/2016 09:00 1.073.741.824 5214493.237
25/04/2016 09:00 1.073.741.824 5214493.238
25/04/2016 09:00 1.073.741.824 5214493.239
25/04/2016 09:00 1.073.741.824 5214493.24
25/04/2016 09:00 1.073.741.824 5214493.240
25/04/2016 09:00 1.073.741.824 5214493.241
25/04/2016 09:00 1.073.741.824 5214493.242
25/04/2016 09:00 1.073.741.824 5214493.243
25/04/2016 09:00 1.073.741.824 5214493.244
25/04/2016 09:00 1.073.741.824 5214493.245
25/04/2016 09:00 1.073.741.824 5214493.246
25/04/2016 09:00 1.073.741.824 5214493.247
25/04/2016 09:00 1.073.741.824 5214493.248
25/04/2016 09:00 1.073.741.824 5214493.249
25/04/2016 09:00 1.073.741.824 5214493.25
25/04/2016 09:00 1.073.741.824 5214493.250
25/04/2016 09:00 1.073.741.824 5214493.251
25/04/2016 09:00 1.073.741.824 5214493.252
25/04/2016 09:00 1.073.741.824 5214493.253
25/04/2016 09:00 1.073.741.824 5214493.254
25/04/2016 09:00 1.073.741.824 5214493.255
25/04/2016 09:00 1.073.741.824 5214493.256
25/04/2016 09:00 1.073.741.824 5214493.257
25/04/2016 09:00 1.073.741.824 5214493.258
25/04/2016 09:00 1.073.741.824 5214493.259
25/04/2016 09:00 1.073.741.824 5214493.26
25/04/2016 09:00 1.073.741.824 5214493.260
25/04/2016 09:00 1.073.741.824 5214493.261
25/04/2016 09:00 1.073.741.824 5214493.262
25/04/2016 09:00 1.073.741.824 5214493.263
25/04/2016 09:00 1.073.741.824 5214493.264
25/04/2016 09:00 1.073.741.824 5214493.265
25/04/2016 09:00 1.073.741.824 5214493.266
25/04/2016 09:00 1.073.741.824 5214493.267
25/04/2016 09:00 1.073.741.824 5214493.268
25/04/2016 09:00 1.073.741.824 5214493.269
25/04/2016 09:00 1.073.741.824 5214493.27
25/04/2016 09:00 1.073.741.824 5214493.270
25/04/2016 09:00 1.073.741.824 5214493.271
25/04/2016 09:00 1.073.741.824 5214493.272
25/04/2016 09:00 1.073.741.824 5214493.273
25/04/2016 09:00 1.073.741.824 5214493.274
25/04/2016 09:00 1.073.741.824 5214493.275
25/04/2016 09:00 1.073.741.824 5214493.276
25/04/2016 09:00 1.073.741.824 5214493.277
25/04/2016 09:00 1.073.741.824 5214493.278
25/04/2016 09:00 1.073.741.824 5214493.279
25/04/2016 09:00 1.073.741.824 5214493.28
25/04/2016 09:00 1.073.741.824 5214493.280
25/04/2016 09:00 1.073.741.824 5214493.281
25/04/2016 09:00 1.073.741.824 5214493.282
25/04/2016 09:00 1.073.741.824 5214493.283
25/04/2016 09:00 1.073.741.824 5214493.284
25/04/2016 09:00 1.073.741.824 5214493.285
25/04/2016 09:00 1.073.741.824 5214493.286
25/04/2016 09:00 1.073.741.824 5214493.287
25/04/2016 09:00 1.073.741.824 5214493.288
25/04/2016 09:00 1.073.741.824 5214493.289
25/04/2016 09:00 1.073.741.824 5214493.29
25/04/2016 09:00 1.073.741.824 5214493.290
25/04/2016 09:00 1.073.741.824 5214493.291
25/04/2016 09:00 1.073.741.824 5214493.292
25/04/2016 09:00 1.073.741.824 5214493.293
25/04/2016 09:00 1.073.741.824 5214493.294
25/04/2016 09:00 1.073.741.824 5214493.295
25/04/2016 09:00 1.073.741.824 5214493.296
25/04/2016 09:00 1.073.741.824 5214493.297
25/04/2016 09:00 1.073.741.824 5214493.298
25/04/2016 09:00 1.073.741.824 5214493.299
25/04/2016 09:00 1.073.741.824 5214493.3
25/04/2016 09:00 1.073.741.824 5214493.30
25/04/2016 09:00 1.073.741.824 5214493.300
25/04/2016 09:00 1.073.741.824 5214493.301
25/04/2016 09:00 1.073.741.824 5214493.302
25/04/2016 09:00 1.073.741.824 5214493.303
25/04/2016 09:00 1.073.741.824 5214493.304
25/04/2016 09:00 1.073.741.824 5214493.305
25/04/2016 09:00 1.073.741.824 5214493.306
25/04/2016 09:00 1.073.741.824 5214493.307
25/04/2016 09:00 1.073.741.824 5214493.308
25/04/2016 09:00 1.073.741.824 5214493.309
25/04/2016 09:00 1.073.741.824 5214493.31
25/04/2016 09:00 1.073.741.824 5214493.310
25/04/2016 09:00 1.073.741.824 5214493.311
25/04/2016 09:00 1.073.741.824 5214493.312
25/04/2016 09:00 1.073.741.824 5214493.313
25/04/2016 09:00 1.073.741.824 5214493.314
25/04/2016 09:00 1.073.741.824 5214493.315
25/04/2016 09:00 1.073.741.824 5214493.316
25/04/2016 09:00 1.073.741.824 5214493.317
25/04/2016 09:00 1.073.741.824 5214493.318
25/04/2016 09:00 1.073.741.824 5214493.319
25/04/2016 09:00 1.073.741.824 5214493.32
25/04/2016 09:00 1.073.741.824 5214493.320
25/04/2016 09:00 1.073.741.824 5214493.321
25/04/2016 09:00 1.073.741.824 5214493.322
25/04/2016 09:00 1.073.741.824 5214493.323
25/04/2016 09:00 1.073.741.824 5214493.324
25/04/2016 09:00 1.073.741.824 5214493.325
25/04/2016 09:00 1.073.741.824 5214493.326
25/04/2016 09:00 1.073.741.824 5214493.327
25/04/2016 09:00 1.073.741.824 5214493.328
25/04/2016 09:00 1.073.741.824 5214493.329
25/04/2016 09:00 1.073.741.824 5214493.33
25/04/2016 09:00 1.073.741.824 5214493.330
25/04/2016 09:00 1.073.741.824 5214493.331
25/04/2016 09:00 1.073.741.824 5214493.332
25/04/2016 09:00 1.073.741.824 5214493.333
25/04/2016 09:00 1.073.741.824 5214493.334
25/04/2016 09:00 1.073.741.824 5214493.335
25/04/2016 09:00 1.073.741.824 5214493.336
25/04/2016 09:00 1.073.741.824 5214493.337
25/04/2016 09:00 1.073.741.824 5214493.338
25/04/2016 09:00 1.073.741.824 5214493.339
25/04/2016 09:00 1.073.741.824 5214493.34
25/04/2016 09:00 1.073.741.824 5214493.340
25/04/2016 09:00 1.073.741.824 5214493.341
25/04/2016 09:00 1.073.741.824 5214493.342
25/04/2016 09:00 1.073.741.824 5214493.343
25/04/2016 09:00 1.073.741.824 5214493.344
25/04/2016 09:00 1.073.741.824 5214493.345
25/04/2016 09:00 1.073.741.824 5214493.346
25/04/2016 09:00 1.073.741.824 5214493.347
25/04/2016 09:00 1.073.741.824 5214493.348
25/04/2016 09:00 1.073.741.824 5214493.349
25/04/2016 09:00 1.073.741.824 5214493.35
25/04/2016 09:00 1.073.741.824 5214493.350
25/04/2016 09:00 1.073.741.824 5214493.351
25/04/2016 09:00 1.073.741.824 5214493.352
25/04/2016 09:00 1.073.741.824 5214493.353
25/04/2016 09:00 1.073.741.824 5214493.354
25/04/2016 09:00 1.073.741.824 5214493.355
25/04/2016 09:00 1.073.741.824 5214493.356
25/04/2016 09:00 1.073.741.824 5214493.357
25/04/2016 09:00 1.073.741.824 5214493.358
25/04/2016 09:00 1.073.741.824 5214493.359
25/04/2016 09:00 1.073.741.824 5214493.36
25/04/2016 09:00 1.073.741.824 5214493.360
25/04/2016 09:00 1.073.741.824 5214493.361
25/04/2016 09:00 1.073.741.824 5214493.362
25/04/2016 09:00 1.073.741.824 5214493.363
25/04/2016 09:00 1.073.741.824 5214493.364
25/04/2016 09:00 1.073.741.824 5214493.365
25/04/2016 09:00 1.073.741.824 5214493.366
25/04/2016 09:00 1.073.741.824 5214493.367
25/04/2016 09:00 1.073.741.824 5214493.368
25/04/2016 09:00 1.073.741.824 5214493.369
25/04/2016 09:00 1.073.741.824 5214493.37
25/04/2016 09:00 1.073.741.824 5214493.370
25/04/2016 09:00 1.073.741.824 5214493.371
25/04/2016 09:00 1.073.741.824 5214493.372
25/04/2016 09:00 1.073.741.824 5214493.373
25/04/2016 09:00 1.073.741.824 5214493.374
25/04/2016 09:00 1.073.741.824 5214493.375
25/04/2016 09:00 1.073.741.824 5214493.376
25/04/2016 09:00 1.073.741.824 5214493.377
25/04/2016 09:00 1.073.741.824 5214493.378
25/04/2016 09:00 1.073.741.824 5214493.379
25/04/2016 09:00 1.073.741.824 5214493.38
25/04/2016 09:00 1.073.741.824 5214493.380
25/04/2016 09:00 1.073.741.824 5214493.381
25/04/2016 09:00 1.073.741.824 5214493.382
25/04/2016 09:00 1.073.741.824 5214493.383
25/04/2016 09:00 1.073.741.824 5214493.384
25/04/2016 09:00 1.073.741.824 5214493.385
25/04/2016 09:00 1.073.741.824 5214493.386
25/04/2016 09:00 1.073.741.824 5214493.387
25/04/2016 09:00 1.073.741.824 5214493.388
25/04/2016 09:00 1.073.741.824 5214493.389
25/04/2016 09:00 1.073.741.824 5214493.39
25/04/2016 09:00 1.073.741.824 5214493.390
25/04/2016 09:00 1.073.741.824 5214493.391
25/04/2016 09:00 1.073.741.824 5214493.392
25/04/2016 09:00 1.073.741.824 5214493.393
25/04/2016 09:00 1.073.741.824 5214493.394
25/04/2016 09:00 1.073.741.824 5214493.395
25/04/2016 09:00 1.073.741.824 5214493.396
25/04/2016 09:00 1.073.741.824 5214493.397
25/04/2016 09:00 1.073.741.824 5214493.398
25/04/2016 09:00 1.073.741.824 5214493.399
25/04/2016 09:00 1.073.741.824 5214493.4
25/04/2016 09:00 1.073.741.824 5214493.40
25/04/2016 09:00 1.073.741.824 5214493.400
25/04/2016 09:00 1.073.741.824 5214493.401
25/04/2016 09:00 1.073.741.824 5214493.402
25/04/2016 09:00 1.073.741.824 5214493.403
25/04/2016 09:00 1.073.741.824 5214493.404
25/04/2016 09:00 1.073.741.824 5214493.405
25/04/2016 09:00 1.073.741.824 5214493.406
25/04/2016 09:00 1.073.741.824 5214493.407
25/04/2016 09:00 1.073.741.824 5214493.408
19/05/2016 23:21 851.738.624 5214493.409
25/04/2016 09:00 1.073.741.824 5214493.41
25/04/2016 09:00 1.073.741.824 5214493.42
25/04/2016 09:00 1.073.741.824 5214493.43
25/04/2016 09:00 1.073.741.824 5214493.44
25/04/2016 09:00 1.073.741.824 5214493.45
25/04/2016 09:00 1.073.741.824 5214493.46
25/04/2016 09:00 1.073.741.824 5214493.47
25/04/2016 09:00 1.073.741.824 5214493.48
25/04/2016 09:00 1.073.741.824 5214493.49
25/04/2016 09:00 1.073.741.824 5214493.5
25/04/2016 09:00 1.073.741.824 5214493.50
25/04/2016 09:00 1.073.741.824 5214493.51
25/04/2016 09:00 1.073.741.824 5214493.52
25/04/2016 09:00 1.073.741.824 5214493.53
25/04/2016 09:00 1.073.741.824 5214493.54
25/04/2016 09:00 1.073.741.824 5214493.55
25/04/2016 09:00 1.073.741.824 5214493.56
25/04/2016 09:00 1.073.741.824 5214493.57
25/04/2016 09:00 1.073.741.824 5214493.58
25/04/2016 09:00 1.073.741.824 5214493.59
25/04/2016 09:00 1.073.741.824 5214493.6
25/04/2016 09:00 1.073.741.824 5214493.60
25/04/2016 09:00 1.073.741.824 5214493.61
25/04/2016 09:00 1.073.741.824 5214493.62
25/04/2016 09:00 1.073.741.824 5214493.63
25/04/2016 09:00 1.073.741.824 5214493.64
25/04/2016 09:00 1.073.741.824 5214493.65
25/04/2016 09:00 1.073.741.824 5214493.66
25/04/2016 09:00 1.073.741.824 5214493.67
25/04/2016 09:00 1.073.741.824 5214493.68
25/04/2016 09:00 1.073.741.824 5214493.69
25/04/2016 09:00 1.073.741.824 5214493.7
25/04/2016 09:00 1.073.741.824 5214493.70
25/04/2016 09:00 1.073.741.824 5214493.71
25/04/2016 09:00 1.073.741.824 5214493.72
25/04/2016 09:00 1.073.741.824 5214493.73
25/04/2016 09:00 1.073.741.824 5214493.74
25/04/2016 09:00 1.073.741.824 5214493.75
25/04/2016 09:00 1.073.741.824 5214493.76
25/04/2016 09:00 1.073.741.824 5214493.77
25/04/2016 09:00 1.073.741.824 5214493.78
25/04/2016 09:00 1.073.741.824 5214493.79
25/04/2016 09:00 1.073.741.824 5214493.8
25/04/2016 09:00 1.073.741.824 5214493.80
25/04/2016 09:00 1.073.741.824 5214493.81
25/04/2016 09:00 1.073.741.824 5214493.82
25/04/2016 09:00 1.073.741.824 5214493.83
25/04/2016 09:00 1.073.741.824 5214493.84
25/04/2016 09:00 1.073.741.824 5214493.85
25/04/2016 09:00 1.073.741.824 5214493.86
25/04/2016 09:00 1.073.741.824 5214493.87
25/04/2016 09:00 1.073.741.824 5214493.88
25/04/2016 09:00 1.073.741.824 5214493.89
25/04/2016 09:00 1.073.741.824 5214493.9
25/04/2016 09:00 1.073.741.824 5214493.90
25/04/2016 09:00 1.073.741.824 5214493.91
25/04/2016 09:00 1.073.741.824 5214493.92
25/04/2016 09:00 1.073.741.824 5214493.93
25/04/2016 09:00 1.073.741.824 5214493.94
25/04/2016 09:00 1.073.741.824 5214493.95
25/04/2016 09:00 1.073.741.824 5214493.96
25/04/2016 09:00 1.073.741.824 5214493.97
25/04/2016 09:00 1.073.741.824 5214493.98
25/04/2016 09:00 1.073.741.824 5214493.99
20/05/2016 09:15 108.183.552 5214493_fsm
25/04/2016 09:00 1.073.741.824 5214495
25/04/2016 09:00 1.073.741.824 5214495.1
25/04/2016 09:00 1.073.741.824 5214495.2
25/04/2016 09:00 1.073.741.824 5214495.3
20/05/2016 09:15 535.183.360 5214495.4
422 File(s) 445.600.333.824 bytes
2 Dir(s) 198.487.891.968 bytes free
com >>:<mailto:adrian.klaver@aklaver.
On 06/06/2017 11:09 AM, tel medola wrote:
I will not be able to recover my information any more, right?
That is what I am trying to figure out.
The last error you got was:
"
Returns the error below:
Missing chunk number 0 for toast value 10259186 in pg_toast_9277966
"
This is related to the TOAST table that should be associated with
your primary table:
https://www.postgresql.org/docs/9.6/static/storage-toast.htm l
<https://www.postgresql.org/docs/9.6/static/storage-toast.ht >ml
When you did:
select * from pg_class where relfilenode = 5214489
where 5214489 is the relfilenode for the table repositorio you got
among other things:
reltoastrelid
5214493
https://www.postgresql.org/docs/9.6/static/catalog-pg-class. html
<https://www.postgresql.org/docs/9.6/static/catalog-pg-class >.html
where 5214493 is the OID for the TOAST table that is supposed to be
associated with the repositorio table. That is why I wanted to see:
select oid, * from pg_class where oid = 5214493
to find out what relfilenode is for the TOAST table and then have
you look for it or maybe change it.
2017-06-06 10:37 GMT-03:00 Adrian Klaver
<adrian.klaver@xxxxxxxxxxx <mailto:adrian.klaver@aklaver.com >com <mailto:adrian.klaver@aklaver.
<mailto:adrian.klaver@aklaver.com >>>:
On 06/06/2017 04:40 AM, tel medola wrote:
Lets go:
In my plsql:
rai=# select oid, * from pg_class where relfilenode =
5214489;
I was looking for:
select oid, * from pg_class where oid = 5214493;
Result:
oid | relname | relnamespace | reltype |
reloftype |
relowner | relam | relfilenode | reltablespace |
relpages | reltuples | relallvisible | reltoastrelid |
reltoastidxid |
relhasindex | relisshared | relpersistence | relkind |
relnatts
| relchecks | relhasoids | relhaspkey | relhasrules |
relhastriggers | relhassubclass | relispopulated |
relfrozenxid
| relminmxid | relacl | reloptions
---------+-------------+--------------+---------+----------- +----------+-------+---------- ---+---------------+---------- +--------------+-------------- -+---------------+------------ ---+-------------+------------ -+----------------+---------+- ---------+-----------+-------- ----+------------+------------ -+----------------+----------- -----+----------------+------- -------+------------+--------+ ------------
5214489 | repositorio | 5205962 | 5214491 | 0 | 10 | 0 | 5214489 | 5205910
| 79303 |
1.31566e+006 | 79303 | 5214493 | 0 |
t | f | p | r | 7
| 0 | f | t | f |
f | f | t | 9360288 | 1 | |
(1 registro)
Ok?
-- Adrian Klaver
adrian.klaver@xxxxxxxxxxx <mailto:adrian.klaver@aklaver.com >com
<mailto:adrian.klaver@aklaver.com >>
-- Adrian Klaver
adrian.klaver@xxxxxxxxxxx <mailto:adrian.klaver@aklaver.com >
--
Adrian Klaver
adrian.klaver@xxxxxxxxxxx
