Postgres Pro
Downloads
Home   >   mailing lists

Thread: PostgreSQL 8.1.3/Windows

PostgreSQL 8.1.3/Windows

From
"Benjamin Krajmalnik"
Date:

I was looking at the files inside my database and came across files which have the same OID number as the filename but some had extensions (in my case .1 and .2).

What are these files?  Can they be safely deleted?

 

In my case, they are quite large (over 1GB each).

 

Regards,

 

Benjamin

Re: PostgreSQL 8.1.3/Windows

From
"Larry Rosenman"
Date:
They are the 1GB segments of your tables.  You should NOT delete them.
 
LER

--
Larry Rosenman         
Database Support Engineer

PERVASIVE SOFTWARE. INC.
12365B RIATA TRACE PKWY
3015
AUSTIN TX  78727-6531

Tel: 512.231.6173
Fax: 512.231.6597
Email: Larry.Rosenman@pervasive.com
Web: www.pervasive.com


From: pgsql-admin-owner@postgresql.org [mailto:pgsql-admin-owner@postgresql.org] On Behalf Of Benjamin Krajmalnik
Sent: Monday, May 08, 2006 3:42 PM
To: pgsql-admin@postgresql.org
Subject: [ADMIN] PostgreSQL 8.1.3/Windows

I was looking at the files inside my database and came across files which have the same OID number as the filename but some had extensions (in my case .1 and .2).

What are these files?  Can they be safely deleted?

 

In my case, they are quite large (over 1GB each).

 

Regards,

 

Benjamin

Re: PostgreSQL 8.1.3/Windows

From
"Benjamin Krajmalnik"
Date:

Thanks.

That definitely would not have been pretty J

 

From: Larry Rosenman [mailto:lrosenman@pervasive.com]
Sent: Monday, May 08, 2006 2:45 PM
To: Benjamin Krajmalnik; pgsql-admin@postgresql.org
Subject: RE: [ADMIN] PostgreSQL 8.1.3/Windows

 

They are the 1GB segments of your tables.  You should NOT delete them.

 

LER

--
Larry Rosenman         
Database Support Engineer

PERVASIVE SOFTWARE. INC.
12365B RIATA TRACE PKWY
3015
AUSTIN TX  78727-6531

Tel: 512.231.6173
Fax: 512.231.6597
Email: Larry.Rosenman@pervasive.com
Web: www.pervasive.com

 

From: pgsql-admin-owner@postgresql.org [mailto:pgsql-admin-owner@postgresql.org] On Behalf Of Benjamin Krajmalnik
Sent: Monday, May 08, 2006 3:42 PM
To: pgsql-admin@postgresql.org
Subject: [ADMIN] PostgreSQL 8.1.3/Windows

I was looking at the files inside my database and came across files which have the same OID number as the filename but some had extensions (in my case .1 and .2).

What are these files?  Can they be safely deleted?

 

In my case, they are quite large (over 1GB each).

 

Regards,

 

Benjamin

Re: PostgreSQL 8.1.3/Windows

From
Tom Lane
Date:
"Benjamin Krajmalnik" <kraj@illumen.com> writes:
> I was looking at the files inside my database and came across files
> which have the same OID number as the filename but some had extensions
> (in my case .1 and .2).

You might care to read
    http://www.postgresql.org/docs/8.1/static/storage.html
which explains all this.

            regards, tom lane