From: | Jeff Ross <jross(at)wykids(dot)org> |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Subject: | Multiple table entries? |
Date: | 2009-08-22 20:31:16 |
Message-ID: | 4A905594.2060704@wykids.org |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | 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(at)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
From | Date | Subject | |
---|---|---|---|
Next Message | Ray Stell | 2009-08-22 21:24:53 | Re: How to simulate crashes of PostgreSQL? |
Previous Message | Sergey Samokhin | 2009-08-22 20:03:43 | How to simulate crashes of PostgreSQL? |