Re: Easy way of pruning pg_data?

"lee@avbrief" wrote:
  >No they are not.
  >I wondered if they were temporary space or something other.

No.  They are your databases.  Database directory names are now based on the
oid of the database in pg_database.

  >I might take a punt at moving them, but then again :-(!

Don't!

  >
  >----- 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?

Vacuum your databases.

--
Oliver Elphick                                Oliver.Elphick@lfix.co.uk
Isle of Wight                              http://www.lfix.co.uk/oliver
GPG: 1024D/3E1D0C1C: CA12 09E0 E8D5 8870 5839  932A 614D 4C34 3E1D 0C1C

     "Trust in the LORD, and do good..."        Psalms 37:3