Re: Postgres physical directory structure meaning - Mailing list pgsql-general

From Andreas Kretschmer
Subject Re: Postgres physical directory structure meaning
Date
Msg-id 20100216192120.GA11800@tux
Whole thread Raw
In response to Re: Postgres physical directory structure meaning  (Bruce Momjian <bruce@momjian.us>)
List pgsql-general
Bruce Momjian <bruce@momjian.us> wrote:

> A. Kretschmer wrote:
> > In response to S Arvind :
> > > I want to know about the meaning of various directory present in data folder.
> > > Mostly what will the 'base' folder contains? The reason of this is recently in
> > > the datafolder 'global' was deleted unknowingly which leads to entire DB crash
> > > in a second. We found a tool to get the data from the base folder as sql
> > > queries, but many table content are missing.?
> > > Pls tell what kind of data will be present in each folder, if possible sent the
> > > doc link.
> >
> > http://www.postgresql.org/docs/8.4/interactive/storage.html
> >
> > Read there and the sub-chapters.
>
> Yea, "base" was chosen because that makes the directory hierarchy
> "/data/base", e.g. "database".

;-)


Andreas
--
Really, I'm not out to destroy Microsoft. That will just be a completely
unintentional side effect.                              (Linus Torvalds)
"If I was god, I would recompile penguin with --enable-fly."   (unknown)
Kaufbach, Saxony, Germany, Europe.              N 51.05082°, E 13.56889°

pgsql-general by date:

Previous
From: Bruce Momjian
Date:
Subject: Re: Postgres physical directory structure meaning
Next
From: Peter Geoghegan
Date:
Subject: Re: Having a plpgsql function return multiple rows that indicate its progress in a cursor like fashion