Search Postgresql Archives

Re: Redo the filenode link in tablespace

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



Lets go:
In my plsql:
rai=# select oid, * from pg_class where relfilenode = 5214489;

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?

2017-06-05 20:13 GMT-03:00 Adrian Klaver <adrian.klaver@xxxxxxxxxxx>:
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@xxxxxxxxxxx <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@xxxxxxxxxxx <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@xxxxxxxxxxx <mailto:adrian.klaver@aklaver.com>
        <mailto:adrian.klaver@aklaver.com
        <mailto:adrian.klaver@aklaver.com>>




    --     Adrian Klaver
    adrian.klaver@xxxxxxxxxxx <mailto:adrian.klaver@aklaver.com>




--
Adrian Klaver
adrian.klaver@xxxxxxxxxxx


[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]

  Powered by Linux