Multiple table entries?
От | Jeff Ross |
---|---|
Тема | Multiple table entries? |
Дата | |
Msg-id | 4A905594.2060704@wykids.org обсуждение исходный текст |
Ответы |
Re: Multiple table entries?
Re: Multiple table entries? |
Список | pgsql-general |
Hi, I recently upgraded to 8.4 and everything went great. All databases are working as they are supposed to, no problems seen. Today, however, I did a \d on a database and was surprised to see sets of 5 identical table entries for each one that is supposed to be there. Here's the databases in question (used to store apache web logs). Several other of my databases (but not all) show the same 5 entries for each real table symptom. _postgresql@heinlein:/backup/postgresql $ psql pglogd psql (8.4.0) Type "help" for help. pglogd=# \d++ List of relations Schema | Name | Type | Owner | Size | Description --------+--------------+-------+-------------+---------+------------- public | full_entries | table | _postgresql | 528 kB | public | full_entries | table | _postgresql | 528 kB | public | full_entries | table | _postgresql | 528 kB | public | full_entries | table | _postgresql | 528 kB | public | full_entries | table | _postgresql | 528 kB | public | full_temp | table | jross | 1904 kB | public | full_temp | table | jross | 1904 kB | public | full_temp | table | jross | 1904 kB | public | full_temp | table | jross | 1904 kB | public | full_temp | table | jross | 1904 kB | public | log_entries | table | _postgresql | 1648 kB | public | log_entries | table | _postgresql | 1648 kB | public | log_entries | table | _postgresql | 1648 kB | public | log_entries | table | _postgresql | 1648 kB | public | log_entries | table | _postgresql | 1648 kB | public | page_hits | table | _postgresql | 5296 kB | public | page_hits | table | _postgresql | 5296 kB | public | page_hits | table | _postgresql | 5296 kB | public | page_hits | table | _postgresql | 5296 kB | public | page_hits | table | _postgresql | 5296 kB | public | total_hits | table | _postgresql | 16 kB | public | total_hits | table | _postgresql | 16 kB | public | total_hits | table | _postgresql | 16 kB | public | total_hits | table | _postgresql | 16 kB | public | total_hits | table | _postgresql | 16 kB | (25 rows) \l correctly lists the individual databases, and when I took a look at yesterday's dump file I only see one create table statement, not 5. I browsed through the system catalogs but haven't found anything yet that can shine some light on this. System is running OpenBSD -current. Thanks, Jeff Ross
В списке pgsql-general по дате отправления: