Re: Postgres physical directory structure meaning

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.

Arvind S

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.

Regards, Andreas
--
Andreas Kretschmer
Kontakt: Heynitz: 035242/47150, D1: 0160/7141639 (mehr: -> Header)
GnuPG: 0x31720C99, 1006 CCB4 A326 1D42 6431 2EB0 389D 1DC2 3172 0C99

S Arvind escribió:
> 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.

"global" contains some system catalogs. Not terribly critical, but you
need to do quite some work in order to make the system work again
without them.

--
Alvaro Herrera http://www.CommandPrompt.com/
PostgreSQL Replication, Consulting, Custom Development, 24x7 support

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".

--
Bruce Momjian <bruce(at)momjian(dot)us> http://momjian.us
EnterpriseDB http://enterprisedb.com

+ If your life is a hard drive, Christ can be your backup. +

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°