X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (mx1.hub.org [200.46.208.251]) by postgresql.org (Postfix) with ESMTP id E41149FA42B for ; Mon, 8 May 2006 17:47:02 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.208.251]) (amavisd-new, port 10024) with ESMTP id 93308-03-2 for ; Mon, 8 May 2006 17:46:54 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey- Received: from stash.illumen.com (unknown [64.207.29.137]) by postgresql.org (Postfix) with ESMTP id 54CD89FA489 for ; Mon, 8 May 2006 17:46:41 -0300 (ADT) Content-class: urn:content-classes:message MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----_=_NextPart_001_01C672E0.815DF2F7" Subject: Re: PostgreSQL 8.1.3/Windows X-MimeOLE: Produced By Microsoft Exchange V6.5 Date: Mon, 8 May 2006 14:46:39 -0600 Message-ID: <8511B4970E0D124898E973DF496F9B4325162C@stash.stackdump.local> X-MS-Has-Attach: X-MS-TNEF-Correlator: Thread-Topic: [ADMIN] PostgreSQL 8.1.3/Windows Thread-Index: AcZy3+adVU+CAAtoR1KtDKb7ZjWj0QAADwNgAAATaEA= From: "Benjamin Krajmalnik" To: "Larry Rosenman" , X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200605/72 X-Sequence-Number: 21604 This is a multi-part message in MIME format. ------_=_NextPart_001_01C672E0.815DF2F7 Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: quoted-printable Thanks. That definitely would not have been pretty :-) =20 ________________________________ From: Larry Rosenman [mailto:lrosenman@pervasive.com]=20 Sent: Monday, May 08, 2006 2:45 PM To: Benjamin Krajmalnik; pgsql-admin@postgresql.org Subject: RE: [ADMIN] PostgreSQL 8.1.3/Windows =20 They are the 1GB segments of your tables. You should NOT delete them. =20 LER -- Larry Rosenman =20 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=20 =20 ________________________________ 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? =20 In my case, they are quite large (over 1GB each). =20 Regards, =20 Benjamin ------_=_NextPart_001_01C672E0.815DF2F7 Content-Type: text/html; charset="us-ascii" Content-Transfer-Encoding: quoted-printable

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

------_=_NextPart_001_01C672E0.815DF2F7--