Re: Easy way of pruning pg_data?

From: "lee(at)avbrief" <lee(at)avbrief(dot)com>
To: "David Link" <dlink(at)soundscan(dot)com>
Cc: <pgsql-general(at)postgresql(dot)org>
Subject: Re: Easy way of pruning pg_data?
Date: 2001-10-15 19:31:55
Message-ID: 039c01c155b0$0cdab770$4d19fe3e@lcdell
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

No they are not.
I wondered if they were temporary space or something other.
I might take a punt at moving them, but then again :-(!
Thanks
Lee

----- Original Message -----
From: "David Link" <dlink(at)soundscan(dot)com>
To: "Lee Crampton" <lee(at)avbrief(dot)com>
Cc: <pgsql-general(at)postgresql(dot)org>
Sent: Monday, October 15, 2001 7:48 PM
Subject: Re: [GENERAL] Easy way of pruning pg_data?

> What are those files? my $PGDATA/base only contains subdirectores, one
> for each database name. Are those your database names?
>
> Lee Crampton wrote:
> >
> > Hi All
> > given the folowing:
> >
> > ls -l pg_data/base
> > drwx--S--- 2 postgres postgres 2048 Apr 15 2001 1
> > drwx--S--- 2 postgres postgres 2048 Aug 27 12:26 1007014
> > drwx--S--- 2 postgres postgres 2048 Sep 15 08:57 1045851
> > drwx--S--- 2 postgres postgres 2048 Apr 15 2001 18719
> > drwx--S--- 2 postgres postgres 2048 Apr 15 2001 18735
> > drwx--S--- 2 postgres postgres 2048 Apr 15 2001 18891
> > drwx--S--- 2 postgres postgres 2048 Apr 15 2001 18916
> > drwx--S--- 2 postgres postgres 4096 Oct 12 20:09 19100
> > drwx--S--- 2 postgres postgres 2048 Apr 15 2001 192660
> > drwx--S--- 2 postgres postgres 2048 Apr 15 2001 206353
> > drwx--S--- 2 postgres postgres 2048 Apr 15 2001 206889
> > drwx--S--- 2 postgres postgres 2048 Apr 15 2001 207360
> > drwx--S--- 2 postgres postgres 2048 Jun 5 10:44 639889
> > drwx--S--- 2 postgres postgres 2048 Jun 5 11:19 643727
> > drwx--S--- 2 postgres postgres 2048 Aug 1 12:28 953493
> >
> > Is there an easy way to housekeep (prune) these directories?
> > Thanks in advance
> > Lee
> >
> > ---------------------------(end of broadcast)---------------------------
> > TIP 5: Have you checked our extensive FAQ?
> >
> > http://www.postgresql.org/users-lounge/docs/faq.html

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Christopher Masto 2001-10-15 20:33:31 Re: Practical Cursors
Previous Message Peter Eisentraut 2001-10-15 19:31:14 Re: Postmaster re-start problem