Re: Postgres physical directory structure meaning

Bruce Momjian <bruce(at)momjian(dot)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°