Re: Easy way of pruning pg_data? - Mailing list pgsql-general

From lee@avbrief
Subject Re: Easy way of pruning pg_data?
Date
Msg-id 039c01c155b0$0cdab770$4d19fe3e@lcdell
Whole thread Raw
In response to Easy way of pruning pg_data?  ("Lee Crampton" <lee@avbrief.com>)
Responses Re: Easy way of pruning pg_data?  ("Oliver Elphick" <olly@lfix.co.uk>)
List 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@soundscan.com>
To: "Lee Crampton" <lee@avbrief.com>
Cc: <pgsql-general@postgresql.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


pgsql-general by date:

Previous
From: John Burski
Date:
Subject: Re: Postmaster re-start problem
Next
From: Doug McNaught
Date:
Subject: Re: WWW interface for postgres