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