Re: Easy way of pruning pg_data?

Поиск
Список
Период
Сортировка
От lee@avbrief
Тема Re: Easy way of pruning pg_data?
Дата
Msg-id 039c01c155b0$0cdab770$4d19fe3e@lcdell
обсуждение исходный текст
Ответ на Easy way of pruning pg_data?  ("Lee Crampton" <lee@avbrief.com>)
Ответы Re: Easy way of pruning pg_data?  ("Oliver Elphick" <olly@lfix.co.uk>)
Список 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 по дате отправления:

Предыдущее
От: John Burski
Дата:
Сообщение: Re: Postmaster re-start problem
Следующее
От: Doug McNaught
Дата:
Сообщение: Re: WWW interface for postgres