Re: Where is the saved database? - Mailing list pgsql-novice

From Andrew McMillan
Subject Re: Where is the saved database?
Date
Msg-id 1036749755.2194.121.camel@kant.mcmillan.net.nz
Whole thread Raw
In response to Where is the saved database?  (Setyo Nugroho <snugroho@gmx.net>)
List pgsql-novice
On Fri, 2002-11-08 at 22:07, Setyo Nugroho wrote:
> Hi all,
> I am puzzeld how the file system works. Where are databases, tables,
> functions etc, created using psql, stored? In which format/ extension?

Depends on your setup.  On Debian GNU/Linux it is under
/var/lib/postgres/data/base... for example.


> Can we view these files with a normal editor such as Kate?

No more than you can examine any other binary file with a normal editor
such as Kate - i.e. not _usefully_.

The manual describes the file format, and should be your first port of
call if you really want to understand it.

Cheers,
                    Andrew
--
---------------------------------------------------------------------
Andrew @ Catalyst .Net.NZ Ltd, PO Box 11-053, Manners St,  Wellington
WEB: http://catalyst.net.nz/         PHYS: Level 2, 150-154 Willis St
DDI: +64(4)916-7201     MOB: +64(21)635-694    OFFICE: +64(4)499-2267
           Survey for nothing with http://survey.net.nz/
---------------------------------------------------------------------


pgsql-novice by date:

Previous
From: "Erwan DUROSELLE"
Date:
Subject: Rép. : Performance
Next
From: Andrew McMillan
Date:
Subject: Re: Performance