Re: file under data - Mailing list pgsql-admin

From Leong, Fushan
Subject Re: file under data
Date
Msg-id 2DFBC8374F5A0F4E954C07C158844F32085206@milton.sonosite.com
Whole thread Raw
In response to file under data  ("Leong, Fushan" <fushan.leong@SonoSite.com>)
Responses Re: file under data  (Stephan Szabo <sszabo@megazone23.bigpanda.com>)
List pgsql-admin
delete them is bad.. but you can not let them grow forever........

When and how to clean up these files?

thanks
Fushan

-----Original Message-----
From: Stephan Szabo [mailto:sszabo@megazone23.bigpanda.com]
Sent: Tuesday, October 30, 2001 4:56 PM
To: Leong, Fushan
Cc: pgsql-admin@postgresql.org
Subject: Re: [ADMIN] file under data


On Tue, 30 Oct 2001, Leong, Fushan wrote:

> Hi :
>
>    Very new in postgres.  I created a database and did some transactions.
I
> found three subdirectories are created under $HOME/data/base.  They are
1,
> 18719, 18720.  Under these "funny" name directory, there are a lot of
files
> with number as their filename.
>
> What are they?  Can I delete them when my disk space is very tide?

They're the databases and tables and such.  Deleting them would be bad.
If you want to see the number/name mappings check out contrib/oid2name


pgsql-admin by date:

Previous
From: "Leong, Fushan"
Date:
Subject: Re: backup file system
Next
From: Stephan Szabo
Date:
Subject: Re: file under data