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

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