Postgres Pro
Downloads
Home   >   mailing lists

What does a .1 suffix on a PG data file signify? - Mailing list pgsql-admin

From David Schnur
Subject What does a .1 suffix on a PG data file signify?
Date
Msg-id CAANiQEng+iQCkFQ7mwzyu-sS0MKekA__Hn=aVmJMgnTwfvTb+w@mail.gmail.com
Whole thread Raw
Responses Re: What does a .1 suffix on a PG data file signify?
List pgsql-admin
Tree view
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

pgsql-admin by date:

Previous
From: Daryl Stultz
Date:
Subject: Re: dangling connections
Next
From: "ktm@rice.edu"
Date:
Subject: Re: What does a .1 suffix on a PG data file signify?