From: | Hugh Esco <hesco(at)greens(dot)org> |
---|---|
To: | pgsql-admin(at)postgresql(dot)org |
Subject: | How are postgreSQL database files structured? |
Date: | 2002-11-23 04:12:31 |
Message-ID: | 5.1.0.14.0.20021122225733.02c20230@petra.cagreens.org |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-admin |
Hey folks:
I am mounting the learning curve from MySQL to postgreSQL. It seemed so
straight forward before. On my Win98 box, everything was clearly named as
I had designated in the c:/mysql/data directory. On the Debian server, the
/var/lib/mysql directory is similarly and intuitively laid out in an
understandable way.
But when I take a look at /usr/local/pgsql/data/base, I am baffled by its
contents. I hear that the directory at: /usr/local/pgsql/data/base/1 is
the template1 database. But I do not know where the template0 database
is. And I certainly do not understand how testtest gets named 16555, much
less what the numbered directories and files subordinate to that directory
have to do with anything real in the world.
Can someone please refer me to a document (preferably off the net, as my
book buying budget is non-existent, these days) which will explain it all
for me? I would certainly appreciate that. Thanks.
-- Hugh Esco
From | Date | Subject | |
---|---|---|---|
Next Message | Lamar Owen | 2002-11-23 06:27:38 | Re: crash help, pgsql 7.2.1 on RH7.3 |
Previous Message | CoL | 2002-11-22 21:30:24 | Re: DB management tool for linux |