Multiple table entries?

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

Responses

Browse pgsql-general by date

  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?