From: | Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)com> |
---|---|
To: | tel medola <tel(dot)medola(at)gmail(dot)com> |
Cc: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: Redo the filenode link in tablespace |
Date: | 2017-06-07 00:08:43 |
Message-ID: | b50b5adf-ae0a-947a-c39b-3422d00e0ea6@aklaver.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
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.
>
> 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
>
>
> 2017-06-06 16:37 GMT-03:00 Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)com
> <mailto:adrian(dot)klaver(at)aklaver(dot)com>>:
>
> 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.html
> <https://www.postgresql.org/docs/9.6/static/storage-toast.html>
>
> 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(dot)klaver(at)aklaver(dot)com <mailto:adrian(dot)klaver(at)aklaver(dot)com>
> <mailto:adrian(dot)klaver(at)aklaver(dot)com
> <mailto:adrian(dot)klaver(at)aklaver(dot)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(dot)klaver(at)aklaver(dot)com <mailto:adrian(dot)klaver(at)aklaver(dot)com>
> <mailto:adrian(dot)klaver(at)aklaver(dot)com
> <mailto:adrian(dot)klaver(at)aklaver(dot)com>>
>
>
>
>
> --
> Adrian Klaver
> adrian(dot)klaver(at)aklaver(dot)com <mailto:adrian(dot)klaver(at)aklaver(dot)com>
>
>
--
Adrian Klaver
adrian(dot)klaver(at)aklaver(dot)com
From | Date | Subject | |
---|---|---|---|
Next Message | Patrick B | 2017-06-07 02:32:16 | Extract from text id other table - PG 9.1 |
Previous Message | tel medola | 2017-06-06 21:07:15 | Re: Redo the filenode link in tablespace |