What does a .1 suffix on a PG data file signify?

From: David Schnur <dnschnur(at)gmail(dot)com>
To: pgsql-admin(at)postgresql(dot)org
Subject: What does a .1 suffix on a PG data file signify?
Date: 2012-05-16 18:52:44
Message-ID: CAANiQEng+iQCkFQ7mwzyu-sS0MKekA__Hn=aVmJMgnTwfvTb+w@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

I'm investigating a 'could not stat file' error that points to a file
"base/16384/52212305.1". All the data files I've ever seen have names that
are whole numbers; I've never seen a decimal suffix. It occurs to me that
perhaps this is some kind of temp-file, or a system for avoiding duplicate
file names, both of which might be relevant in the context of this error.

Can anyone confirm what the presence of the .1 suffix means?

I'm using Postgres 8.3.15 on Windows.

Thanks,

David

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message ktm@rice.edu 2012-05-16 18:56:52 Re: What does a .1 suffix on a PG data file signify?
Previous Message Daryl Stultz 2012-05-16 11:38:07 Re: dangling connections