Re: [GENERAL] Redo the filenode link in tablespace - Mailing list pgsql-general

On 06/05/2017 04:07 PM, tel medola wrote:
> Hi,
> attachment.
>
> select:
> select * from pg_class where relfilenode = 5214489

Next, what do you get from:

In psql
=> \x
Expanded display is on.

select oid, * from pg_class where oid = 5214493;

No need to create an attachment, just cut and paste into message.


>
> Thanks
>
> 2017-06-05 16:02 GMT-03:00 Adrian Klaver <adrian.klaver@aklaver.com
> <mailto:adrian.klaver@aklaver.com>>:
>
>     On 06/05/2017 11:55 AM, tel medola wrote:
>
>         show?
>         /Yes/
>
>
>     Yes, what?
>
>     Please run the command as shown:
>
>     select * from pg_class where relfilenode = 5214489;
>
>     and show the result.
>
>
>         Do not delete the pg_statistic table. I would not even delete
>         from it.
>         /Sorry, I already deleted it. I looked for something official
>         and found in the site in postgres the reference that the delete
>         could be done
>         (https://www.postgresql.org/docs/9.1/static/release-7-4-2.html
>         <https://www.postgresql.org/docs/9.1/static/release-7-4-2.html>)
>         and I ended up doing it. Now I'm running a vacuum analyze across
>         the base./
>
>
>         2017-06-05 15:41 GMT-03:00 Adrian Klaver
>         <adrian.klaver@aklaver.com <mailto:adrian.klaver@aklaver.com>
>         <mailto:adrian.klaver@aklaver.com
>         <mailto:adrian.klaver@aklaver.com>>>:
>
>
>              On 06/05/2017 07:17 AM, tel medola wrote:
>
>                  Done.
>                  I followed the steps below after reconnecting the filenode:
>
>                  Select * from "05122016".repositorio
>                  Count -> 0
>
>                  Then, I execute the commands:
>                  Analyze "05122016".repositorio;
>                  Count -> 0
>                  Reindex "05122016".repositorio;
>                  Count -> 1509046
>                  Yes!
>
>                  But...
>
>
>                  select * from "05122016".repository where id_documento =
>                  '{A647885D-9738-4617-ACE6-6351F6ADD341}'
>
>                  Returns the error below:
>                  Missing chunk number 0 for toast value 10259186 in
>         pg_toast_9277966
>
>
>              What does:
>
>              select * from pg_class where relfilenode = 5214489;
>
>              show?
>
>
>
>                  I read in the forum to run the command:
>                  Delete from pg_statistic;
>                  Reindex table pg_statistic;
>                  Vacuum analyze;
>
>                  Is it okay to delete the pg_statistic table?
>
>
>              Do not delete the pg_statistic table. I would not even
>         delete from it.
>
>              --     Adrian Klaver
>         adrian.klaver@aklaver.com <mailto:adrian.klaver@aklaver.com>
>         <mailto:adrian.klaver@aklaver.com
>         <mailto:adrian.klaver@aklaver.com>>
>
>
>
>
>     --
>     Adrian Klaver
>     adrian.klaver@aklaver.com <mailto:adrian.klaver@aklaver.com>
>
>


--
Adrian Klaver
adrian.klaver@aklaver.com