Thread: 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@momjian.us> http://momjian.us EnterpriseDB http://enterprisedb.com + If your life is a hard drive, Christ can be your backup. +
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°