Duplicate public schema and user tables
От | Romain Roure |
---|---|
Тема | Duplicate public schema and user tables |
Дата | |
Msg-id | 46FA1D9F.5050604@persee.fr обсуждение исходный текст |
Ответы |
Re: Duplicate public schema and user tables
(Martijn van Oosterhout <kleptog@svana.org>)
|
Список | pgsql-general |
Hi, We suddenly stumbled upon duplicate entities. Some of our databases ended up with two 'public' schemas and several duplicate user tables (sharing the same oid). After checking through the logs, it doesn't appear to be a problem resulting from wrap-around OID's. Though the logs mention transaction-wraparound may have happened. For the moment, we are trying to get ride of the duplicates and can't manage to pull that off. We tried restarting the server in singe-user mode with -P option to reindex the database, but it failed complaining about the uniqueness of the index in 'pg_class'. We're running PostgreSQL 8.0.1. Any help would be appreciated. Regards, Romain The two public schemas : bddreco=# SELECT *,oid from pg_namespace ; nspname | nspowner | nspacl | oid --------------------+----------+-------------------------------------+---------- pg_toast | 1 | | 99 pg_temp_1 | 1 | | 16847 pg_catalog | 1 | {postgres=UC/postgres,=U/postgres} | 11 public | 1 | {postgres=UC/postgres,=UC/postgres} | 2200 information_schema | 1 | {postgres=UC/postgres,=U/postgres} | 17057 public | 1 | {postgres=UC/postgres,=UC/postgres} | 73794132 (6 rows) Duplicate user table : bddreco=# SELECT *,oid from pg_class where relname='series'; relname | relnamespace | reltype | relowner | relam | relfilenode | reltablespace | relpages | reltuples | reltoastrelid | reltoastidxid | relhasindex | relisshared | relkind | relnatts | relchecks | reltriggers | relukeys | relfkeys | relrefs | relhasoids | relhaspkey | relhasrules | relhassubclass | relacl | oid series | 73794132 | 73794327 | 102 | 0 | 73794326 | 0 | 0 | 0 | 0 | 0 | t | f | r | 4 | 0 | 5 | 0 | 0 | 0 | t | t | f | f | {granitadmin=arwdRxt/granitadmin,granitguest=r/granitadmin,granitserie=arwd/granitadmin} | 73794326 series | 73794132 | 73794327 | 102 | 0 | 73794326 | 0 | 0 | 0 | 0 | 0 | t | f | r | 4 | 0 | 5 | 0 | 0 | 0 | t | t | f | f | {granitadmin=arwdRxt/granitadmin,granitguest=r/granitadmin,granitserie=arwd/granitadmin} | 73794326 series | 73794132 | 73794327 | 102 | 0 | 73794326 | 0 | 0 | 0 | 0 | 0 | t | f | r | 4 | 0 | 5 | 0 | 0 | 0 | t | t | f | f | {granitadmin=arwdRxt/granitadmin,granitguest=r/granitadmin,granitserie=arwd/granitadmin} | 73794326 series | 73794132 | 73794327 | 102 | 0 | 73794326 | 0 | 1 | 1 | 0 | 0 | t | f | r | 4 | 0 | 5 | 0 | 0 | 0 | t | t | f | f | {granitadmin=arwdRxt/granitadmin,granitguest=r/granitadmin,granitserie=arwd/granitadmin} | 73794326 (4 rows)
В списке pgsql-general по дате отправления: