Postgres Pro
Downloads
Home   >   mailing lists

Re: vacuum analyze - cannot insert duplicate key... (2) - Mailing list pgsql-novice

From Tom Lane
Subject Re: vacuum analyze - cannot insert duplicate key... (2)
Date
Msg-id 23234.1001945484@sss.pgh.pa.us
Whole thread Raw
In response to vacuum analyze - cannot insert duplicate key... (2)  (Patrick Coulombe <pcoulombe@mediacces.com>)
List pgsql-novice
Tree view 
Patrick Coulombe <pcoulombe@mediacces.com> writes:
> in my data/base/medias/
> medias_categories_media_id_key.999
> i found this file over 700 copy. can i erase them and what the purpose of
> this file ?

If they're zero-length, you can remove them.  You definitely need to
update, though; appearance of such files is a symptom of some old bugs.

            regards, tom lane

pgsql-novice by date:

Previous
From: Patrick Coulombe
Date:
Subject: vacuum analyze - cannot insert duplicate key... (2)
Next
From: Jimmy McDonald
Date:
Subject: access to postgres?