Re: PostgreSQL 8.1.3/Windows - Mailing list pgsql-admin

From Benjamin Krajmalnik
Subject Re: PostgreSQL 8.1.3/Windows
Date
Msg-id 8511B4970E0D124898E973DF496F9B4325162C@stash.stackdump.local
Whole thread Raw
In response to PostgreSQL 8.1.3/Windows  ("Benjamin Krajmalnik" <kraj@illumen.com>)
List pgsql-admin

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

pgsql-admin by date:

Previous
From: "Larry Rosenman"
Date:
Subject: Re: PostgreSQL 8.1.3/Windows
Next
From: Tom Lane
Date:
Subject: Re: PostgreSQL 8.1.3/Windows