pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
PostgreSQL 8.1.3/Windows
4+ messages / 3 participants
[nested] [flat]

* PostgreSQL 8.1.3/Windows
@ 2006-05-08 20:42 Benjamin Krajmalnik <kraj@illumen.com>
  2006-05-08 20:54 ` Re: PostgreSQL 8.1.3/Windows Tom Lane <tgl@sss.pgh.pa.us>
  0 siblings, 1 reply; 4+ messages in thread

From: Benjamin Krajmalnik @ 2006-05-08 20:42 UTC (permalink / raw)
  To: pgsql-admin

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

^ permalink  raw  reply  [nested|flat] 4+ messages in thread

* Re: PostgreSQL 8.1.3/Windows
  2006-05-08 20:42 PostgreSQL 8.1.3/Windows Benjamin Krajmalnik <kraj@illumen.com>
@ 2006-05-08 20:54 ` Tom Lane <tgl@sss.pgh.pa.us>
  0 siblings, 0 replies; 4+ messages in thread

From: Tom Lane @ 2006-05-08 20:54 UTC (permalink / raw)
  To: Benjamin Krajmalnik <kraj@illumen.com>; +Cc: pgsql-admin

"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



^ permalink  raw  reply  [nested|flat] 4+ messages in thread

* Re: PostgreSQL 8.1.3/Windows
@ 2006-05-08 20:44 Larry Rosenman <lrosenman@pervasive.com>
  0 siblings, 0 replies; 4+ messages in thread

From: Larry Rosenman @ 2006-05-08 20:44 UTC (permalink / raw)
  To: Benjamin Krajmalnik <kraj@illumen.com>; pgsql-admin

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

^ permalink  raw  reply  [nested|flat] 4+ messages in thread

* Re: PostgreSQL 8.1.3/Windows
@ 2006-05-08 20:46 Benjamin Krajmalnik <kraj@illumen.com>
  0 siblings, 0 replies; 4+ messages in thread

From: Benjamin Krajmalnik @ 2006-05-08 20:46 UTC (permalink / raw)
  To: Larry Rosenman <lrosenman@pervasive.com>; pgsql-admin

Thanks.

That definitely would not have been pretty :-)

 

________________________________

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

^ permalink  raw  reply  [nested|flat] 4+ messages in thread


end of thread, other threads:[~2006-05-08 20:54 UTC | newest]

Thread overview: 4+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2006-05-08 20:42 PostgreSQL 8.1.3/Windows Benjamin Krajmalnik <kraj@illumen.com>
2006-05-08 20:54 ` Tom Lane <tgl@sss.pgh.pa.us>
2006-05-08 20:44 Re: PostgreSQL 8.1.3/Windows Larry Rosenman <lrosenman@pervasive.com>
2006-05-08 20:46 Re: PostgreSQL 8.1.3/Windows Benjamin Krajmalnik <kraj@illumen.com>

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox