Обсуждение: PostgreSQL 8.1.3/Windows

Поиск
Список
Период
Сортировка

PostgreSQL 8.1.3/Windows

От
"Benjamin Krajmalnik"
Дата:

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

От
"Larry Rosenman"
Дата:
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

От
"Benjamin Krajmalnik"
Дата:

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

От
Tom Lane
Дата:
"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